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_LINE_DEFINITIONS_PVT dependencies on XLA_ANALYTICAL_SOURCES

Line 83: FROM xla_analytical_sources a

79: l_exist VARCHAR2(1);
80:
81: CURSOR c_event_sources IS
82: SELECT 'x'
83: FROM xla_analytical_sources a
84: WHERE application_id = p_application_id
85: AND amb_context_code = p_amb_context_code
86: AND entity_code = p_entity_code
87: AND event_class_code = p_event_class_code

Line 93: FROM xla_analytical_sources a

89: AND analytical_criterion_type_code = p_ac_type_code;
90:
91: CURSOR c_line_analytical IS
92: SELECT 'X'
93: FROM xla_analytical_sources a
94: WHERE application_id = p_application_id
95: AND amb_context_code = p_amb_context_code
96: AND entity_code = p_entity_code
97: AND event_class_code = p_event_class_code

Line 113: FROM xla_analytical_sources a

109: AND s.active_flag = 'Y');
110:
111: CURSOR c_analytical_der_sources IS
112: SELECT source_code, source_type_code
113: FROM xla_analytical_sources a
114: WHERE application_id = p_application_id
115: AND amb_context_code = p_amb_context_code
116: AND entity_code = p_entity_code
117: AND event_class_code = p_event_class_code

Line 5414: FROM xla_analytical_sources xas

5410: AND xjl.line_definition_code = p_line_definition_code
5411: AND xjl.active_flag = 'Y'
5412: AND NOT EXISTS
5413: (SELECT 'x'
5414: FROM xla_analytical_sources xas
5415: WHERE xas.application_id = xac.application_id
5416: AND xas.amb_context_code = xac.amb_context_code
5417: AND xas.event_class_code = xac.event_class_code
5418: AND xas.analytical_criterion_code = xac.analytical_criterion_code

Line 5507: FROM xla_analytical_sources xas

5503: IS
5504: CURSOR c_invalid_sources IS
5505: SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
5506: xas.source_code, xas.source_type_code
5507: FROM xla_analytical_sources xas
5508: ,xla_line_defn_ac_assgns xac
5509: ,xla_line_defn_jlt_assgns xjl
5510: ,xla_event_sources xes
5511: WHERE xas.application_id = xac.application_id

Line 5544: FROM xla_analytical_sources xas

5540:
5541: CURSOR c_der_sources IS
5542: SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
5543: xas.source_code, xas.source_type_code
5544: FROM xla_analytical_sources xas
5545: ,xla_line_defn_ac_assgns xac
5546: ,xla_line_defn_jlt_assgns xjl
5547: WHERE xas.application_id = xac.application_id
5548: AND xas.amb_context_code = xac.amb_context_code

Line 8038: FROM xla_analytical_sources xas

8034: AND xjl.line_definition_code = p_line_definition_code
8035: AND xjl.active_flag = 'Y'
8036: AND NOT EXISTS
8037: (SELECT 'x'
8038: FROM xla_analytical_sources xas
8039: WHERE xas.application_id = xac.application_id
8040: AND xas.amb_context_code = xac.amb_context_code
8041: AND xas.event_class_code = xac.event_class_code
8042: AND xas.analytical_criterion_code = xac.analytical_criterion_code

Line 8131: FROM xla_analytical_sources xas

8127: IS
8128: CURSOR c_invalid_sources IS
8129: SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
8130: xas.source_code, xas.source_type_code
8131: FROM xla_analytical_sources xas
8132: ,xla_mpa_jlt_ac_assgns xac
8133: ,xla_line_defn_jlt_assgns xjl
8134: ,xla_event_sources xes
8135: WHERE xas.application_id = xac.application_id

Line 8168: FROM xla_analytical_sources xas

8164:
8165: CURSOR c_der_sources IS
8166: SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
8167: xas.source_code, xas.source_type_code
8168: FROM xla_analytical_sources xas
8169: ,xla_mpa_jlt_ac_assgns xac
8170: ,xla_line_defn_jlt_assgns xjl
8171: WHERE xas.application_id = xac.application_id
8172: AND xas.amb_context_code = xac.amb_context_code

Line 11190: FROM xla_analytical_sources xas

11186: AND xjl.line_definition_code = p_line_definition_code
11187: AND xjl.active_flag = 'Y'
11188: AND NOT EXISTS
11189: (SELECT 'x'
11190: FROM xla_analytical_sources xas
11191: WHERE xas.application_id = xac.application_id
11192: AND xas.amb_context_code = xac.amb_context_code
11193: AND xas.event_class_code = xac.event_class_code
11194: AND xas.analytical_criterion_code = xac.analytical_criterion_code

Line 11277: FROM xla_analytical_sources xas

11273: IS
11274: CURSOR c_invalid_sources IS
11275: SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
11276: xas.source_code, xas.source_type_code
11277: FROM xla_analytical_sources xas
11278: ,xla_mpa_header_ac_assgns xac
11279: ,xla_line_defn_jlt_assgns xjl
11280: ,xla_event_sources xes
11281: WHERE xas.application_id = xac.application_id

Line 11314: FROM xla_analytical_sources xas

11310:
11311: CURSOR c_der_sources IS
11312: SELECT distinct xas.analytical_criterion_type_code, xas.analytical_criterion_code,
11313: xas.source_code, xas.source_type_code
11314: FROM xla_analytical_sources xas
11315: ,xla_mpa_header_ac_assgns xac
11316: ,xla_line_defn_jlt_assgns xjl
11317: WHERE xas.application_id = xac.application_id
11318: AND xas.amb_context_code = xac.amb_context_code