APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 98: ap_invoice_distributions_all aid1,

94: sum(nvl(aid1.amount,0)) dist_amount --bug 3338086
95: FROM
96: /*bug 5264865*/
97: ap_invoices_all ai,
98: ap_invoice_distributions_all aid1,
99: fnd_lookup_types_vl lkp,
100: fnd_lookup_values_vl lkv
101: -- 3641604 ap_payment_schedules aps
102: WHERE

Line 391: ap_invoice_distributions aid1,

387: (SUM(nvl(AID1.AMOUNT,0)) -
388: SUM(nvl(AID1.PREPAY_AMOUNT_REMAINING,AID1.AMOUNT)))
389: FROM
390: ap_invoices ai,
391: ap_invoice_distributions aid1,
392: fnd_lookup_types_vl lkp,
393: fnd_lookup_values_vl lkv
394: WHERE
395: ai.invoice_id=aid1.invoice_id

Line 483: FROM ap_invoice_distributions AID, ap_invoices AI

479: 3542467: Get the payment cross rate and invoice currency code
480: */
481: SELECT AI.payment_cross_rate, AI.invoice_currency_code, NVL(SUM(NVL(AID.amount, 0)), 0)
482: INTO v_payment_cross_rate, v_invoice_currency_code, v_invoice_amount
483: FROM ap_invoice_distributions AID, ap_invoices AI
484: WHERE AI.invoice_id = AID.invoice_id
485: AND AI.invoice_id = p_invoice_id
486: GROUP BY AI.payment_cross_rate, AI.invoice_currency_code;
487: