DBA Data[Home] [Help]

APPS.INV_REPLENISH_DETAIL_PUB dependencies on MTL_TXN_REQUEST_HEADERS

Line 191: FROM mtl_txn_request_headers

187: WHERE transaction_temp_id = l_transaction_temp_id;
188:
189: CURSOR c_mtrh IS
190: SELECT request_number, grouping_rule_id
191: FROM mtl_txn_request_headers
192: WHERE header_id = l_trolin_tbl(1).header_id;
193:
194: --Bug 6696594
195: Cursor c_mmtt(p_move_order_line_id NUMBER)

Line 1955: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt

1951: SELECT mmtt.organization_id
1952: , mtrh.move_order_type
1953: INTO l_org_id
1954: , l_move_order_type
1955: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
1956: WHERE mmtt.move_order_line_id = mtrl.line_id
1957: AND mtrl.header_id = mtrh.header_id
1958: AND mmtt.transaction_temp_id = p_transaction_temp_id;
1959:

Line 2837: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt

2833: SELECT mmtt.organization_id
2834: , mtrh.move_order_type
2835: INTO l_org_id
2836: , l_move_order_type
2837: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
2838: WHERE mmtt.move_order_line_id = mtrl.line_id
2839: AND mtrl.header_id = mtrh.header_id
2840: AND mmtt.transaction_temp_id = p_transaction_temp_id;
2841: