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 5506: FROM xla_analytical_dtls_b bs

5502: ,bs.grouping_order s_grouping_order
5503: ,bw.grouping_order w_grouping_order
5504: ,bs.data_type_code s_data_type_code
5505: ,bw.data_type_code w_data_type_code
5506: FROM xla_analytical_dtls_b bs
5507: JOIN xla_analytical_hdrs_b hw
5508: ON hw.amb_context_code = g_amb_context_code
5509: AND hw.analytical_criterion_type_code = bs.analytical_criterion_type_code
5510: AND hw.analytical_criterion_code = bs.analytical_criterion_code

Line 5517: LEFT OUTER JOIN xla_analytical_dtls_b bw

5513: AND ts.analytical_criterion_type_code = bs.analytical_criterion_type_code
5514: AND ts.analytical_criterion_code = bs.analytical_criterion_code
5515: AND ts.analytical_detail_code = bs.analytical_detail_code
5516: AND ts.language = USERENV('LANG')
5517: LEFT OUTER JOIN xla_analytical_dtls_b bw
5518: ON bw.amb_context_code = g_amb_context_code
5519: AND bw.analytical_criterion_type_code = bs.analytical_criterion_type_code
5520: AND bw.analytical_criterion_code = bs.analytical_criterion_code
5521: AND bw.analytical_detail_code = bs.analytical_detail_code

Line 5661: JOIN xla_analytical_dtls_b b

5657: , w.source_type_code w_source_type_code
5658: , w.source_code w_source_code
5659: , w.source_application_id w_source_application_id
5660: FROM xla_analytical_sources s
5661: JOIN xla_analytical_dtls_b b
5662: ON b.amb_context_code = g_amb_context_code
5663: AND b.analytical_criterion_type_code = s.analytical_criterion_type_code
5664: AND b.analytical_criterion_code = s.analytical_criterion_code
5665: AND b.analytical_detail_code = s.analytical_detail_code

Line 5693: , xla_analytical_dtls_b b

5689: , w.source_type_code
5690: , w.source_code
5691: , w.source_application_id
5692: FROM xla_analytical_sources w
5693: , xla_analytical_dtls_b b
5694: WHERE w.amb_context_code = g_amb_context_code
5695: AND b.amb_context_code = g_staging_context_code
5696: AND b.analytical_criterion_type_code = w.analytical_criterion_type_code
5697: AND b.analytical_criterion_code = w.analytical_criterion_code