[Home] [Help]
246: ,ael.code_combination_id CODE_COMBINATION_ID
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
398: ,ael.code_combination_id CODE_COMBINATION_ID
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
615: ,gl_je_batches gjb
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
2201:
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
2250:
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
2302:
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
2350:
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