DBA Data[Home] [Help]

APPS.AP_BAL_PKG dependencies on AP_INVOICES

Line 128: AND fdfcu.descriptive_flexfield_name = 'AP_INVOICES'

124: FROM fnd_descr_flex_col_usage_vl fdfcu
125: ,fnd_flex_values_vl ffv
126: WHERE fdfcu.flex_value_set_id = ffv.flex_value_set_id
127: AND fdfcu.application_id = 200
128: AND fdfcu.descriptive_flexfield_name = 'AP_INVOICES'
129: AND fdfcu.descriptive_flex_context_code ='Global Data Elements'
130: AND fdfcu.application_column_name = p_seg_type
131: AND ffv.flex_value = p_seg_value;
132: END IF;

Line 330: FROM ap_invoices ai

326:
327: /* bug#12697320 modified the joins to access XAL first and then XDL */
328: SELECT NVL(sum(NVL(xdl.unrounded_ENTERED_dR,0)-NVL(xdl.unrounded_entered_cr,0)),0)
329: INTO ln_inv_amt_ent
330: FROM ap_invoices ai
331: ,ap_invoice_distributions aid
332: ,ap_invoice_distributions aidinv
333: ,ap_invoices aiinv
334: ,xla_ae_headers xah --Perf 7511696 events replaced with headers

Line 333: ,ap_invoices aiinv

329: INTO ln_inv_amt_ent
330: FROM ap_invoices ai
331: ,ap_invoice_distributions aid
332: ,ap_invoice_distributions aidinv
333: ,ap_invoices aiinv
334: ,xla_ae_headers xah --Perf 7511696 events replaced with headers
335: ,xla_ae_lines xal
336: ,xla_distribution_links xdl
337: WHERE ai.invoice_id=p_invoice_id