DBA Data[Home] [Help]

APPS.WMS_MDC_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 173: FROM mtl_txn_request_lines mtrl,

169: --There should only be 1 MOL in this LPN
170: BEGIN
171: SELECT wda.delivery_id
172: INTO l_delivery_id
173: FROM mtl_txn_request_lines mtrl,
174: wsh_delivery_assignments_v wda
175: WHERE mtrl.lpn_id IN (SELECT wlpn.lpn_id
176: FROM wms_license_plate_numbers wlpn
177: START WITH wlpn.lpn_id = p_lpn_id

Line 269: mtl_txn_request_lines mtrl

265: SELECT 2
266: INTO l_consolidation_method_id
267: FROM wms_op_plan_details wopd,
268: mtl_material_transactions_temp mmtt,
269: mtl_txn_request_lines mtrl
270: WHERE mtrl.lpn_id IN (SELECT wlpn.lpn_id
271: FROM wms_license_plate_numbers wlpn
272: START WITH wlpn.lpn_id = p_lpn_id
273: CONNECT BY PRIOR wlpn.lpn_id = wlpn.parent_lpn_id)