APPS.FUN_RECON_RPT_PKG dependencies on XLA_AE_LINES

Line 251: ,xla_ae_lines ael

247: ,fun_trx_entry_util.get_concatenated_account(ael.code_combination_id ) ACCOUNT
248: ,ael.ae_header_id||''-''||ael.ae_line_num EXPAND_ID
249: ,nvl(xsrc.application_id, -1) DRILLDOWN_APP_ID
250: FROM xla_ae_headers aeh
251: ,xla_ae_lines ael
252: ,xla_lookups xlk1
253: ,xla_lookups xlk2
254: ,xla_events xle
255: ,xla_event_types_b xet

Line 403: ,xla_ae_lines ael

399: ,fun_trx_entry_util.get_concatenated_account(ael.code_combination_id ) ACCOUNT
400: ,ael.ae_header_id||''-''||ael.ae_line_num EXPAND_ID
401: ,nvl(xsrc.application_id, -1) DRILLDOWN_APP_ID
402: FROM xla_ae_headers aeh
403: ,xla_ae_lines ael
404: ,xla_lookups xlk1
405: ,xla_lookups xlk2
406: ,xla_events xle
407: ,xla_event_types_b xet

Line 620: ,xla_ae_lines ael

616: ,gl_ledger_le_v glv
617: ,fun_inter_accounts_v fia
618: ,gl_periods glp
619: ,xla_ae_headers aeh
620: ,xla_ae_lines ael
621: ,xla_events xle
622: ,xla_event_types_b xet
623: ,xla_transaction_entities ent
624: ,gl_import_references gir

Line 2206: ,xla_ae_lines ael

2202: SELECT
2203: sum(nvl(ael.entered_cr, 0) - nvl(ael.entered_dr, 0))
2204: INTO l_payables_net_cr
2205: FROM xla_ae_headers aeh
2206: ,xla_ae_lines ael
2207: ,xla_events xle
2208: ,xla_event_types_b xet
2209: ,xla_transaction_entities ent
2210: ,gl_import_references gir

Line 2255: ,xla_ae_lines ael

2251: SELECT
2252: sum(nvl(ael.entered_dr, 0) - nvl(ael.entered_cr, 0))
2253: INTO l_receivables_net_dr
2254: FROM xla_ae_headers aeh
2255: ,xla_ae_lines ael
2256: ,xla_events xle
2257: ,xla_event_types_b xet
2258: ,xla_transaction_entities ent
2259: ,gl_import_references gir

Line 2307: ,xla_ae_lines ael

2303: SELECT
2304: sum(nvl(ael.entered_cr, 0) - nvl(ael.entered_dr, 0))
2305: INTO l_payables_net_cr
2306: FROM xla_ae_headers aeh
2307: ,xla_ae_lines ael
2308: ,xla_events xle
2309: ,xla_event_types_b xet
2310: ,xla_transaction_entities ent
2311: ,gl_import_references gir

Line 2355: ,xla_ae_lines ael

2351: SELECT
2352: sum(nvl(ael.entered_dr, 0) - nvl(ael.entered_cr, 0))
2353: INTO l_receivables_net_dr
2354: FROM xla_ae_headers aeh
2355: ,xla_ae_lines ael
2356: ,xla_events xle
2357: ,xla_event_types_b xet
2358: ,xla_transaction_entities ent
2359: ,gl_import_references gir