APPS.WMS_DIRECT_SHIP_PVT dependencies on MTL_ITEM_LOCATIONS

Line 456: FROM mtl_item_locations_kfv milk

452: l_missing_count NUMBER;
453: CURSOR lpn_in_other_dock(p_delivery_id NUMBER) IS
454: SELECT milk.concatenated_segments
455: , wstt.outermost_lpn
456: FROM mtl_item_locations_kfv milk
457: ,wms_shipping_transaction_temp wstt
458: WHERE wstt.delivery_id = p_delivery_id
459: AND wstt.organization_id = p_org_id
460: AND wstt.dock_appoint_flag = 'N'

Line 2553: FROM mtl_item_locations_kfv milk, wms_shipping_transaction_temp wstt

2549:
2550: CURSOR lpn_in_other_dock(p_trip_id NUMBER) IS
2551: SELECT DISTINCT milk.concatenated_segments
2552: , wstt.outermost_lpn
2553: FROM mtl_item_locations_kfv milk, wms_shipping_transaction_temp wstt
2554: WHERE wstt.trip_id = p_trip_id
2555: AND wstt.organization_id = p_org_id
2556: AND wstt.dock_appoint_flag = 'N'
2557: AND wstt.direct_ship_flag = 'Y'

Line 8606: FROM mtl_item_locations

8602: SELECT project_id
8603: , task_id
8604: INTO g_project_id
8605: , g_task_id
8606: FROM mtl_item_locations
8607: WHERE inventory_location_id = g_lpn_contents_tab(1).locator_id;
8608:
8609: IF (l_debug = 1) THEN
8610: DEBUG('g_project_id= ' || g_project_id || ' g_task_id= ' || g_task_id, 'Process_LPN');