Saturday, November 8, 2014

mtl_secondary_inventories mtl_material_statuses_tl

SELECT msi.secondary_inventory_name, msi.organization_id, msi.description,
       mmst.status_code, mmst.description
  FROM mtl_secondary_inventories msi, mtl_material_statuses_tl mmst
 WHERE 1 = 1 AND msi.status_id = mmst.status_id


SELECT DISTINCT site.organization_code, sub.secondary_inventory_name, sub.*
           FROM apps.mtl_secondary_inventories sub, apps.mtl_parameters site
          WHERE sub.secondary_inventory_name LIKE 'ISO003208%'
            AND sub.organization_id = site.organization_id
       ORDER BY sub.secondary_inventory_name;

No comments: