DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on MTL_ITEM_LOCATIONS

Line 1437: FROM mtl_item_locations mil

1433: SELECT mil.project_id
1434: , mil.task_id
1435: INTO l_project_id
1436: , l_task_id
1437: FROM mtl_item_locations mil
1438: WHERE mil.inventory_location_id = l_m_loc
1439: AND mil.organization_id = p_org_id
1440: AND mil.subinventory_code = l_m_sub;
1441:

Line 7508: FROM mtl_item_locations mil

7504: SELECT mil.project_id
7505: , mil.task_id
7506: INTO l_project_id
7507: , l_task_id
7508: FROM mtl_item_locations mil
7509: WHERE mil.inventory_location_id = l_m_loc
7510: AND mil.organization_id = p_org_id
7511: AND mil.subinventory_code = l_m_sub;
7512: