APPS.FUN_RECON_RPT_PKG dependencies on XLA_AE_LINES

Line 242: ,xla_ae_lines ael

238: ,fun_trx_entry_util.get_concatenated_account(ael.code_combination_id ) ACCOUNT
239: ,ael.ae_header_id||''-''||ael.ae_line_num EXPAND_ID
240: ,nvl(xsrc.application_id, -1) DRILLDOWN_APP_ID
241: FROM xla_ae_headers aeh
242: ,xla_ae_lines ael
243: ,xla_lookups xlk1
244: ,xla_lookups xlk2
245: ,xla_events xle
246: ,xla_event_types_b xet

Line 385: ,xla_ae_lines ael

381: ,fun_trx_entry_util.get_concatenated_account(ael.code_combination_id ) ACCOUNT
382: ,ael.ae_header_id||''-''||ael.ae_line_num EXPAND_ID
383: ,nvl(xsrc.application_id, -1) DRILLDOWN_APP_ID
384: FROM xla_ae_headers aeh
385: ,xla_ae_lines ael
386: ,xla_lookups xlk1
387: ,xla_lookups xlk2
388: ,xla_events xle
389: ,xla_event_types_b xet

Line 593: ,xla_ae_lines ael

589: ,gl_ledger_le_v glv
590: ,fun_inter_accounts_v fia
591: ,gl_periods glp
592: ,xla_ae_headers aeh
593: ,xla_ae_lines ael
594: ,xla_events xle
595: ,xla_event_types_b xet
596: ,xla_transaction_entities ent
597: ,gl_import_references gir

Line 2100: ,xla_ae_lines ael

2096: SELECT
2097: sum(nvl(ael.entered_cr, 0) - nvl(ael.entered_dr, 0))
2098: INTO l_payables_net_cr
2099: FROM xla_ae_headers aeh
2100: ,xla_ae_lines ael
2101: ,xla_events xle
2102: ,xla_event_types_b xet
2103: ,xla_transaction_entities ent
2104: ,gl_import_references gir

Line 2149: ,xla_ae_lines ael

2145: SELECT
2146: sum(nvl(ael.entered_dr, 0) - nvl(ael.entered_cr, 0))
2147: INTO l_receivables_net_dr
2148: FROM xla_ae_headers aeh
2149: ,xla_ae_lines ael
2150: ,xla_events xle
2151: ,xla_event_types_b xet
2152: ,xla_transaction_entities ent
2153: ,gl_import_references gir

Line 2201: ,xla_ae_lines ael

2197: SELECT
2198: sum(nvl(ael.entered_cr, 0) - nvl(ael.entered_dr, 0))
2199: INTO l_payables_net_cr
2200: FROM xla_ae_headers aeh
2201: ,xla_ae_lines ael
2202: ,xla_events xle
2203: ,xla_event_types_b xet
2204: ,xla_transaction_entities ent
2205: ,gl_import_references gir

Line 2249: ,xla_ae_lines ael

2245: SELECT
2246: sum(nvl(ael.entered_dr, 0) - nvl(ael.entered_cr, 0))
2247: INTO l_receivables_net_dr
2248: FROM xla_ae_headers aeh
2249: ,xla_ae_lines ael
2250: ,xla_events xle
2251: ,xla_event_types_b xet
2252: ,xla_transaction_entities ent
2253: ,gl_import_references gir