DBA Data[Home] [Help]

APPS.CSTPAVCP dependencies on RCV_TRANSACTIONS

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

9656: * Int Req Direct Org Xfr (95, 3, 7),
9657: * Int Order Direct Ship (54, 3, 8): TRX_SOURCE_LINE_ID = OE_ORDER_LINE_ID.LINE_ID
9658: * For Internal Req Intr Rcpt (61, 12, 7) and its adjustment (72, 29, 7):
9659: * TRANSACTION_SOURCE_ID = REQUISITION_HEADER_ID, also RCV_TRANSACTION_ID is populated
9660: * which provides the requisition_line_id from RCV_TRANSACTIONS */
9661: IF ( ( l_txn_action_id = 3
9662: AND l_txn_src_type_id = 7 ) OR
9663: ( l_txn_action_id = 3
9664: AND l_txn_src_type_id = 8 ) OR

Line 9689: RCV_TRANSACTIONS

9685: REQUISITION_LINE_ID
9686: INTO
9687: l_req_line_id
9688: FROM
9689: RCV_TRANSACTIONS
9690: WHERE
9691: TRANSACTION_ID = l_rcv_txn_id;
9692: ELSE
9693: RETURN;