DBA Data[Home] [Help]

APPS.OPIMPXIN dependencies on MTL_ITEM_LOCATIONS

Line 3616: FROM mtl_item_locations

3612: WHERE IDS_KEY=l_pk;
3613:
3614: CURSOR change_location IS
3615: SELECT physical_location_id
3616: FROM mtl_item_locations
3617: WHERE organization_id = p_organization_id
3618: AND inventory_location_id <> physical_location_id
3619: AND inventory_location_id = p_locator;
3620:

Line 3627: Mtl_item_locations

3623: l_locator := p_locator;
3624:
3625: /* ---------------------------------------------------------------------------------------------------
3626: Fixes bug 1675273. For PJM controlled orgs, MMT/MOQ stores the inv_location_id for the project
3627: Mtl_item_locations
3628: inventory_location_id physical_location_id Projectid
3629: 1 2 P1
3630: 2 2
3631: 3 2 P2