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_SEG_RULES_PKG dependencies on XLA_LINE_DEFN_ADR_ASSGNS

Line 500: FROM xla_line_defn_adr_assgns

496:
497: CURSOR c_assignment_exist
498: IS
499: SELECT event_class_code, event_type_code, line_definition_owner_code, line_definition_code
500: FROM xla_line_defn_adr_assgns
501: WHERE application_id = p_application_id
502: AND amb_context_code = p_amb_context_code
503: AND segment_rule_type_code = p_segment_rule_type_code
504: AND segment_rule_code = p_segment_rule_code;

Line 511: FROM xla_line_defn_adr_assgns s

507:
508: CURSOR c_active_assignment_exist
509: IS
510: SELECT event_class_code, event_type_code, line_definition_owner_code, line_definition_code
511: FROM xla_line_defn_adr_assgns s
512: WHERE application_id = p_application_id
513: AND amb_context_code = p_amb_context_code
514: AND segment_rule_type_code = p_segment_rule_type_code
515: AND segment_rule_code = p_segment_rule_code

Line 718: FROM xla_line_defn_adr_assgns s

714:
715: CURSOR c_frozen_assignment_exist
716: IS
717: SELECT 'x'
718: FROM xla_line_defn_adr_assgns s
719: WHERE application_id = p_application_id
720: AND amb_context_code = p_amb_context_code
721: AND segment_rule_type_code = p_segment_rule_type_code
722: AND segment_rule_code = p_segment_rule_code

Line 850: FROM xla_line_defn_adr_assgns xld

846: , xpa.product_rule_type_code
847: , xpa.product_rule_code
848: , xpa.locking_status_flag
849: , xpa.validation_status_code
850: FROM xla_line_defn_adr_assgns xld
851: ,xla_aad_line_defn_assgns xal
852: ,xla_prod_acct_headers xpa
853: WHERE xpa.application_id = xal.application_id
854: AND xpa.amb_context_code = xal.amb_context_code

Line 875: FROM xla_line_defn_adr_assgns xad

871: CURSOR c_update_aads IS
872: SELECT distinct xal.event_class_code
873: , xal.product_rule_type_code
874: , xal.product_rule_code
875: FROM xla_line_defn_adr_assgns xad
876: ,xla_aad_line_defn_assgns xal
877: ,xla_prod_acct_headers xpa
878: WHERE xpa.application_id = xal.application_id
879: AND xpa.amb_context_code = xal.amb_context_code

Line 951: FROM xla_line_defn_adr_assgns xad

947: AND xld.amb_context_code = p_amb_context_code
948: AND xld.validation_status_code <> 'N'
949: AND EXISTS
950: (SELECT 1
951: FROM xla_line_defn_adr_assgns xad
952: WHERE xad.application_id = p_application_id
953: AND xad.amb_context_code = p_amb_context_code
954: AND xad.segment_rule_type_code = p_segment_rule_type_code
955: AND xad.segment_rule_code = p_segment_rule_code