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_DESCRIPTIONS_PKG dependencies on XLA_LINE_DEFN_JLT_ASSGNS

Line 591: FROM xla_line_defn_jlt_assgns

587: CURSOR c_line_assign_exist
588: IS
589: SELECT line_definition_owner_code, line_definition_code,
590: event_class_code, event_type_code
591: FROM xla_line_defn_jlt_assgns
592: WHERE application_id = p_application_id
593: AND amb_context_code = p_amb_context_code
594: AND description_type_code = p_description_type_code
595: AND description_code = p_description_code;

Line 603: FROM xla_line_defn_jlt_assgns

599: CURSOR c_active_assign_exist
600: IS
601: SELECT line_definition_owner_code, line_definition_code,
602: event_class_code, event_type_code
603: FROM xla_line_defn_jlt_assgns
604: WHERE application_id = p_application_id
605: AND amb_context_code = p_amb_context_code
606: AND description_type_code = p_description_type_code
607: AND description_code = p_description_code

Line 915: FROM xla_line_defn_jlt_assgns xjl

911:
912: CURSOR c_frozen_line_assign_exist
913: IS
914: SELECT 'x'
915: FROM xla_line_defn_jlt_assgns xjl
916: ,xla_aad_line_defn_assgns xal
917: ,xla_prod_acct_headers xpa
918: WHERE xpa.application_id = xal.application_id
919: AND xpa.amb_context_code = xal.amb_context_code

Line 1058: FROM xla_line_defn_jlt_assgns xjl

1054: , xpa.product_rule_type_code
1055: , xpa.product_rule_code
1056: , xpa.locking_status_flag
1057: , xpa.validation_status_code
1058: FROM xla_line_defn_jlt_assgns xjl
1059: ,xla_aad_line_defn_assgns xal
1060: ,xla_prod_acct_headers xpa
1061: WHERE xpa.application_id = xal.application_id
1062: AND xpa.amb_context_code = xal.amb_context_code

Line 1109: ,xla_line_defn_jlt_assgns xjl

1105: , xpa.product_rule_type_code
1106: , xpa.product_rule_code
1107: FROM xla_prod_acct_headers xpa
1108: ,xla_aad_line_defn_assgns xal
1109: ,xla_line_defn_jlt_assgns xjl
1110: WHERE xpa.application_id = xal.application_id
1111: AND xpa.amb_context_code = xal.amb_context_code
1112: AND xpa.product_rule_type_code = xal.product_rule_type_code
1113: AND xpa.product_rule_code = xal.product_rule_code

Line 1230: FROM xla_line_defn_jlt_assgns xjl

1226: AND xld.amb_context_code = p_amb_context_code
1227: AND xld.validation_status_code <> 'N'
1228: AND EXISTS
1229: (SELECT 1
1230: FROM xla_line_defn_jlt_assgns xjl
1231: WHERE xjl.application_id = p_application_id
1232: AND xjl.amb_context_code = p_amb_context_code
1233: AND xjl.description_type_code = p_description_type_code
1234: AND xjl.description_code = p_description_code