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.INV_LABEL_PVT4 dependencies on WSH_DELIVERY_DETAILS

Line 526: FROM wsh_delivery_details wdd1, wsh_delivery_details wdd2

522: -- value when label printing is called from cross docking
523: /*CURSOR c_wdd_lpn IS
524: SELECT wdd2.lpn_id, nvl(wdd2.organization_id, wdd1.organization_id)
525: , wdd1.subinventory
526: FROM wsh_delivery_details wdd1, wsh_delivery_details wdd2
527: , wsh_delivery_assignments_v wda
528: WHERE wdd2.delivery_detail_id = p_transaction_id
529: AND wdd1.delivery_detail_id(+) = wda.delivery_detail_id
530: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;

Line 534: FROM wsh_delivery_details wdd, wms_license_plate_numbers wlpn

530: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;
531: */
532: CURSOR c_wdd_lpn IS
533: SELECT wdd.lpn_id, wlpn.organization_id, wlpn.subinventory_code
534: FROM wsh_delivery_details wdd, wms_license_plate_numbers wlpn
535: WHERE wdd.delivery_detail_id = p_transaction_id
536: AND wdd.lpn_id = wlpn.lpn_id;
537:
538:

Line 553: wsh_delivery_details wdd1, wsh_delivery_details wdd2

549:
550: CURSOR c_wnd_lpn IS
551: SELECT DISTINCT wdd2.lpn_id
552: FROM wsh_new_deliveries wnd, wsh_delivery_assignments_v wda,
553: wsh_delivery_details wdd1, wsh_delivery_details wdd2
554: WHERE wnd.delivery_id = p_transaction_id
555: AND wnd.delivery_id = wda.delivery_id
556: AND wdd1.delivery_detail_id = wda.delivery_detail_id
557: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;