DBA Data[Home] [Help]

APPS.PJM_PROJECT_LOCATOR dependencies on MTL_SECONDARY_INVENTORIES

Line 480: from mtl_secondary_inventories msi

476: -- cases when subinventory code is NULL on mtl_item_locations.
477: --
478: select nvl(msi.locator_type , 0)
479: into L_locator_ctrl
480: from mtl_secondary_inventories msi
481: , mtl_item_locations mil
482: where mil.organization_id = X_organization_id
483: and mil.inventory_location_id = X_locator_id
484: and msi.organization_id (+) = mil.organization_id

Line 1214: FROM mtl_secondary_inventories sub

1210:
1211: BEGIN
1212: SELECT sub.locator_type
1213: INTO l_sub_loc_control
1214: FROM mtl_secondary_inventories sub
1215: WHERE sub.secondary_inventory_name = p_sub
1216: AND sub.organization_id = p_organization_id;
1217:
1218: EXCEPTION