APPS.PO_COPYDOC_SUB dependencies on MTL_SYSTEM_ITEMS

Line 937: FROM MTL_SYSTEM_ITEMS

933: x_progress := '001';
934: BEGIN
935: SELECT distinct 'Y'
936: INTO x_valid_flag
937: FROM MTL_SYSTEM_ITEMS
938: WHERE inventory_item_id = x_item_id
939: AND purchasing_enabled_flag = 'Y'
940: AND organization_id = x_inv_org_id;
941: EXCEPTION

Line 969: FROM MTL_SYSTEM_ITEMS MSI

965: x_progress := '002';
966: BEGIN
967: SELECT distinct 'Y'
968: INTO x_valid_flag
969: FROM MTL_SYSTEM_ITEMS MSI
970: WHERE MSI.inventory_item_id = x_item_id
971: AND MSI.organization_id = x_inv_org_id
972: AND (MSI.outside_operation_flag <> 'Y'
973: OR (MSI.outside_operation_flag = 'Y'

Line 2133: from mtl_system_items msi

2129: and (x_item_id is null
2130: or
2131: (x_item_id is not null
2132: and exists (select null
2133: from mtl_system_items msi
2134: where msi.organization_id = nvl(x_ship_to_organization_id, msi.organization_id)
2135: and msi.inventory_item_id = x_item_id
2136: and (msi.restrict_subinventories_code = 2
2137: or (msi.restrict_subinventories_code = 1