DBA Data[Home] [Help]

APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on RCV_SHIPMENT_LINES

Line 8294: l_rtxn_item_id rcv_shipment_lines.item_id%TYPE;

8290: l_rtxn_rate NUMBER;
8291: l_inv_rate ap_invoices.exchange_rate%TYPE;
8292: l_match_option po_line_locations.match_option%TYPE;
8293: l_rtxn_uom VARCHAR2(25);
8294: l_rtxn_item_id rcv_shipment_lines.item_id%TYPE;
8295: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;
8296: l_distribution_amt ap_invoice_distributions.amount%TYPE;
8297: l_dist_base_amt ap_invoice_distributions.base_amount%TYPE;
8298: l_dist_match_type ap_invoice_distributions.dist_match_type%TYPE;

Line 8352: rcv_shipment_lines RSL,

8348: po_lines PL,
8349: po_line_types PLT, -- Amount Based Matching
8350: po_line_locations PLL,
8351: rcv_transactions RTXN,
8352: rcv_shipment_lines RSL,
8353: AP_INVOICE_LINES_ALL ail --bug#10416960
8354: WHERE AI.invoice_id = D.invoice_id
8355: AND D.invoice_distribution_id = X_distribution_id
8356: AND AIL.invoice_id = D.invoice_id

Line 8425: rcv_shipment_lines RSL

8421: po_lines PL,
8422: po_line_types PLT, -- Amount Based Matching
8423: po_line_locations PLL,
8424: rcv_transactions RTXN,
8425: rcv_shipment_lines RSL
8426: WHERE AI.invoice_id = D.invoice_id
8427: AND AI.invoice_type_lookup_code = 'RETAINAGE RELEASE' --bug 9242891
8428: AND D.retained_invoice_dist_id = retain_d.Invoice_Distribution_Id --bug 9242891
8429: AND retain_ai.invoice_id = retain_D.invoice_id --bug 9242891