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.

[Home] [Help]

APPS.WMS_MDC_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 136: FROM mtl_txn_request_lines mtrl,

132: --There should only be 1 MOL in this LPN
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

Line 232: mtl_txn_request_lines mtrl

228: SELECT 2
229: INTO l_consolidation_method_id
230: FROM wms_op_plan_details wopd,
231: mtl_material_transactions_temp mmtt,
232: mtl_txn_request_lines mtrl
233: WHERE mtrl.lpn_id IN (SELECT wlpn.lpn_id
234: FROM wms_license_plate_numbers wlpn
235: START WITH wlpn.lpn_id = p_lpn_id
236: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id)