APPS.AP_ETAX_UTILITY_PKG dependencies on RCV_TRANSACTIONS

Line 634: l_transaction_type rcv_transactions.transaction_type%TYPE;

630: l_return_status VARCHAR2(100);
631: l_msg_count NUMBER;
632: l_msg_data VARCHAR2(2000);
633:
634: l_transaction_type rcv_transactions.transaction_type%TYPE;
635:
636: CURSOR receipt_info (c_rcv_transaction IN NUMBER) IS
637: SELECT transaction_date, transaction_type
638: FROM rcv_transactions

Line 638: FROM rcv_transactions

634: l_transaction_type rcv_transactions.transaction_type%TYPE;
635:
636: CURSOR receipt_info (c_rcv_transaction IN NUMBER) IS
637: SELECT transaction_date, transaction_type
638: FROM rcv_transactions
639: WHERE transaction_id = c_rcv_transaction;
640:
641: BEGIN
642:

Line 4160: FROM RCV_TRANSACTIONS

4156: -- Project LCM 7588322
4157: BEGIN
4158: SELECT 'Y'
4159: INTO l_lcm_enabled
4160: FROM RCV_TRANSACTIONS
4161: WHERE TRANSACTION_ID = L_INV_DIST_INS(i).rcv_transaction_id
4162: AND LCM_SHIPMENT_LINE_ID IS NOT NULL;
4163: EXCEPTION
4164: WHEN NO_DATA_FOUND THEN NULL;

Line 5637: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;

5633: l_parent_line_number ap_invoice_lines.line_number%TYPE;
5634: l_discarded_flag ap_invoice_lines.discarded_flag%TYPE;
5635: l_reversal_flag ap_invoice_distributions.reversal_flag%TYPE;
5636: l_po_distribution_id po_distributions.po_distribution_id%TYPE;
5637: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
5638: l_parent_dist_amount ap_invoice_distributions.amount%TYPE;
5639: l_prepay_amount_remaining ap_invoice_distributions.prepay_amount_remaining%TYPE;
5640: l_debug_info VARCHAR2(1000);
5641: l_tax_dist_frozen VARCHAR2(1) := 'N';

Line 7617: rcv_transactions RTXN,

7613: FROM ap_invoice_distributions_all D,
7614: po_distributions_all PD,
7615: po_lines_all PL,
7616: po_line_locations_all PLL,
7617: rcv_transactions RTXN,
7618: rcv_shipment_lines RSL
7619: WHERE D.invoice_distribution_id = c_inv_dist_id
7620: AND D.po_distribution_id = PD.po_distribution_id
7621: AND PL.po_header_id = PD.po_header_id