APPS.JL_ZZ_AP_MONOTRIB_AWT_PKG dependencies on AP_INVOICE_LINES

Line 38: ap_invoice_lines ail,

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
42: AND ai.invoice_id = ail.invoice_id

Line 228: ap_invoice_lines ail,

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
232: AND ail.line_number = aid.invoice_line_number

Line 701: AP_Invoice_Lines apil

697: INTO v_tax_payer_id,
698: v_ship_to_loc,
699: v_line_type
700: FROM AP_Invoice_Distributions apid,
701: AP_Invoice_Lines apil
702: WHERE apid.invoice_id = P_Invoice_Id
703: AND apid.invoice_distribution_id = db_reg.invoice_distribution_id
704: AND apil.line_number = apid.invoice_line_number
705: AND apid.invoice_id = apil.invoice_id;