APPS.WMS_DIRECT_SHIP_PVT dependencies on MTL_ITEM_LOCATIONS

Line 539: FROM mtl_item_locations_kfv milk

535: l_missing_count NUMBER;
536: CURSOR lpn_in_other_dock(p_delivery_id NUMBER) IS
537: SELECT milk.concatenated_segments
538: , wstt.outermost_lpn
539: FROM mtl_item_locations_kfv milk
540: ,wms_shipping_transaction_temp wstt
541: WHERE wstt.delivery_id = p_delivery_id
542: AND wstt.organization_id = p_org_id
543: AND wstt.dock_appoint_flag = 'N'

Line 2655: FROM mtl_item_locations_kfv milk, wms_shipping_transaction_temp wstt

2651:
2652: CURSOR lpn_in_other_dock(p_trip_id NUMBER) IS
2653: SELECT DISTINCT milk.concatenated_segments
2654: , wstt.outermost_lpn
2655: FROM mtl_item_locations_kfv milk, wms_shipping_transaction_temp wstt
2656: WHERE wstt.trip_id = p_trip_id
2657: AND wstt.organization_id = p_org_id
2658: AND wstt.dock_appoint_flag = 'N'
2659: AND wstt.direct_ship_flag = 'Y'

Line 9743: FROM mtl_item_locations

9739: SELECT project_id
9740: , task_id
9741: INTO g_project_id
9742: , g_task_id
9743: FROM mtl_item_locations
9744: WHERE inventory_location_id = g_lpn_contents_tab(1).locator_id;
9745:
9746: IF (l_debug = 1) THEN
9747: DEBUG('g_project_id= ' || g_project_id || ' g_task_id= ' || g_task_id, 'Process_LPN');