DBA Data[Home] [Help]

APPS.RCV_CREATEACCOUNTING_PVT dependencies on RCV_TRANSACTIONS

Line 1269: RCV_TRANSACTIONS

1265: DECODE( DROPSHIP_TYPE_CODE, 1, 'Y', 2, 'Y', 'N' )
1266: INTO
1267: l_drop_ship
1268: FROM
1269: RCV_TRANSACTIONS
1270: WHERE
1271: TRANSACTION_ID = L_RCV_AE_LINE.RCV_TRANSACTION_ID;
1272:
1273: l_stmt_num := 37;

Line 1651: FROM RCV_TRANSACTIONS

1647: l_stmt_num := 200;
1648:
1649: SELECT nvl(PARENT_TRANSACTION_ID, -1)
1650: INTO l_parent_rcv_txn_id
1651: FROM RCV_TRANSACTIONS
1652: WHERE transaction_id = L_RCV_AE_LINE.RCV_TRANSACTION_ID;
1653:
1654: -- Get DESTINATION_TYPE_CODE from PO_DISTRIBUTIONS
1655: l_stmt_num := 205;

Line 1667: FROM RCV_TRANSACTIONS

1663: l_stmt_num := 210;
1664: IF (l_parent_rcv_txn_id <> -1) THEN
1665: SELECT TRANSACTION_TYPE
1666: INTO l_parent_txn_type
1667: FROM RCV_TRANSACTIONS
1668: WHERE transaction_id = l_parent_rcv_txn_id;
1669: END IF;
1670:
1671: