DBA Data[Home] [Help]

APPS.GMS_BUDGET_BALANCE dependencies on AP_INVOICE_DISTRIBUTIONS

Line 493: ap_invoice_distributions aid,

489: pet.revenue_category_code,
490: adl.ind_compiled_set_id -- Bug 2387678 (Performance Tuning)
491: from ap_invoices_all ap,
492: gms_award_distributions adl,
493: ap_invoice_distributions aid,
494: gl_period_statuses gps,
495: pa_expenditure_types pet,
496: gl_ledgers g
497: where ap.invoice_id = aid.invoice_id

Line 2215: FROM ap_invoice_distributions aid,

2211: IS
2212:
2213: CURSOR c_get_quantity_invoiced IS
2214: SELECT nvl(sum(aid.quantity_invoiced),0)
2215: FROM ap_invoice_distributions aid,
2216: gms_award_distributions adl
2217: WHERE aid.po_distribution_id = p_po_distribution_id
2218: AND aid.distribution_line_number = adl.distribution_line_number
2219: AND aid.invoice_distribution_id = adl.invoice_distribution_id -- AP Lines change