DBA Data[Home] [Help]

APPS.INV_MO_CANCEL_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 208: , mtl_txn_request_headers mtrh

204: BEGIN
205: SELECT NVL(mtrh.move_order_type,0)
206: INTO l_move_order_type
207: FROM mtl_txn_request_lines mtrl
208: , mtl_txn_request_headers mtrh
209: WHERE mtrl.line_id = p_line_id
210: AND mtrh.header_id = mtrl.header_id;
211:
212: IF (l_debug = 1) THEN

Line 1362: , mtl_txn_request_headers mtrh

1358: BEGIN
1359: SELECT NVL(mtrh.move_order_type,0)
1360: INTO l_move_order_type
1361: FROM mtl_txn_request_lines mtrl
1362: , mtl_txn_request_headers mtrh
1363: WHERE mtrl.line_id = p_line_id
1364: AND mtrh.header_id = mtrl.header_id;
1365:
1366: IF (l_debug = 1) THEN

Line 2539: , mtl_txn_request_headers mtrh

2535: ( p_mo_line_id IN NUMBER
2536: ) IS
2537: SELECT mtrh.move_order_type
2538: FROM mtl_txn_request_lines mtrl
2539: , mtl_txn_request_headers mtrh
2540: WHERE mtrl.line_id = p_mo_line_id
2541: AND mtrh.header_id = mtrl.header_id;
2542:
2543: BEGIN