APPS.FUN_RECON_RPT_PKG dependencies on XLA_AE_HEADERS

Line 165: 'SELECT /*+ Leading(fun_act,aeh,xle) index (aeh XLA_AE_HEADERS_N5)*/

161: $sub_query$
162: ) ';
163:
164: C_FUN_JELINES_SLA_QUERY CONSTANT VARCHAR2(30000) :=
165: 'SELECT /*+ Leading(fun_act,aeh,xle) index (aeh XLA_AE_HEADERS_N5)*/
166: fun_act.TRANSACTING_LE_ID TRANS_LE_ID
167: ,fun_act.TRANSACTING_LE TRANS_LE
168: ,fun_act.TRADING_PARTNER_LE_ID TRAD_LE_ID
169: ,fun_act.TRADING_PARTNER_LE TRAD_LE

Line 241: FROM xla_ae_headers aeh

237: ,ael.code_combination_id CODE_COMBINATION_ID
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

Line 384: FROM xla_ae_headers aeh

380: ,ael.code_combination_id CODE_COMBINATION_ID
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

Line 592: ,xla_ae_headers aeh

588: ,gl_je_batches gjb
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

Line 2099: FROM xla_ae_headers aeh

2095:
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

Line 2148: FROM xla_ae_headers aeh

2144:
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

Line 2200: FROM xla_ae_headers aeh

2196:
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

Line 2248: FROM xla_ae_headers aeh

2244:
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