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_AAD_MERGE_ANALYSIS_PVT dependencies on XLA_ANALYTICAL_DTLS_B

Line 3728: FROM xla_analytical_dtls_b w

3724: CURSOR c_comp_dtl IS
3725: SELECT w.analytical_criterion_type_code
3726: ,w.analytical_criterion_code
3727: ,w.analytical_detail_code
3728: FROM xla_analytical_dtls_b w
3729: , xla_analytical_hdrs_b b
3730: WHERE b.amb_context_code = g_staging_context_code
3731: AND b.application_id = g_application_id
3732: AND b.analytical_criterion_type_code = w.analytical_criterion_type_code

Line 3738: FROM xla_analytical_dtls_b s

3734: AND w.amb_context_code = g_amb_context_code
3735: AND w.analytical_criterion_type_code = C_OWNER_ORACLE
3736: AND NOT EXISTS
3737: (SELECT 1
3738: FROM xla_analytical_dtls_b s
3739: WHERE s.amb_context_code = g_staging_context_code
3740: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
3741: AND s.analytical_criterion_code = w.analytical_criterion_code
3742: AND s.analytical_detail_code = w.analytical_detail_code);

Line 5510: FROM xla_analytical_dtls_b bs

5506: ,bs.grouping_order s_grouping_order
5507: ,bw.grouping_order w_grouping_order
5508: ,bs.data_type_code s_data_type_code
5509: ,bw.data_type_code w_data_type_code
5510: FROM xla_analytical_dtls_b bs
5511: JOIN xla_analytical_hdrs_b hw
5512: ON hw.amb_context_code = g_amb_context_code
5513: AND hw.analytical_criterion_type_code = bs.analytical_criterion_type_code
5514: AND hw.analytical_criterion_code = bs.analytical_criterion_code

Line 5521: LEFT OUTER JOIN xla_analytical_dtls_b bw

5517: AND ts.analytical_criterion_type_code = bs.analytical_criterion_type_code
5518: AND ts.analytical_criterion_code = bs.analytical_criterion_code
5519: AND ts.analytical_detail_code = bs.analytical_detail_code
5520: AND ts.language = USERENV('LANG')
5521: LEFT OUTER JOIN xla_analytical_dtls_b bw
5522: ON bw.amb_context_code = g_amb_context_code
5523: AND bw.analytical_criterion_type_code = bs.analytical_criterion_type_code
5524: AND bw.analytical_criterion_code = bs.analytical_criterion_code
5525: AND bw.analytical_detail_code = bs.analytical_detail_code

Line 5665: JOIN xla_analytical_dtls_b b

5661: , w.source_type_code w_source_type_code
5662: , w.source_code w_source_code
5663: , w.source_application_id w_source_application_id
5664: FROM xla_analytical_sources s
5665: JOIN xla_analytical_dtls_b b
5666: ON b.amb_context_code = g_amb_context_code
5667: AND b.analytical_criterion_type_code = s.analytical_criterion_type_code
5668: AND b.analytical_criterion_code = s.analytical_criterion_code
5669: AND b.analytical_detail_code = s.analytical_detail_code

Line 5697: , xla_analytical_dtls_b b

5693: , w.source_type_code
5694: , w.source_code
5695: , w.source_application_id
5696: FROM xla_analytical_sources w
5697: , xla_analytical_dtls_b b
5698: WHERE w.amb_context_code = g_amb_context_code
5699: AND b.amb_context_code = g_staging_context_code
5700: AND b.analytical_criterion_type_code = w.analytical_criterion_type_code
5701: AND b.analytical_criterion_code = w.analytical_criterion_code