APPS.WMS_TASK_DISPATCH_GEN dependencies on MTL_TXN_REQUEST_HEADERS

Line 8161: FROM mtl_txn_request_headers mtrh

8157: , mmtt.wip_entity_type
8158: INTO l_mmtt_mo_type
8159: , l_mmtt_txn_type_id
8160: , l_mmtt_wip_entity_type
8161: FROM mtl_txn_request_headers mtrh
8162: , mtl_txn_request_lines mtrl
8163: , mtl_material_transactions_temp mmtt
8164: WHERE mtrh.header_id = mtrl.header_id
8165: AND mtrl.line_id = mmtt.move_order_line_id

Line 8175: FROM mtl_txn_request_headers mtrh

8171: SELECT mtrh.move_order_type
8172: , mmtt.wip_entity_type
8173: INTO l_mo_type_in_lpn
8174: , l_wip_entity_type_in_lpn
8175: FROM mtl_txn_request_headers mtrh
8176: , mtl_txn_request_lines mtrl
8177: , mtl_material_transactions_temp mmtt
8178: WHERE mtrh.header_id = mtrl.header_id
8179: AND mtrl.line_id = mmtt.move_order_line_id

Line 13572: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl

13568: , mtrl.quantity
13569: , mtrl.uom_code
13570: , nvl(mtrl.quantity_delivered,0)
13571: , mtrl.line_status --bug3139307
13572: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl
13573: WHERE mtrl.line_id = l_mo_line_id
13574: AND mtrh.header_id = mtrl.header_id;
13575:
13576: CURSOR c_get_other_mmtt IS

Line 14207: FROM mtl_txn_request_headers mtrh, -- mo header for the new task

14203:
14204:
14205: SELECT mtrh.move_order_type
14206: INTO l_mmtt_mo_type
14207: FROM mtl_txn_request_headers mtrh, -- mo header for the new task
14208: mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
14209: WHERE mtrh.header_id = mtrl.header_id
14210: AND mtrl.line_id = mmtt.move_order_line_id
14211: AND mmtt.transaction_temp_id = p_temp_id;