DBA Data[Home] [Help]

APPS.AP_GET_SUPPLIER_BALANCE_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 164: FROM ap_invoice_distributions AID, ap_invoices AI

160:
161: -- get total dist amount including prepay applications
162: SELECT AI.payment_cross_rate, AI.invoice_currency_code, NVL(SUM(NVL(AID.amount, 0)), 0)
163: INTO l_payment_cross_rate, l_invoice_currency_code, l_invoice_amount
164: FROM ap_invoice_distributions AID, ap_invoices AI
165: WHERE AI.invoice_id = AID.invoice_id
166: AND AI.invoice_id = inv_rec.invoice_id
167: AND (AID.prepay_distribution_id IS NULL OR
168: trunc(AID.accounting_date) <= trunc(p_as_of_date))

Line 354: ap_invoice_distributions aid1,

350: THEN pd.amount
351: ELSE 0
352: END)) over (partition by ai.invoice_id) appl_dist_total
353: FROM ap_invoices ai,
354: ap_invoice_distributions aid1,
355: ap_invoice_distributions pd, --bug13411905
356: fnd_lookup_types_vl lkp,
357: fnd_lookup_values_vl lkv,
358: gl_ledgers gl --bug9050332

Line 355: ap_invoice_distributions pd, --bug13411905

351: ELSE 0
352: END)) over (partition by ai.invoice_id) appl_dist_total
353: FROM ap_invoices ai,
354: ap_invoice_distributions aid1,
355: ap_invoice_distributions pd, --bug13411905
356: fnd_lookup_types_vl lkp,
357: fnd_lookup_values_vl lkv,
358: gl_ledgers gl --bug9050332
359: WHERE 1=1