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

575: -- value when label printing is called from cross docking
576: /*CURSOR c_wdd_lpn IS
577: SELECT wdd2.lpn_id, nvl(wdd2.organization_id, wdd1.organization_id)
578: , wdd1.subinventory
579: FROM wsh_delivery_details wdd1, wsh_delivery_details wdd2
580: , wsh_delivery_assignments_v wda
581: WHERE wdd2.delivery_detail_id = p_transaction_id
582: AND wdd1.delivery_detail_id(+) = wda.delivery_detail_id
583: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;

Line 587: FROM wsh_delivery_details wdd, wms_license_plate_numbers wlpn

583: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;
584: */
585: CURSOR c_wdd_lpn IS
586: SELECT wdd.lpn_id, wlpn.organization_id, wlpn.subinventory_code, wlpn.locator_id-- Added locator for Conf Label ER
587: FROM wsh_delivery_details wdd, wms_license_plate_numbers wlpn
588: WHERE wdd.delivery_detail_id = p_transaction_id
589: AND wdd.lpn_id = wlpn.lpn_id;
590:
591:

Line 606: wsh_delivery_details wdd1, wsh_delivery_details wdd2

602:
603: CURSOR c_wnd_lpn IS
604: SELECT DISTINCT wdd2.lpn_id
605: FROM wsh_new_deliveries wnd, wsh_delivery_assignments_v wda,
606: wsh_delivery_details wdd1, wsh_delivery_details wdd2
607: WHERE wnd.delivery_id = p_transaction_id
608: AND wnd.delivery_id = wda.delivery_id
609: AND wdd1.delivery_detail_id = wda.delivery_detail_id
610: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;