DBA Data[Home] [Help]

APPS.PJM_PROJECT_LOCATOR dependencies on MTL_SECONDARY_LOCATORS

Line 478: insert into mtl_secondary_locators

474: -- Locator control is determined at the item level, we need to
475: -- propagate restricted locators for all items from the original
476: -- locator to the newly created locator
477: --
478: insert into mtl_secondary_locators
479: ( last_update_date
480: , last_updated_by
481: , creation_date
482: , created_by

Line 495: from mtl_secondary_locators msl

491: , L_locator_id
492: , inventory_item_id
493: , X_organization_id
494: , subinventory_code
495: from mtl_secondary_locators msl
496: where organization_id = X_organization_id
497: and secondary_locator = X_locator_id
498: and exists (
499: select 'Locator restriction is on'

Line 1116: FROM MTL_SECONDARY_LOCATORS

1112: AND secondary_inventory = p_sub;
1113:
1114: CURSOR C_ITEM_LOC IS
1115: SELECT 1
1116: FROM MTL_SECONDARY_LOCATORS
1117: WHERE inventory_item_id = p_item_id
1118: AND organization_id = p_organization_id
1119: AND secondary_locator = p_loc;
1120: