DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on MTL_ITEM_LOCATIONS

Line 1582: FROM mtl_item_locations mil

1578: SELECT mil.project_id
1579: , mil.task_id
1580: INTO l_project_id
1581: , l_task_id
1582: FROM mtl_item_locations mil
1583: WHERE mil.inventory_location_id = l_m_loc
1584: AND mil.organization_id = p_org_id
1585: AND mil.subinventory_code = l_m_sub;
1586:

Line 7843: FROM mtl_item_locations mil

7839: SELECT mil.project_id
7840: , mil.task_id
7841: INTO l_project_id
7842: , l_task_id
7843: FROM mtl_item_locations mil
7844: WHERE mil.inventory_location_id = l_m_loc
7845: AND mil.organization_id = p_org_id
7846: AND mil.subinventory_code = l_m_sub;
7847: