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_PVT5 dependencies on WSH_DELIVERY_DETAILS

Line 535: FROM wsh_delivery_details wdd1, wsh_delivery_details wdd2

531: -- value when label printing is called from cross docking
532: /*CURSOR c_wdd_lpn IS
533: SELECT wdd2.lpn_id, nvl(wdd2.organization_id, wdd1.organization_id)
534: , wdd1.subinventory
535: FROM wsh_delivery_details wdd1, wsh_delivery_details wdd2
536: , wsh_delivery_assignments_v wda
537: WHERE wdd2.delivery_detail_id = p_transaction_id
538: AND wdd1.delivery_detail_id(+) = wda.delivery_detail_id
539: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;

Line 543: FROM wsh_delivery_details wdd, wms_license_plate_numbers wlpn

539: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;
540: */
541: CURSOR c_wdd_lpn IS
542: SELECT wdd.lpn_id, wlpn.organization_id, wlpn.subinventory_code
543: FROM wsh_delivery_details wdd, wms_license_plate_numbers wlpn
544: WHERE wdd.delivery_detail_id = p_transaction_id
545: AND wdd.lpn_id = wlpn.lpn_id;
546:
547: CURSOR c_wnd_lpn IS

Line 550: , wsh_delivery_details wdd1, wsh_delivery_details wdd2

546:
547: CURSOR c_wnd_lpn IS
548: SELECT wdd2.lpn_id, wdd1.organization_id
549: FROM wsh_new_deliveries wnd, wsh_delivery_assignments_v wda
550: , wsh_delivery_details wdd1, wsh_delivery_details wdd2
551: WHERE wnd.delivery_id = p_transaction_id
552: AND wnd.delivery_id = wda.delivery_id
553: AND wdd1.delivery_detail_id = wda.delivery_detail_id
554: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;