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 2150: UPDATE mtl_txn_request_lines

2146: END IF;
2147:
2148: l_debug := g_debug;
2149:
2150: UPDATE mtl_txn_request_lines
2151: SET txn_source_line_id = p_new_source_line_id
2152: WHERE line_id = p_line_id;
2153:
2154: UPDATE mtl_material_transactions_temp

Line 2726: FROM mtl_txn_request_headers moh, mtl_txn_request_lines mol

2722: END IF;
2723:
2724: SELECT moh.move_order_type
2725: INTO l_move_order_type
2726: FROM mtl_txn_request_headers moh, mtl_txn_request_lines mol
2727: WHERE mol.line_id = l_trolin_rec.line_id
2728: AND mol.header_id = moh.header_id;
2729:
2730: IF (l_debug = 1) THEN

Line 6221: , mtl_txn_request_lines mtrl

6217:
6218: CURSOR c_mo_type (p_mo_line_id NUMBER) IS
6219: SELECT mtrh.move_order_type
6220: FROM mtl_txn_request_headers mtrh
6221: , mtl_txn_request_lines mtrl
6222: WHERE mtrl.line_id = p_mo_line_id
6223: AND mtrh.header_id = mtrl.header_id;
6224:
6225: l_mo_type NUMBER;