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.WMS_MDC_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 102: wsh_delivery_assignments_v wda

98: SELECT wda.delivery_id
99: INTO l_delivery_id
100: FROM mtl_material_transactions_temp mmtt,
101: wsh_delivery_details_ob_grp_v wdd,
102: wsh_delivery_assignments_v wda
103: WHERE mmtt.transfer_lpn_id = p_lpn_id
104: AND mmtt.transaction_action_id = 28
105: AND mmtt.transaction_source_type_id IN (2, 8)
106: AND mmtt.move_order_line_id = wdd.move_order_line_id

Line 123: FROM wsh_delivery_assignments_v wda,

119: ELSIF l_lpn_context IN (12, 11) THEN -- LPN1 has been staged
120: -- 12:Loaded to stage move Context
121: SELECT wda.delivery_id
122: INTO l_delivery_id
123: FROM wsh_delivery_assignments_v wda,
124: wsh_delivery_details_ob_grp_v wdd
125: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
126: AND wdd.lpn_id = p_lpn_id
127: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650

Line 137: wsh_delivery_assignments_v wda

133: BEGIN
134: SELECT wda.delivery_id
135: INTO l_delivery_id
136: FROM mtl_txn_request_lines mtrl,
137: wsh_delivery_assignments_v wda
138: WHERE mtrl.lpn_id IN (SELECT wlpn.lpn_id
139: FROM wms_license_plate_numbers wlpn
140: START WITH wlpn.lpn_id = p_lpn_id
141: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id)