DBA Data[Home] [Help]

APPS.PJM_PROJECT_LOCATOR dependencies on MTL_SECONDARY_INVENTORIES

Line 465: from mtl_secondary_inventories msi

461: -- cases when subinventory code is NULL on mtl_item_locations.
462: --
463: select nvl(msi.locator_type , 0)
464: into L_locator_ctrl
465: from mtl_secondary_inventories msi
466: , mtl_item_locations mil
467: where mil.organization_id = X_organization_id
468: and mil.inventory_location_id = X_locator_id
469: and msi.organization_id (+) = mil.organization_id

Line 1159: FROM mtl_secondary_inventories sub

1155:
1156: BEGIN
1157: SELECT sub.locator_type
1158: INTO l_sub_loc_control
1159: FROM mtl_secondary_inventories sub
1160: WHERE sub.secondary_inventory_name = p_sub
1161: AND sub.organization_id = p_organization_id;
1162:
1163: EXCEPTION