APPS.AMS_ACTMETRICS_SEED_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 749: FROM OE_SYSTEM_PARAMETERS_ALL OSPA, MTL_SYSTEM_ITEMS_B ITEM

745: AND EXISTS (
746: SELECT 1 FROM DUAL WHERE H.FLOW_STATUS_CODE = G_BOOKED
747: UNION ALL
748: SELECT /*+ FIRST_ROWS */ 1
749: FROM OE_SYSTEM_PARAMETERS_ALL OSPA, MTL_SYSTEM_ITEMS_B ITEM
750: WHERE H.ORG_ID = OSPA.ORG_ID
751: AND I.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID
752: AND NVL(I.SHIP_FROM_ORG_ID, OSPA.MASTER_ORGANIZATION_ID) = ITEM.ORGANIZATION_ID
753: and rownum = 1

Line 1299: SELECT 1 FROM OE_SYSTEM_PARAMETERS_ALL ospa, MTL_SYSTEM_ITEMS_B item

1295: AND EXISTS (
1296: SELECT 1 FROM dual WHERE H.flow_status_code = G_BOOKED
1297: and rownum = 1
1298: UNION ALL
1299: SELECT 1 FROM OE_SYSTEM_PARAMETERS_ALL ospa, MTL_SYSTEM_ITEMS_B item
1300: WHERE H.org_id = ospa.org_id
1301: AND I.inventory_item_id = item.inventory_item_id
1302: AND nvl(I.ship_from_org_id, ospa.master_organization_id) = item.organization_id
1303: and rownum = 1

Line 2335: FROM OE_SYSTEM_PARAMETERS_ALL ospa, MTL_SYSTEM_ITEMS_B item

2331: AND EXISTS (
2332: SELECT 1 FROM dual WHERE H.flow_status_code = 'BOOKED'
2333: UNION ALL
2334: SELECT 1
2335: FROM OE_SYSTEM_PARAMETERS_ALL ospa, MTL_SYSTEM_ITEMS_B item
2336: WHERE H.org_id = ospa.org_id
2337: AND I.inventory_item_id = item.inventory_item_id
2338: AND nvl(I.ship_from_org_id, ospa.master_organization_id) = item.organization_id
2339: and rownum = 1