DBA Data[Home] [Help]

APPS.PJM_PROJECT_LOCATOR dependencies on MTL_TRANSACTIONS_INTERFACE

Line 1547: -- in mtl_transactions_interface should be common

1543: -- for project related flow schedules.
1544: --
1545: -- The assumption for this procedure is that
1546: -- the supply subinventory/locator value of those
1547: -- in mtl_transactions_interface should be common
1548: -- locators.
1549: --
1550: -- Parameters :
1551: -- IN : p_organization_id IN NUMBER

Line 1588: FROM mtl_transactions_interface mti

1584: SELECT mti.inventory_item_id,
1585: mti.subinventory_code,
1586: mti.locator_id,
1587: mti.rowid
1588: FROM mtl_transactions_interface mti
1589: WHERE mti.organization_id = V_org_id
1590: AND ( V_wip_entity_id is null
1591: OR mti.transaction_source_id = V_wip_entity_id )
1592: AND mti.locator_id is not null

Line 1658: update mtl_transactions_interface

1654: raise locator_exe;
1655: else
1656: if l_supply_loc_id <> 0 then
1657: begin
1658: update mtl_transactions_interface
1659: set(locator_id, project_id, task_id) =
1660: (select inventory_location_id, project_id, task_id
1661: from mtl_item_locations
1662: where inventory_location_id = l_supply_loc_id