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

Line 106: FROM wsh_delivery_details

102: WHERE transaction_temp_id = p_transaction_id;
103:
104: CURSOR c_wdd_lpn IS
105: SELECT lpn_id
106: FROM wsh_delivery_details
107: WHERE delivery_detail_id = p_transaction_id;
108:
109: -- Bug 2825748 : WIP is passing a transaction_temp_id instead of
110: -- wip_lpn_completions,header_id for both LPN and non-LPN Completions.

Line 150: , wsh_delivery_details wdd1

146: CURSOR c_wnd_lpn IS
147: SELECT wdd2.lpn_id
148: FROM wsh_new_deliveries wnd
149: , wsh_delivery_assignments_v wda
150: , wsh_delivery_details wdd1
151: , wsh_delivery_details wdd2
152: WHERE wnd.delivery_id = p_transaction_id
153: AND wnd.delivery_id = wda.delivery_id
154: AND wdd1.delivery_detail_id = wda.delivery_detail_id

Line 151: , wsh_delivery_details wdd2

147: SELECT wdd2.lpn_id
148: FROM wsh_new_deliveries wnd
149: , wsh_delivery_assignments_v wda
150: , wsh_delivery_details wdd1
151: , wsh_delivery_details wdd2
152: WHERE wnd.delivery_id = p_transaction_id
153: AND wnd.delivery_id = wda.delivery_id
154: AND wdd1.delivery_detail_id = wda.delivery_detail_id
155: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;