DBA Data[Home] [Help]

APPS.AP_ETAX_SERVICES_PKG dependencies on RCV_SHIPMENT_LINES

Line 7607: FROM rcv_shipment_lines rcv

7603: INTO l_default_ccid
7604: FROM po_distributions_all pd
7605: WHERE pd.line_location_id =
7606: (SELECT rcv.po_line_location_id
7607: FROM rcv_shipment_lines rcv
7608: WHERE rcv.shipment_line_id = l_inv_line_list(i).rcv_shipment_line_id)
7609: AND rownum = 1;
7610:
7611: /* Bug 8230574

Line 8614: FROM rcv_shipment_lines rcv

8610: INTO l_default_ccid
8611: FROM po_distributions_all pd
8612: WHERE pd.line_location_id =
8613: (SELECT rcv.po_line_location_id
8614: FROM rcv_shipment_lines rcv
8615: WHERE rcv.shipment_line_id = P_Inv_Line_List(i).rcv_shipment_line_id)
8616: AND rownum = 1;
8617:
8618: /* Bug 8230574

Line 16498: rcv_shipment_lines RSL

16494: po_distributions_all PD,
16495: po_lines_all PL,
16496: po_line_locations_all PLL,
16497: rcv_transactions RTXN,
16498: rcv_shipment_lines RSL
16499: WHERE D.invoice_distribution_id = c_inv_dist_id
16500: AND D.po_distribution_id = PD.po_distribution_id
16501: AND PL.po_header_id = PD.po_header_id
16502: AND PL.po_line_id = PD.po_line_id

Line 16511: l_rct_item_id rcv_shipment_lines.item_id%TYPE;

16507: l_match_basis po_line_types.matching_basis%TYPE;
16508: l_match_option po_line_locations.match_option%TYPE;
16509: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;
16510: l_rct_uom po_line_locations.unit_meas_lookup_code%TYPE;
16511: l_rct_item_id rcv_shipment_lines.item_id%TYPE;
16512:
16513: l_uom_conv_rate NUMBER;
16514: l_qty_invoiced NUMBER;
16515: l_inv_price NUMBER;