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 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'