APPS.AP_APPROVAL_MATCHED_PKG dependencies on AP_INVOICES

Line 298: ap_invoices I,

294: ,nvl(I.exchange_rate, 1) -- inv_rate
295: ,nvl(PLL.price_override,0) -- po_price
296: ,PLL.matching_basis -- matching basis./*Amount Based Matching*/
297: FROM ap_invoice_distributions D,
298: ap_invoices I,
299: po_distributions PD,
300: po_line_locations PLL,
301: po_lines PL,
302: rcv_transactions RTXN,

Line 368: ap_invoices I, --retainage release invoice

364: ,nvl(PLL.price_override,0) -- po_price
365: ,PLL.matching_basis -- matching basis./*Amount Based Matching*/
366: FROM ap_invoice_distributions D, --retainage release inv dists
367: ap_invoice_distributions retain_D, --bug 9242891 retainage invoice dist
368: ap_invoices I, --retainage release invoice
369: ap_invoices retain_I, --bug 9242891 retainage invoice
370: po_distributions PD,
371: po_line_locations PLL,
372: po_lines PL,

Line 369: ap_invoices retain_I, --bug 9242891 retainage invoice

365: ,PLL.matching_basis -- matching basis./*Amount Based Matching*/
366: FROM ap_invoice_distributions D, --retainage release inv dists
367: ap_invoice_distributions retain_D, --bug 9242891 retainage invoice dist
368: ap_invoices I, --retainage release invoice
369: ap_invoices retain_I, --bug 9242891 retainage invoice
370: po_distributions PD,
371: po_line_locations PLL,
372: po_lines PL,
373: rcv_transactions RTXN,

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

444: l_rtxn_item_id RCV_SHIPMENT_LINES.ITEM_ID%TYPE;
445: l_corrected_invoice_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
446: l_uom_conv_rate NUMBER := NULL;
447: l_inv_qty AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE :=0;
448: l_inv_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
449: l_po_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
450: l_po_price PO_LINE_LOCATIONS.PRICE_OVERRIDE%TYPE := 0;
451: l_po_erv NUMBER := 0;
452: l_extra_po_erv AP_INVOICE_DISTRIBUTIONS.EXTRA_PO_ERV%TYPE ;

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

445: l_corrected_invoice_dist_id AP_INVOICE_DISTRIBUTIONS.INVOICE_DISTRIBUTION_ID%TYPE;
446: l_uom_conv_rate NUMBER := NULL;
447: l_inv_qty AP_INVOICE_DISTRIBUTIONS.QUANTITY_INVOICED%TYPE :=0;
448: l_inv_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
449: l_po_rate AP_INVOICES.EXCHANGE_RATE%TYPE := 0;
450: l_po_price PO_LINE_LOCATIONS.PRICE_OVERRIDE%TYPE := 0;
451: l_po_erv NUMBER := 0;
452: l_extra_po_erv AP_INVOICE_DISTRIBUTIONS.EXTRA_PO_ERV%TYPE ;
453:

Line 540: FROM AP_INVOICES_all ai

536:
537: --bug 9242891 select added to determine which cursor to open.
538: SELECT COUNT(*)
539: INTO l_cnt
540: FROM AP_INVOICES_all ai
541: WHERE ai.invoice_id = p_invoice_id
542: AND ai.invoice_type_lookup_code = 'RETAINAGE RELEASE';
543: --bug 9242891
544:

Line 2147: ap_invoices I,

2143: FROM po_lines PL,
2144: rcv_transactions RTXN,
2145: rcv_shipment_lines RSL,
2146: ap_invoice_lines L,
2147: ap_invoices I,
2148: po_line_locations PLL,
2149: po_headers PH,
2150: po_releases PR
2151: WHERE I.invoice_id = L.invoice_id

Line 2293: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

2289: l_cancelled_flag ap_invoice_lines.cancelled_flag%TYPE;
2290: l_matching_basis po_line_locations.matching_basis%TYPE; -- Amount Based Matching
2291:
2292: --Contract Payments: Tolerances Redesign
2293: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
2294: l_payment_type po_line_locations_all.payment_type%TYPE;
2295: l_billed_amt NUMBER;
2296: l_amt_delivered NUMBER;
2297: l_amt_corrected NUMBER;

Line 6017: , ap_invoices I

6013: PD.rate, I.exchange_rate))*/))) /*commented in bug: 14726598 as additional fix*/
6014: INTO p_ship_base_amt_var
6015: FROM ap_invoice_distributions D
6016: , po_distributions_ap_v PD
6017: , ap_invoices I
6018: , ap_invoice_lines L --Bug6824860
6019: WHERE D.po_distribution_id = PD.po_distribution_id
6020: AND PD.line_location_id = p_line_location_id
6021: AND D.invoice_id = I.invoice_id

Line 6037: , ap_invoices I

6033:
6034: SELECT SUM(DECODE(p_inv_curr_code, p_base_curr_code, nvl(D.amount,0),nvl(D.base_amount,D.amount)))
6035: INTO p_ship_base_amt_var
6036: FROM ap_invoice_distributions D
6037: , ap_invoices I
6038: , ap_invoice_lines L
6039: ,rcv_transactions RT
6040: WHERE D.rcv_transaction_id = RT.transaction_id
6041: AND RT.transaction_id=p_rcv_transaction_id

Line 6075: , ap_invoices I

6071: PD.rate, I.exchange_rate))*/))) /*commented in bug: 14726598 as additional fix*/
6072: INTO p_ship_base_amt_var
6073: FROM ap_invoice_distributions D
6074: , po_distributions_ap_v PD
6075: , ap_invoices I
6076: , ap_invoice_lines L --Bug6824860
6077: WHERE D.po_distribution_id = PD.po_distribution_id
6078: AND PD.line_location_id = p_line_location_id
6079: AND D.invoice_id = I.invoice_id

Line 6095: , ap_invoices I

6091:
6092: SELECT SUM(DECODE(p_inv_curr_code, p_base_curr_code, nvl(D.amount,0),nvl(D.base_amount,D.amount)))
6093: INTO p_ship_base_amt_var
6094: FROM ap_invoice_distributions D
6095: , ap_invoices I
6096: , ap_invoice_lines L
6097: ,rcv_transactions RT
6098: WHERE D.rcv_transaction_id = RT.transaction_id
6099: AND RT.transaction_id=p_rcv_transaction_id

Line 6212: ap_invoices AI

6208: ,nvl(L.base_amount, (L.amount * AI.exchange_rate )) )
6209: )
6210: INTO p_ship_base_amt
6211: FROM ap_invoice_lines L,
6212: ap_invoices AI
6213: WHERE AI.invoice_id = L.invoice_id
6214: AND L.po_line_location_id = p_line_location_id
6215: AND ( (L.invoice_id = p_invoice_id and
6216: L.match_type IN ('ITEM_TO_PO', -- query condition 1

Line 6252: ap_invoices AI

6248: ,nvl(L.base_amount, (L.amount * AI.exchange_rate )) )
6249: )
6250: INTO p_ship_base_amt
6251: FROM ap_invoice_lines L,
6252: ap_invoices AI
6253: WHERE AI.invoice_id = L.invoice_id
6254: AND L.rcv_transaction_id = p_rcv_transaction_id /*Added for Bug 14726598 as additional fix*/
6255: AND ( (L.invoice_id = p_invoice_id and
6256: L.match_type IN ('ITEM_TO_RECEIPT', -- query condition 1