eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_ACCOUNTING_DUMP_PKG dependencies on XLA_DIAG_LEDGERS

Line 1054: , xla_diag_ledgers xdl

1050: g_array_events.event_class_name,
1051: g_array_events.event_type_name
1052: FROM xla_events xe
1053: , xla_diag_events xde
1054: , xla_diag_ledgers xdl
1055: , xla_subledger_options_v xsov
1056: , xla_event_classes_tl xect
1057: , xla_event_types_tl xett
1058: WHERE xe.application_id = xde.application_id

Line 1310: , xla_diag_ledgers xdl

1306: , xdl.start_date_active start_date
1307: , xdl.end_date_active end_date
1308: FROM xla_events xe
1309: , xla_diag_events xde
1310: , xla_diag_ledgers xdl
1311: , xla_subledger_options_v xso1
1312: , xla_subledger_options_v xso2
1313: , xla_subledger_options_v xso3
1314: , xla_product_rules_tl xpr

Line 1872: , xla_diag_ledgers xdl

1868: , xla_acct_attributes_tl xaat
1869: , xla_sources_tl xstl
1870: , xla_diag_sources xds
1871: , xla_diag_events xde
1872: , xla_diag_ledgers xdl
1873: WHERE xde.event_id = xds.event_id
1874: AND xds.ledger_id = xdl.ledger_id
1875: AND xde.ledger_id = xdl.primary_ledger_id
1876: AND xde.request_id = xdl.accounting_request_id

Line 1908: , xla_diag_ledgers xdl

1904: , xla_acct_attributes_tl xaat
1905: , xla_sources_tl xst
1906: , xla_diag_sources xds
1907: , xla_diag_events xde
1908: , xla_diag_ledgers xdl
1909: WHERE xde.event_id = xds.event_id
1910: AND xds.ledger_id = xdl.ledger_id
1911: AND xde.ledger_id = xdl.primary_ledger_id
1912: AND xde.request_id = xdl.accounting_request_id

Line 2049: , xla_diag_ledgers xdl

2045: , nvl(xst.name, xds.source_code) source_name
2046: , xds.source_value source_value
2047: , xds.source_meaning source_meaning
2048: FROM xla_diag_events xde
2049: , xla_diag_ledgers xdl
2050: , xla_diag_sources xds
2051: , xla_sources_tl xst
2052: , xla_aad_line_defn_assgns xald
2053: , xla_line_defn_jlt_assgns xldj

Line 2143: , xla_diag_ledgers xdl

2139: , xla_acct_attributes_tl xaat
2140: , xla_sources_tl xstl
2141: , xla_diag_sources xds
2142: , xla_diag_events xde
2143: , xla_diag_ledgers xdl
2144: , xla_aad_line_defn_assgns xald
2145: , xla_line_defn_jlt_assgns xldj
2146: , xla_prod_acct_headers xpah
2147: , xla_acct_line_types_tl xaltt

Line 3185: write_logfile('Start purge of xla_diag_ledgers');

3181: END IF;
3182:
3183: write_logfile('Number of rows deleted ='||SQL%ROWCOUNT);
3184: write_logfile('** End ** purge of xla_diag_events');
3185: write_logfile('**Start** purge of xla_diag_ledgers');
3186:
3187:
3188: DELETE FROM xla_diag_ledgers
3189: WHERE application_id = p_application_id

Line 3188: DELETE FROM xla_diag_ledgers

3184: write_logfile('** End ** purge of xla_diag_events');
3185: write_logfile('**Start** purge of xla_diag_ledgers');
3186:
3187:
3188: DELETE FROM xla_diag_ledgers
3189: WHERE application_id = p_application_id
3190: AND primary_ledger_id NOT IN
3191: (SELECT ledger_id
3192: FROM xla_diag_events

Line 3205: write_logfile(' End purge of xla_diag_ledgers');

3201: ,p_level => C_LEVEL_STATEMENT
3202: ,p_module => l_log_module);
3203: END IF;
3204: write_logfile('Number of rows deleted ='||SQL%ROWCOUNT);
3205: write_logfile('** End ** purge of xla_diag_ledgers');
3206: write_logfile('**Start** purge of xla_diag_sources');
3207:
3208: IF l_up_to_date IS NOT NULL AND p_request_id IS NOT NULL THEN
3209: