eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_DIRECT_SHIP_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

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'