eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_APPROVAL_MATCHED_PKG dependencies on AP_INVOICES

Line 276: ap_invoices I,

272: ,nvl(I.exchange_rate, 1) -- inv_rate
273: ,nvl(PLL.price_override,0) -- po_price
274: ,PLL.matching_basis -- matching basis./*Amount Based Matching*/
275: FROM ap_invoice_distributions D,
276: ap_invoices I,
277: po_distributions PD,
278: po_line_locations PLL,
279: po_lines PL,
280: rcv_transactions RTXN,

Line 352: l_inv_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;

348: l_rtxn_item_id RCV_SHIPMENT_LINES.ITEM_ID%TYPE;
349: l_corrected_invoice_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
350: l_uom_conv_rate NUMBER := NULL;
351: l_inv_qty AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE :=0;
352: l_inv_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
353: l_po_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
354: l_po_price PO_LINE_LOCATIONS.PRICE_OVERRIDE%TYPE := 0;
355: l_po_erv NUMBER := 0;
356: l_extra_po_erv AP_INVOICE_DISTRIBUTIONS.EXTRA_PO_ERV%TYPE ;

Line 353: l_po_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;

349: l_corrected_invoice_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
350: l_uom_conv_rate NUMBER := NULL;
351: l_inv_qty AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE :=0;
352: l_inv_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
353: l_po_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
354: l_po_price PO_LINE_LOCATIONS.PRICE_OVERRIDE%TYPE := 0;
355: l_po_erv NUMBER := 0;
356: l_extra_po_erv AP_INVOICE_DISTRIBUTIONS.EXTRA_PO_ERV%TYPE ;
357:

Line 1919: ap_invoices I,

1915: FROM po_lines PL,
1916: rcv_transactions RTXN,
1917: rcv_shipment_lines RSL,
1918: ap_invoice_lines L,
1919: ap_invoices I,
1920: po_line_locations PLL,
1921: po_headers PH,
1922: po_releases PR
1923: WHERE I.invoice_id = L.invoice_id

Line 2065: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

2061: l_cancelled_flag ap_invoice_lines.cancelled_flag%TYPE;
2062: l_matching_basis po_line_locations.matching_basis%TYPE; -- Amount Based Matching
2063:
2064: --Contract Payments: Tolerances Redesign
2065: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
2066: l_payment_type po_line_locations_all.payment_type%TYPE;
2067: l_billed_amt NUMBER;
2068: l_amt_delivered NUMBER;
2069: l_amt_corrected NUMBER;

Line 5604: , ap_invoices I

5600: PD.rate, I.exchange_rate)))))
5601: INTO p_ship_base_amt_var
5602: FROM ap_invoice_distributions D
5603: , po_distributions_ap_v PD
5604: , ap_invoices I
5605: , ap_invoice_lines L --Bug6824860
5606: WHERE D.po_distribution_id = PD.po_distribution_id
5607: AND PD.line_location_id = p_line_location_id
5608: AND D.invoice_id = I.invoice_id

Line 5716: ap_invoices AI

5712: ,nvl(L.base_amount, (L.amount * AI.exchange_rate )) )
5713: )
5714: INTO p_ship_base_amt
5715: FROM ap_invoice_lines L,
5716: ap_invoices AI
5717: WHERE AI.invoice_id = L.invoice_id
5718: AND L.po_line_location_id = p_line_location_id
5719: AND ( (L.invoice_id = p_invoice_id and
5720: L.match_type IN ('ITEM_TO_PO', -- query condition 1

Line 5756: ap_invoices AI

5752: ,nvl(L.base_amount, (L.amount * AI.exchange_rate )) )
5753: )
5754: INTO p_ship_base_amt
5755: FROM ap_invoice_lines L,
5756: ap_invoices AI
5757: WHERE AI.invoice_id = L.invoice_id
5758: AND L.po_line_location_id = p_line_location_id
5759: AND ( (L.invoice_id = p_invoice_id and
5760: L.match_type IN ('ITEM_TO_RECEIPT', -- query condition 1