DBA Data[Home] [Help]

APPS.AP_ETAX_UTILITY_PKG dependencies on RCV_SHIPMENT_LINES

Line 9806: rcv_shipment_lines RSL

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
9810: AND PL.po_line_id = PD.po_line_id

Line 9819: l_rct_item_id rcv_shipment_lines.item_id%TYPE;

9815: l_match_basis po_line_types.matching_basis%TYPE;
9816: l_match_option po_line_locations.match_option%TYPE;
9817: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;
9818: l_rct_uom po_line_locations.unit_meas_lookup_code%TYPE;
9819: l_rct_item_id rcv_shipment_lines.item_id%TYPE;
9820: l_api_name CONSTANT VARCHAR2(100) := 'Get_Converted_Price';
9821: l_debug_info VARCHAR2(240);
9822:
9823: l_uom_conv_rate NUMBER;

Line 10531: FROM rcv_shipment_lines rcv

10527: INTO l_default_ccid
10528: FROM po_distributions_all pd
10529: WHERE pd.line_location_id =
10530: (SELECT rcv.po_line_location_id
10531: FROM rcv_shipment_lines rcv
10532: WHERE rcv.shipment_line_id = p_rcv_shipment_line_id )
10533: AND rownum = 1;
10534:
10535: ELSIF p_rcv_transaction_id IS NOT NULL THEN