eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJM_PROJECT_LOCATOR dependencies on MTL_SECONDARY_LOCATORS

Line 493: insert into mtl_secondary_locators

489: -- Locator control is determined at the item level, we need to
490: -- propagate restricted locators for all items from the original
491: -- locator to the newly created locator
492: --
493: insert into mtl_secondary_locators
494: ( last_update_date
495: , last_updated_by
496: , creation_date
497: , created_by

Line 510: from mtl_secondary_locators msl

506: , L_locator_id
507: , inventory_item_id
508: , X_organization_id
509: , subinventory_code
510: from mtl_secondary_locators msl
511: where organization_id = X_organization_id
512: and secondary_locator = X_locator_id
513: and exists (
514: select 'Locator restriction is on'

Line 1171: FROM MTL_SECONDARY_LOCATORS

1167: AND secondary_inventory = p_sub;
1168:
1169: CURSOR C_ITEM_LOC IS
1170: SELECT 1
1171: FROM MTL_SECONDARY_LOCATORS
1172: WHERE inventory_item_id = p_item_id
1173: AND organization_id = p_organization_id
1174: AND secondary_locator = p_loc;
1175: