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_RULE_DETAILS

Line 2221: FROM xla_seg_rule_details s

2217: SELECT application_id segment_rule_appl_id
2218: , segment_rule_type_code
2219: , segment_rule_code
2220: , user_sequence
2221: FROM xla_seg_rule_details s
2222: WHERE application_id = g_application_id
2223: AND amb_context_code = g_amb_context_code
2224: AND value_mapping_set_code = p_mapping_set_code;
2225:

Line 3600: FROM xla_seg_rule_details w

3596: ,w.segment_rule_type_code
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

Line 3611: FROM xla_seg_rule_details s

3607: AND w.amb_context_code = g_amb_context_code
3608: AND w.segment_rule_type_code = C_OWNER_ORACLE
3609: AND NOT EXISTS
3610: (SELECT 1
3611: FROM xla_seg_rule_details s
3612: WHERE s.application_id = g_application_id
3613: AND s.amb_context_code = g_staging_context_code
3614: AND s.segment_rule_type_code = w.segment_rule_type_code
3615: AND s.segment_rule_code = w.segment_rule_code

Line 4770: FROM xla_seg_rule_details s

4766: ,s.input_source_type_code s_input_source_type_code
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

Line 4781: LEFT OUTER JOIN xla_seg_rule_details w

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
4781: LEFT OUTER JOIN xla_seg_rule_details w
4782: ON w.application_id = g_application_id
4783: AND w.amb_context_code = g_amb_context_code
4784: AND w.segment_rule_type_code = s.segment_rule_type_code
4785: AND w.segment_rule_code = s.segment_rule_code

Line 8893: ,xla_seg_rule_details xsr

8889: UNION
8890: SELECT xal.product_rule_type_code, xal.product_rule_code
8891: FROM xla_line_defn_adr_assgns adr
8892: ,xla_aad_line_defn_assgns xal
8893: ,xla_seg_rule_details xsr
8894: WHERE xal.application_id = adr.application_id
8895: AND xal.amb_context_code = adr.amb_context_code
8896: AND xal.event_class_code = adr.event_class_code
8897: AND xal.event_type_code = adr.event_type_code

Line 8909: ,xla_seg_rule_details xsr2

8905: AND xsr.amb_context_code IN (g_amb_context_code,g_staging_context_code)
8906: AND EXISTS (SELECT 1
8907: FROM xla_line_defn_adr_assgns adr2
8908: ,xla_aad_line_defn_assgns xal2
8909: ,xla_seg_rule_details xsr2
8910: ,TABLE(CAST(g_aad_groups AS xla_aad_group_tbl_type)) grp
8911: WHERE xsr2.value_mapping_set_code = xsr.value_mapping_set_code
8912: AND xsr2.application_id = adr2.application_id
8913: AND xsr2.amb_context_code = adr2.amb_context_code