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 95: FROM wsh_delivery_details

91: WHERE transaction_temp_id = p_transaction_id;
92:
93: CURSOR c_wdd_lpn IS
94: SELECT lpn_id
95: FROM wsh_delivery_details
96: WHERE delivery_detail_id = p_transaction_id;
97:
98: -- Bug 2825748 : WIP is passing a transaction_temp_id instead of
99: -- wip_lpn_completions,header_id for both LPN and non-LPN Completions.

Line 123: , wsh_delivery_details wdd1

119: CURSOR c_wnd_lpn IS
120: SELECT wdd2.lpn_id
121: FROM wsh_new_deliveries wnd
122: , wsh_delivery_assignments_v wda
123: , wsh_delivery_details wdd1
124: , wsh_delivery_details wdd2
125: WHERE wnd.delivery_id = p_transaction_id
126: AND wnd.delivery_id = wda.delivery_id
127: AND wdd1.delivery_detail_id = wda.delivery_detail_id

Line 124: , wsh_delivery_details wdd2

120: SELECT wdd2.lpn_id
121: FROM wsh_new_deliveries wnd
122: , wsh_delivery_assignments_v wda
123: , wsh_delivery_details wdd1
124: , wsh_delivery_details wdd2
125: WHERE wnd.delivery_id = p_transaction_id
126: AND wnd.delivery_id = wda.delivery_id
127: AND wdd1.delivery_detail_id = wda.delivery_detail_id
128: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;