DBA Data[Home] [Help]

APPS.INV_TRANSFER_ORDER_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 132: FROM mtl_txn_request_lines

128: l_dummy VARCHAR2(1);
129: BEGIN
130: SELECT 'X'
131: INTO l_dummy
132: FROM mtl_txn_request_lines
133: WHERE header_id = p_header_id
134: AND organization_id = p_organization_id
135: AND line_number = p_line_number;
136:

Line 2163: UPDATE mtl_txn_request_lines

2159: END IF;
2160:
2161: l_debug := g_debug;
2162:
2163: UPDATE mtl_txn_request_lines
2164: SET txn_source_line_id = p_new_source_line_id
2165: WHERE line_id = p_line_id;
2166:
2167: UPDATE mtl_material_transactions_temp

Line 2824: FROM mtl_txn_request_headers moh, mtl_txn_request_lines mol

2820: END IF;
2821:
2822: SELECT moh.move_order_type
2823: INTO l_move_order_type
2824: FROM mtl_txn_request_headers moh, mtl_txn_request_lines mol
2825: WHERE mol.line_id = l_trolin_rec.line_id
2826: AND mol.header_id = moh.header_id;
2827:
2828: IF (l_debug = 1) THEN

Line 6654: , mtl_txn_request_lines mtrl

6650:
6651: CURSOR c_mo_type (p_mo_line_id NUMBER) IS
6652: SELECT mtrh.move_order_type
6653: FROM mtl_txn_request_headers mtrh
6654: , mtl_txn_request_lines mtrl
6655: WHERE mtrl.line_id = p_mo_line_id
6656: AND mtrh.header_id = mtrl.header_id;
6657:
6658: l_mo_type NUMBER;