APPS.AP_ETAX_UTILITY_PKG dependencies on RCV_TRANSACTIONS

Line 767: l_transaction_type rcv_transactions.transaction_type%TYPE;

763: l_return_status VARCHAR2(100);
764: l_msg_count NUMBER;
765: l_msg_data VARCHAR2(2000);
766:
767: l_transaction_type rcv_transactions.transaction_type%TYPE;
768:
769: l_api_name CONSTANT VARCHAR2(100) := 'Get_Receipt_Info';
770:
771: CURSOR receipt_info (c_rcv_transaction IN NUMBER) IS

Line 773: FROM rcv_transactions

769: l_api_name CONSTANT VARCHAR2(100) := 'Get_Receipt_Info';
770:
771: CURSOR receipt_info (c_rcv_transaction IN NUMBER) IS
772: SELECT transaction_date, transaction_type
773: FROM rcv_transactions
774: WHERE transaction_id = c_rcv_transaction;
775:
776: BEGIN
777:

Line 5017: FROM RCV_TRANSACTIONS

5013: -- Project LCM 7588322
5014: BEGIN
5015: SELECT 'Y'
5016: INTO l_lcm_enabled
5017: FROM RCV_TRANSACTIONS
5018: WHERE TRANSACTION_ID = L_INV_DIST_INS(i).rcv_transaction_id
5019: AND LCM_SHIPMENT_LINE_ID IS NOT NULL;
5020: EXCEPTION
5021: WHEN NO_DATA_FOUND THEN NULL;

Line 6865: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;

6861: l_parent_line_number ap_invoice_lines.line_number%TYPE;
6862: l_discarded_flag ap_invoice_lines.discarded_flag%TYPE;
6863: l_reversal_flag ap_invoice_distributions.reversal_flag%TYPE;
6864: l_po_distribution_id po_distributions.po_distribution_id%TYPE;
6865: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
6866: l_parent_dist_amount ap_invoice_distributions.amount%TYPE;
6867: l_prepay_amount_remaining ap_invoice_distributions.prepay_amount_remaining%TYPE;
6868: l_debug_info VARCHAR2(1000);
6869: l_tax_dist_frozen VARCHAR2(1) := 'N';

Line 9805: rcv_transactions RTXN,

9801: FROM ap_invoice_distributions_all D,
9802: po_distributions_all PD,
9803: po_lines_all PL,
9804: po_line_locations_all PLL,
9805: rcv_transactions RTXN,
9806: rcv_shipment_lines RSL
9807: WHERE D.invoice_distribution_id = c_inv_dist_id
9808: AND D.po_distribution_id = PD.po_distribution_id
9809: AND PL.po_header_id = PD.po_header_id

Line 10543: FROM rcv_transactions rcv

10539: INTO l_default_ccid
10540: FROM po_distributions_all pd
10541: WHERE pd.line_location_id =
10542: (SELECT rcv.po_line_location_id
10543: FROM rcv_transactions rcv
10544: WHERE rcv.transaction_id = p_rcv_transaction_id )
10545: AND rownum = 1;
10546:
10547: ELSE