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 548: FROM wsh_delivery_details wdd1, wsh_delivery_details wdd2

544: -- value when label printing is called from cross docking
545: /*CURSOR c_wdd_lpn IS
546: SELECT wdd2.lpn_id, nvl(wdd2.organization_id, wdd1.organization_id)
547: , wdd1.subinventory
548: FROM wsh_delivery_details wdd1, wsh_delivery_details wdd2
549: , wsh_delivery_assignments_v wda
550: WHERE wdd2.delivery_detail_id = p_transaction_id
551: AND wdd1.delivery_detail_id(+) = wda.delivery_detail_id
552: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;

Line 556: FROM wsh_delivery_details wdd, wms_license_plate_numbers wlpn

552: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;
553: */
554: CURSOR c_wdd_lpn IS
555: SELECT wdd.lpn_id, wlpn.organization_id, wlpn.subinventory_code, wlpn.locator_id-- Added locator for Conf Label ER
556: FROM wsh_delivery_details wdd, wms_license_plate_numbers wlpn
557: WHERE wdd.delivery_detail_id = p_transaction_id
558: AND wdd.lpn_id = wlpn.lpn_id;
559:
560: CURSOR c_wnd_lpn IS

Line 563: , wsh_delivery_details wdd1, wsh_delivery_details wdd2

559:
560: CURSOR c_wnd_lpn IS
561: SELECT DISTINCT wdd2.lpn_id, wdd1.organization_id /*8736862-added distinct*/
562: FROM wsh_new_deliveries wnd, wsh_delivery_assignments_v wda
563: , wsh_delivery_details wdd1, wsh_delivery_details wdd2
564: WHERE wnd.delivery_id = p_transaction_id
565: AND wnd.delivery_id = wda.delivery_id
566: AND wdd1.delivery_detail_id = wda.delivery_detail_id
567: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;