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_SEG_RULES_B

Line 3582: FROM xla_seg_rules_b w

3578: CURSOR c_comp IS
3579: SELECT w.application_id segment_rule_appl_id
3580: ,w.segment_rule_type_code
3581: , w.segment_rule_code
3582: FROM xla_seg_rules_b w
3583: WHERE w.application_id = g_application_id
3584: AND w.amb_context_code = g_amb_context_code
3585: AND w.segment_rule_type_code = C_OWNER_ORACLE
3586: AND NOT EXISTS (

Line 3588: FROM xla_seg_rules_b s

3584: AND w.amb_context_code = g_amb_context_code
3585: AND w.segment_rule_type_code = C_OWNER_ORACLE
3586: AND NOT EXISTS (
3587: SELECT 1
3588: FROM xla_seg_rules_b s
3589: WHERE s.application_id = g_application_id
3590: AND s.amb_context_code = g_staging_context_code
3591: AND s.segment_rule_type_code = w.segment_rule_type_code
3592: AND s.segment_rule_code = w.segment_rule_code);

Line 3601: , xla_seg_rules_b b

3597: ,w.segment_rule_code
3598: ,w.user_sequence
3599: ,C_MERGE_IMPACT_DELETED
3600: FROM xla_seg_rule_details w
3601: , xla_seg_rules_b b
3602: WHERE b.application_id = g_application_id
3603: AND b.amb_context_code = g_staging_context_code
3604: AND b.segment_rule_type_code = w.segment_rule_type_code
3605: AND b.segment_rule_code = w.segment_rule_code

Line 4573: FROM xla_seg_rules_b bs

4569: ,bs.flexfield_segment_code s_flexfield_segment_code
4570: ,bw.flexfield_segment_code w_flexfield_segment_code
4571: ,bs.enabled_flag s_enabled_flag
4572: ,bw.enabled_flag w_enabled_flag
4573: FROM xla_seg_rules_b bs
4574: JOIN xla_seg_rules_tl ts
4575: ON ts.application_id = bs.application_id
4576: AND ts.amb_context_code = bs.amb_context_code
4577: AND ts.segment_rule_type_code = bs.segment_rule_type_code

Line 4580: JOIN xla_seg_rules_b bw

4576: AND ts.amb_context_code = bs.amb_context_code
4577: AND ts.segment_rule_type_code = bs.segment_rule_type_code
4578: AND ts.segment_rule_code = bs.segment_rule_code
4579: AND ts.language = USERENV('LANG')
4580: JOIN xla_seg_rules_b bw
4581: ON bw.application_id = g_application_id
4582: AND bw.amb_context_code = g_amb_context_code
4583: AND bw.segment_rule_type_code = bs.segment_rule_type_code
4584: AND bw.segment_rule_code = bs.segment_rule_code

Line 4771: JOIN xla_seg_rules_b bs

4767: ,w.input_source_type_code w_input_source_type_code
4768: ,s.input_source_code s_input_source_code
4769: ,w.input_source_code w_input_source_code
4770: FROM xla_seg_rule_details s
4771: JOIN xla_seg_rules_b bs
4772: ON bs.application_id = g_application_id
4773: AND bs.amb_context_code = g_staging_context_code
4774: AND bs.segment_rule_type_code = s.segment_rule_type_code
4775: AND bs.segment_rule_code = s.segment_rule_code

Line 4776: JOIN xla_seg_rules_b bw

4772: ON bs.application_id = g_application_id
4773: AND bs.amb_context_code = g_staging_context_code
4774: AND bs.segment_rule_type_code = s.segment_rule_type_code
4775: AND bs.segment_rule_code = s.segment_rule_code
4776: JOIN xla_seg_rules_b bw
4777: ON bw.application_id = g_application_id
4778: AND bw.amb_context_code = g_amb_context_code
4779: AND bw.segment_rule_type_code = s.segment_rule_type_code
4780: AND bw.segment_rule_code = s.segment_rule_code