APPS.PJM_PROJECT_LOCATOR dependencies on MTL_TRANSACTIONS_INTERFACE

Line 1488: -- in mtl_transactions_interface should be common

1484: -- for project related flow schedules.
1485: --
1486: -- The assumption for this procedure is that
1487: -- the supply subinventory/locator value of those
1488: -- in mtl_transactions_interface should be common
1489: -- locators.
1490: --
1491: -- Parameters :
1492: -- IN : p_organization_id IN NUMBER

Line 1529: FROM mtl_transactions_interface mti

1525: SELECT mti.inventory_item_id,
1526: mti.subinventory_code,
1527: mti.locator_id,
1528: mti.rowid
1529: FROM mtl_transactions_interface mti
1530: WHERE mti.organization_id = V_org_id
1531: AND ( V_wip_entity_id is null
1532: OR mti.transaction_source_id = V_wip_entity_id )
1533: AND mti.locator_id is not null

Line 1599: update mtl_transactions_interface

1595: raise locator_exe;
1596: else
1597: if l_supply_loc_id <> 0 then
1598: begin
1599: update mtl_transactions_interface
1600: set(locator_id, project_id, task_id) =
1601: (select inventory_location_id, project_id, task_id
1602: from mtl_item_locations
1603: where inventory_location_id = l_supply_loc_id