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_HDRS_B

Line 3712: FROM xla_analytical_hdrs_b w

3708: IS
3709: CURSOR c_comp IS
3710: SELECT w.analytical_criterion_type_code
3711: , w.analytical_criterion_code
3712: FROM xla_analytical_hdrs_b w
3713: WHERE w.application_id = g_application_id
3714: AND w.amb_context_code = g_amb_context_code
3715: AND w.analytical_criterion_type_code = C_OWNER_ORACLE
3716: AND NOT EXISTS (

Line 3718: FROM xla_analytical_hdrs_b s

3714: AND w.amb_context_code = g_amb_context_code
3715: AND w.analytical_criterion_type_code = C_OWNER_ORACLE
3716: AND NOT EXISTS (
3717: SELECT 1
3718: FROM xla_analytical_hdrs_b s
3719: WHERE s.application_id = g_application_id
3720: AND s.amb_context_code = g_staging_context_code
3721: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
3722: AND s.analytical_criterion_code = w.analytical_criterion_code);

Line 3729: , xla_analytical_hdrs_b b

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
3733: AND b.analytical_criterion_code = w.analytical_criterion_code

Line 5327: FROM xla_analytical_hdrs_b bs

5323: ,bs.display_in_inquiries_flag s_display_in_inquiries_flag
5324: ,bw.display_in_inquiries_flag w_display_in_inquiries_flag
5325: ,bs.criterion_value_code s_criterion_value_code
5326: ,bw.criterion_value_code w_criterion_value_code
5327: FROM xla_analytical_hdrs_b bs
5328: JOIN xla_analytical_hdrs_tl ts
5329: ON ts.amb_context_code = bs.amb_context_code
5330: AND ts.analytical_criterion_type_code = bs.analytical_criterion_type_code
5331: AND ts.analytical_criterion_code = bs.analytical_criterion_code

Line 5333: JOIN xla_analytical_hdrs_b bw

5329: ON ts.amb_context_code = bs.amb_context_code
5330: AND ts.analytical_criterion_type_code = bs.analytical_criterion_type_code
5331: AND ts.analytical_criterion_code = bs.analytical_criterion_code
5332: AND ts.language = USERENV('LANG')
5333: JOIN xla_analytical_hdrs_b bw
5334: ON bw.amb_context_code = g_amb_context_code
5335: AND bw.analytical_criterion_type_code = bs.analytical_criterion_type_code
5336: AND bw.analytical_criterion_code = bs.analytical_criterion_code
5337: JOIN xla_analytical_hdrs_tl tw

Line 5511: JOIN xla_analytical_hdrs_b hw

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
5515: JOIN xla_analytical_dtls_tl ts