DBA Data[Home] [Help]

APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on RCV_SHIPMENT_LINES

Line 6795: l_rtxn_item_id rcv_shipment_lines.item_id%TYPE;

6791: l_rtxn_rate NUMBER;
6792: l_inv_rate ap_invoices.exchange_rate%TYPE;
6793: l_match_option po_line_locations.match_option%TYPE;
6794: l_rtxn_uom VARCHAR2(25);
6795: l_rtxn_item_id rcv_shipment_lines.item_id%TYPE;
6796: l_po_uom po_line_locations.unit_meas_lookup_code%TYPE;
6797: l_distribution_amt ap_invoice_distributions.amount%TYPE;
6798: l_dist_base_amt ap_invoice_distributions.base_amount%TYPE;
6799: l_dist_match_type ap_invoice_distributions.dist_match_type%TYPE;

Line 6851: rcv_shipment_lines RSL

6847: po_lines PL,
6848: po_line_types PLT, -- Amount Based Matching
6849: po_line_locations PLL,
6850: rcv_transactions RTXN,
6851: rcv_shipment_lines RSL
6852: WHERE AI.invoice_id = D.invoice_id
6853: AND D.invoice_distribution_id = X_distribution_id
6854: AND nvl(ASP.org_id, -999) = nvl(AI.org_id,-999)
6855: AND nvl(AI.org_id,-999) = nvl(D.org_id,-999)