DBA Data[Home] [Help]

APPS.WSH_IB_UI_RECON_GRP dependencies on RCV_TRANSACTIONS

Line 1762: -- rcv_transactions table for the corresponding shipment_line_id.

1758: and transaction_type IN ('RECEIPT_ADD', 'RECEIPT_CORRECTION_POSITIVE', 'RECEIPT_CORRECTION_NEGATIVE', 'RTV', 'RTV_CORRECTION_NEGATIVE', 'RTV_CORRECTION_POSITIVE')
1759: order by txn_type;
1760:
1761: -- This cursor is used to check whether there is atleast one record in
1762: -- rcv_transactions table for the corresponding shipment_line_id.
1763: cursor l_chk_receipt_txn_csr(p_shipment_line_id IN NUMBER) is
1764: select 'X'
1765: from rcv_transactions
1766: where shipment_line_id = p_shipment_line_id

Line 1765: from rcv_transactions

1761: -- This cursor is used to check whether there is atleast one record in
1762: -- rcv_transactions table for the corresponding shipment_line_id.
1763: cursor l_chk_receipt_txn_csr(p_shipment_line_id IN NUMBER) is
1764: select 'X'
1765: from rcv_transactions
1766: where shipment_line_id = p_shipment_line_id
1767: and transaction_type in ('RECEIVE', 'MATCH')
1768: and rownum=1;
1769: