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_DESC_PRIORITIES

Line 242: FROM xla_descript_details_b d, xla_desc_priorities p

238: l_exist VARCHAR2(1);
239:
240: CURSOR c_desc_detail_sources IS
241: SELECT 'X'
242: FROM xla_descript_details_b d, xla_desc_priorities p
243: WHERE d.description_prio_id = p.description_prio_id
244: AND p.application_id = p_application_id
245: AND p.amb_context_code = p_amb_context_code
246: AND p.description_type_code = p_description_type_code

Line 262: FROM xla_conditions c, xla_desc_priorities d

258: AND s.active_flag = 'Y');
259:
260: CURSOR c_desc_condition_sources IS
261: SELECT 'X'
262: FROM xla_conditions c, xla_desc_priorities d
263: WHERE c.description_prio_id = d.description_prio_id
264: AND d.application_id = p_application_id
265: AND d.amb_context_code = p_amb_context_code
266: AND d.description_type_code = p_description_type_code

Line 281: FROM xla_conditions c, xla_desc_priorities d

277: AND s.event_class_code = p_event_class_code
278: AND s.active_flag = 'Y')
279: UNION
280: SELECT 'X' source_code
281: FROM xla_conditions c, xla_desc_priorities d
282: WHERE c.description_prio_id = d.description_prio_id
283: AND d.application_id = p_application_id
284: AND d.amb_context_code = p_amb_context_code
285: AND d.description_type_code = p_description_type_code

Line 301: FROM xla_descript_details_b d, xla_desc_priorities p

297: AND s.active_flag = 'Y');
298:
299: CURSOR c_desc_detail_der_sources IS
300: SELECT source_type_code, source_code
301: FROM xla_descript_details_b d, xla_desc_priorities p
302: WHERE d.description_prio_id = p.description_prio_id
303: AND p.application_id = p_application_id
304: AND p.amb_context_code = p_amb_context_code
305: AND p.description_type_code = p_description_type_code

Line 312: FROM xla_conditions c, xla_desc_priorities d

308: AND d.source_type_code = 'D';
309:
310: CURSOR c_desc_condition_der_sources IS
311: SELECT source_type_code source_type_code, source_code source_code
312: FROM xla_conditions c, xla_desc_priorities d
313: WHERE c.description_prio_id = d.description_prio_id
314: AND d.application_id = p_application_id
315: AND d.amb_context_code = p_amb_context_code
316: AND d.description_type_code = p_description_type_code

Line 322: FROM xla_conditions c, xla_desc_priorities d

318: AND c.source_code IS NOT NULL
319: AND c.source_type_code = 'D'
320: UNION
321: SELECT value_source_type_code source_type_code, value_source_code source_code
322: FROM xla_conditions c, xla_desc_priorities d
323: WHERE c.description_prio_id = d.description_prio_id
324: AND d.application_id = p_application_id
325: AND d.amb_context_code = p_amb_context_code
326: AND d.description_type_code = p_description_type_code

Line 4806: ,xla_desc_priorities xdp

4802: CURSOR c_invalid_sources IS
4803: SELECT distinct xjl.description_type_code, xjl.description_code,
4804: xco.source_type_code source_type_code, xco.source_code source_code
4805: FROM xla_conditions xco
4806: ,xla_desc_priorities xdp
4807: ,xla_line_defn_jlt_assgns xjl
4808: WHERE xco.description_prio_id = xdp.description_prio_id
4809: AND xdp.application_id = xjl.application_id
4810: AND xdp.amb_context_code = xjl.amb_context_code

Line 4834: ,xla_desc_priorities xdp

4830: UNION
4831: SELECT distinct xjl.description_type_code, xjl.description_code,
4832: xco.value_source_type_code source_type_code, xco.value_source_code source_code
4833: FROM xla_conditions xco
4834: ,xla_desc_priorities xdp
4835: ,xla_line_defn_jlt_assgns xjl
4836: WHERE xco.description_prio_id = xdp.description_prio_id
4837: AND xdp.application_id = xjl.application_id
4838: AND xdp.amb_context_code = xjl.amb_context_code

Line 4863: ,xla_desc_priorities xdp

4859: CURSOR c_der_sources IS
4860: SELECT distinct xjl.description_type_code, xjl.description_code,
4861: xco.source_type_code source_type_code, xco.source_code source_code
4862: FROM xla_conditions xco
4863: ,xla_desc_priorities xdp
4864: ,xla_line_defn_jlt_assgns xjl
4865: WHERE xco.description_prio_id = xdp.description_prio_id
4866: AND xdp.application_id = xjl.application_id
4867: AND xdp.amb_context_code = xjl.amb_context_code

Line 4882: ,xla_desc_priorities xdp

4878: UNION
4879: SELECT distinct xjl.description_type_code, xjl.description_code,
4880: xco.value_source_type_code source_type_code, xco.value_source_code source_code
4881: FROM xla_conditions xco
4882: ,xla_desc_priorities xdp
4883: ,xla_line_defn_jlt_assgns xjl
4884: WHERE xco.description_prio_id = xdp.description_prio_id
4885: AND xdp.application_id = xjl.application_id
4886: AND xdp.amb_context_code = xjl.amb_context_code

Line 5030: ,xla_desc_priorities xdp

5026: CURSOR c_invalid_sources IS
5027: SELECT distinct xjl.description_type_code, xjl.description_code,
5028: xdd.source_type_code, xdd.source_code
5029: FROM xla_descript_details_b xdd
5030: ,xla_desc_priorities xdp
5031: ,xla_line_defn_jlt_assgns xjl
5032: WHERE xdd.description_prio_id = xdp.description_prio_id
5033: AND xdp.application_id = xjl.application_id
5034: AND xdp.amb_context_code = xjl.amb_context_code

Line 5059: ,xla_desc_priorities xdp

5055: CURSOR c_der_sources IS
5056: SELECT distinct xjl.description_type_code, xjl.description_code,
5057: xdd.source_type_code, xdd.source_code
5058: FROM xla_descript_details_b xdd
5059: ,xla_desc_priorities xdp
5060: ,xla_line_defn_jlt_assgns xjl
5061: WHERE xdd.description_prio_id = xdp.description_prio_id
5062: AND xdp.application_id = xjl.application_id
5063: AND xdp.amb_context_code = xjl.amb_context_code

Line 7371: ,xla_desc_priorities xdp

7367: CURSOR c_invalid_sources IS
7368: SELECT distinct xjl.description_type_code, xjl.description_code,
7369: xco.source_type_code source_type_code, xco.source_code source_code
7370: FROM xla_conditions xco
7371: ,xla_desc_priorities xdp
7372: ,xla_mpa_jlt_assgns mjl
7373: ,xla_line_defn_jlt_assgns xjl
7374: WHERE xco.description_prio_id = xdp.description_prio_id
7375: AND xdp.application_id = mjl.application_id

Line 7409: ,xla_desc_priorities xdp

7405: UNION
7406: SELECT distinct xjl.description_type_code, xjl.description_code,
7407: xco.value_source_type_code source_type_code, xco.value_source_code source_code
7408: FROM xla_conditions xco
7409: ,xla_desc_priorities xdp
7410: ,xla_line_defn_jlt_assgns xjl
7411: ,xla_mpa_jlt_assgns mjl
7412: WHERE xco.description_prio_id = xdp.description_prio_id
7413: AND xdp.application_id = mjl.application_id

Line 7448: ,xla_desc_priorities xdp

7444: CURSOR c_der_sources IS
7445: SELECT distinct xjl.description_type_code, xjl.description_code,
7446: xco.source_type_code source_type_code, xco.source_code source_code
7447: FROM xla_conditions xco
7448: ,xla_desc_priorities xdp
7449: ,xla_line_defn_jlt_assgns xjl
7450: ,xla_mpa_jlt_assgns mjl
7451: WHERE xco.description_prio_id = xdp.description_prio_id
7452: AND xdp.application_id = mjl.application_id

Line 7477: ,xla_desc_priorities xdp

7473: UNION
7474: SELECT distinct xjl.description_type_code, xjl.description_code,
7475: xco.value_source_type_code source_type_code, xco.value_source_code source_code
7476: FROM xla_conditions xco
7477: ,xla_desc_priorities xdp
7478: ,xla_line_defn_jlt_assgns xjl
7479: ,xla_mpa_jlt_assgns mjl
7480: WHERE xco.description_prio_id = xdp.description_prio_id
7481: AND xdp.application_id = mjl.application_id

Line 7635: ,xla_desc_priorities xdp

7631: CURSOR c_invalid_sources IS
7632: SELECT distinct xjl.description_type_code, xjl.description_code,
7633: xdd.source_type_code, xdd.source_code
7634: FROM xla_descript_details_b xdd
7635: ,xla_desc_priorities xdp
7636: ,xla_line_defn_jlt_assgns xjl
7637: ,xla_mpa_jlt_assgns mjl
7638: WHERE xdd.description_prio_id = xdp.description_prio_id
7639: AND xdp.application_id = mjl.application_id

Line 7674: ,xla_desc_priorities xdp

7670: CURSOR c_der_sources IS
7671: SELECT distinct xjl.description_type_code, xjl.description_code,
7672: xdd.source_type_code, xdd.source_code
7673: FROM xla_descript_details_b xdd
7674: ,xla_desc_priorities xdp
7675: ,xla_line_defn_jlt_assgns xjl
7676: ,xla_mpa_jlt_assgns mjl
7677: WHERE xdd.description_prio_id = xdp.description_prio_id
7678: AND xdp.application_id = mjl.application_id

Line 10607: ,xla_desc_priorities xdp

10603: CURSOR c_invalid_sources IS
10604: SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
10605: xdd.source_type_code, xdd.source_code
10606: FROM xla_descript_details_b xdd
10607: ,xla_desc_priorities xdp
10608: ,xla_line_defn_jlt_assgns xjl
10609: WHERE xdd.description_prio_id = xdp.description_prio_id
10610: AND xdp.application_id = xjl.application_id
10611: AND xdp.amb_context_code = xjl.amb_context_code

Line 10636: ,xla_desc_priorities xdp

10632: CURSOR c_der_sources IS
10633: SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
10634: xdd.source_type_code, xdd.source_code
10635: FROM xla_descript_details_b xdd
10636: ,xla_desc_priorities xdp
10637: ,xla_line_defn_jlt_assgns xjl
10638: WHERE xdd.description_prio_id = xdp.description_prio_id
10639: AND xdp.application_id = xjl.application_id
10640: AND xdp.amb_context_code = xjl.amb_context_code

Line 10765: ,xla_desc_priorities xdp

10761: CURSOR c_invalid_sources IS
10762: SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
10763: xco.source_type_code source_type_code, xco.source_code source_code
10764: FROM xla_conditions xco
10765: ,xla_desc_priorities xdp
10766: ,xla_line_defn_jlt_assgns xjl
10767: WHERE xco.description_prio_id = xdp.description_prio_id
10768: AND xdp.application_id = xjl.application_id
10769: AND xdp.amb_context_code = xjl.amb_context_code

Line 10793: ,xla_desc_priorities xdp

10789: UNION
10790: SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
10791: xco.value_source_type_code source_type_code, xco.value_source_code source_code
10792: FROM xla_conditions xco
10793: ,xla_desc_priorities xdp
10794: ,xla_line_defn_jlt_assgns xjl
10795: WHERE xco.description_prio_id = xdp.description_prio_id
10796: AND xdp.application_id = xjl.application_id
10797: AND xdp.amb_context_code = xjl.amb_context_code

Line 10822: ,xla_desc_priorities xdp

10818: CURSOR c_der_sources IS
10819: SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
10820: xco.source_type_code source_type_code, xco.source_code source_code
10821: FROM xla_conditions xco
10822: ,xla_desc_priorities xdp
10823: ,xla_line_defn_jlt_assgns xjl
10824: WHERE xco.description_prio_id = xdp.description_prio_id
10825: AND xdp.application_id = xjl.application_id
10826: AND xdp.amb_context_code = xjl.amb_context_code

Line 10841: ,xla_desc_priorities xdp

10837: UNION
10838: SELECT distinct xjl.mpa_header_desc_type_code, xjl.mpa_header_desc_code,
10839: xco.value_source_type_code source_type_code, xco.value_source_code source_code
10840: FROM xla_conditions xco
10841: ,xla_desc_priorities xdp
10842: ,xla_line_defn_jlt_assgns xjl
10843: WHERE xco.description_prio_id = xdp.description_prio_id
10844: AND xdp.application_id = xjl.application_id
10845: AND xdp.amb_context_code = xjl.amb_context_code