DBA Data[Home] [Help]

APPS.INV_REPLENISH_DETAIL_PUB dependencies on MTL_TXN_REQUEST_HEADERS

Line 203: FROM mtl_txn_request_headers

199: WHERE transaction_temp_id = l_transaction_temp_id;
200:
201: CURSOR c_mtrh IS
202: SELECT request_number, grouping_rule_id
203: FROM mtl_txn_request_headers
204: WHERE header_id = l_trolin_tbl(1).header_id;
205:
206: --Bug 6696594
207: Cursor c_mmtt(p_move_order_line_id NUMBER)

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

2177: SELECT mmtt.organization_id
2178: , mtrh.move_order_type
2179: INTO l_org_id
2180: , l_move_order_type
2181: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
2182: WHERE mmtt.move_order_line_id = mtrl.line_id
2183: AND mtrl.header_id = mtrh.header_id
2184: AND mmtt.transaction_temp_id = p_transaction_temp_id;
2185:

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

3187: SELECT mmtt.organization_id
3188: , mtrh.move_order_type
3189: INTO l_org_id
3190: , l_move_order_type
3191: FROM mtl_txn_request_headers mtrh, mtl_txn_request_lines mtrl, mtl_material_transactions_temp mmtt
3192: WHERE mmtt.move_order_line_id = mtrl.line_id
3193: AND mtrl.header_id = mtrh.header_id
3194: AND mmtt.transaction_temp_id = p_transaction_temp_id;
3195: