APPS.JL_ZZ_AP_MONOTRIB_AWT_PKG dependencies on AP_INVOICES

Line 37: FROM ap_invoices ai,

33: ,ai.invoice_date invoice_date
34: ,ai.payment_status_flag invoice_status
35: ,ai.global_attribute13 dgi_type
36: ,SUM(DECODE(ai.invoice_currency_code, 'ARS', aid.amount, aid.base_amount)) invoice_amt
37: FROM ap_invoices ai,
38: ap_invoice_lines ail,
39: ap_invoice_distributions aid
40: WHERE ai.vendor_id = p_supplier_id
41: AND ai.invoice_id = aid.invoice_id

Line 161: FROM AP_INVOICES

157:
158: BEGIN
159: SELECT max(invoice_date), trunc(add_months(max(invoice_date), -11),'MM')
160: INTO v_to_date, v_from_date
161: FROM AP_INVOICES
162: WHERE vendor_id = c_supp_rec(i_supp).supplier_id
163: AND cancelled_date IS NULL --BUG 9792829
164: AND invoice_date <= P_REPORT_DATE;
165:

Line 227: FROM ap_invoices ai,

223: SELECT DECODE(ai.invoice_currency_code,'ARS',ai.invoice_amount,ai.base_amount),
224: SUM(DECODE(ail.line_type_lookup_code,'TAX',(DECODE(ai.invoice_currency_code,'ARS', AID.amount, AID.base_amount)),0))
225: INTO v_inv_amt,
226: v_inv_tax_amt
227: FROM ap_invoices ai,
228: ap_invoice_lines ail,
229: ap_invoice_distributions aid
230: WHERE ai.invoice_id = AID.invoice_id
231: AND ai.invoice_id = ail.invoice_id

Line 670: ( P_Invoice_Id IN ap_invoices_all.invoice_id%TYPE

666: END Update_Supplier_Applicability;
667:
668:
669: PROCEDURE Update_Monotrib_Inv_Distrib_Wh
670: ( P_Invoice_Id IN ap_invoices_all.invoice_id%TYPE
671: , P_vendor_id IN po_vendors.vendor_id%Type
672: --, P_Defaulting_flag BOOLEAN
673: ) IS
674: CURSOR Invoice_Distrib IS