APPS.INV_TRANSFER_ORDER_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 91: SELECT mtl_txn_request_headers_s.NEXTVAL

87: l_dummy VARCHAR2(1);
88: l_request_number_ok BOOLEAN := FALSE;
89: BEGIN
90: WHILE NOT l_request_number_ok LOOP
91: SELECT mtl_txn_request_headers_s.NEXTVAL
92: INTO l_header_id
93: FROM DUAL;
94:
95: BEGIN

Line 98: FROM mtl_txn_request_headers

94:
95: BEGIN
96: SELECT 'X'
97: INTO l_dummy
98: FROM mtl_txn_request_headers
99: WHERE request_number = TO_CHAR(l_header_id)
100: AND organization_id = NVL(p_organization_id, organization_id);
101: EXCEPTION
102: WHEN NO_DATA_FOUND THEN

Line 116: FROM mtl_txn_request_headers

112: l_dummy VARCHAR2(1);
113: BEGIN
114: SELECT 'X'
115: INTO l_dummy
116: FROM mtl_txn_request_headers
117: WHERE request_number = p_request_number
118: AND organization_id = p_organization_id;
119:
120: RETURN FALSE;

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 6220: FROM mtl_txn_request_headers mtrh

6216: AND (nvl(transaction_status,1) = 2 OR error_code IS NOT NULL));
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: