DBA Data[Home] [Help]

APPS.AP_BAL_PKG dependencies on AP_INVOICES

Line 121: AND fdfcu.descriptive_flexfield_name = 'AP_INVOICES'

117: FROM fnd_descr_flex_col_usage_vl fdfcu
118: ,fnd_flex_values_vl ffv
119: WHERE fdfcu.flex_value_set_id = ffv.flex_value_set_id
120: AND fdfcu.application_id = 200
121: AND fdfcu.descriptive_flexfield_name = 'AP_INVOICES'
122: AND fdfcu.descriptive_flex_context_code ='Global Data Elements'
123: AND fdfcu.application_column_name = p_seg_type
124: AND ffv.flex_value = p_seg_value;
125: END IF;

Line 321: FROM ap_invoices ai

317: ln_inv_amt_ent NUMBER;
318: BEGIN
319: SELECT NVL(sum(NVL(xdl.unrounded_ENTERED_dR,0)-NVL(xdl.unrounded_entered_cr,0)),0)
320: INTO ln_inv_amt_ent
321: FROM ap_invoices ai
322: ,ap_invoice_distributions aid
323: ,ap_invoice_distributions aidinv
324: ,ap_invoices aiinv
325: ,xla_events xe

Line 324: ,ap_invoices aiinv

320: INTO ln_inv_amt_ent
321: FROM ap_invoices ai
322: ,ap_invoice_distributions aid
323: ,ap_invoice_distributions aidinv
324: ,ap_invoices aiinv
325: ,xla_events xe
326: ,xla_ae_lines xal
327: ,xla_distribution_links xdl
328: WHERE ai.invoice_id=p_invoice_id