APPS.CSTPAVCP dependencies on RCV_TRANSACTIONS

Line 9463: * which provides the requisition_line_id from RCV_TRANSACTIONS */

9459: * Int Req Direct Org Xfr (95, 3, 7),
9460: * Int Order Direct Ship (54, 3, 8): TRX_SOURCE_LINE_ID = OE_ORDER_LINE_ID.LINE_ID
9461: * For Internal Req Intr Rcpt (61, 12, 7) and its adjustment (72, 29, 7):
9462: * TRANSACTION_SOURCE_ID = REQUISITION_HEADER_ID, also RCV_TRANSACTION_ID is populated
9463: * which provides the requisition_line_id from RCV_TRANSACTIONS */
9464: IF ( ( l_txn_action_id = 3
9465: AND l_txn_src_type_id = 7 ) OR
9466: ( l_txn_action_id = 3
9467: AND l_txn_src_type_id = 8 ) OR

Line 9492: RCV_TRANSACTIONS

9488: REQUISITION_LINE_ID
9489: INTO
9490: l_req_line_id
9491: FROM
9492: RCV_TRANSACTIONS
9493: WHERE
9494: TRANSACTION_ID = l_rcv_txn_id;
9495: ELSE
9496: RETURN;