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_SOURCES_PKG dependencies on XLA_DESC_PRIORITIES

Line 415: FROM xla_descript_details_b d, xla_desc_priorities dp

411: SELECT x.application_id, x.amb_context_code,
412: x.description_type_code, x.description_code
413: FROM xla_descriptions_b x
414: WHERE exists (SELECT 'x'
415: FROM xla_descript_details_b d, xla_desc_priorities dp
416: WHERE d.source_application_id = p_der_application_id
417: AND d.source_code = p_der_source_code
418: AND d.source_type_code = p_der_source_type_code
419: AND d.source_code is not null

Line 427: FROM xla_conditions c, xla_desc_priorities dp

423: AND dp.description_type_code = x.description_type_code
424: AND dp.description_code = x.description_code
425: UNION
426: SELECT 'x'
427: FROM xla_conditions c, xla_desc_priorities dp
428: WHERE ((c.source_application_id = p_der_application_id
429: AND c.source_code = p_der_source_code
430: AND c.source_type_code = p_der_source_type_code)
431: OR (c.value_source_application_id = p_der_application_id

Line 788: FROM xla_desc_priorities xdp

784: AND source_code = p_der_source_code
785: AND source_type_code = p_der_source_type_code
786: AND source_code is not null
787: AND exists (SELECT 'x'
788: FROM xla_desc_priorities xdp
789: , xla_line_defn_jlt_assgns xld
790: , xla_aad_line_defn_assgns xal
791: , xla_prod_acct_headers xpa
792: WHERE xdp.description_prio_id = xdd.description_prio_id

Line 812: FROM xla_desc_priorities xdp

808: AND xpa.event_type_code = xal.event_type_code
809: AND xpa.locking_status_flag = 'Y'
810: UNION
811: SELECT 'x'
812: FROM xla_desc_priorities xdp
813: , xla_prod_acct_headers xpa
814: WHERE xdp.description_prio_id = xdd.description_prio_id
815: AND xpa.application_id = xdp.application_id
816: AND xpa.amb_context_code = xdp.amb_context_code

Line 833: FROM xla_desc_priorities xdp,

829: AND value_source_type_code = p_der_source_type_code
830: AND value_source_code = p_der_source_code
831: AND value_source_code IS NOT NULL))
832: AND exists (SELECT 'x'
833: FROM xla_desc_priorities xdp,
834: xla_line_defn_jlt_assgns xld,
835: xla_aad_line_defn_assgns xal,
836: xla_prod_acct_headers xpa
837: WHERE xdp.description_prio_id = xco.description_prio_id

Line 1852: FROM xla_desc_priorities xdp

1848: AND source_code = p_source_code
1849: AND source_type_code = p_source_type_code
1850: AND source_code is not null
1851: AND exists (SELECT 'x'
1852: FROM xla_desc_priorities xdp
1853: ,xla_line_defn_jlt_assgns xjl
1854: ,xla_aad_line_defn_assgns xal
1855: ,xla_prod_acct_headers xpa
1856: WHERE xdp.description_prio_id = xdd.description_prio_id

Line 1876: FROM xla_desc_priorities xdp

1872: AND xpa.product_rule_code = xal.product_rule_code
1873: AND xpa.locking_status_flag = 'Y'
1874: UNION
1875: SELECT 'x'
1876: FROM xla_desc_priorities xdp
1877: , xla_prod_acct_headers xpa
1878: WHERE xdp.description_prio_id = xdd.description_prio_id
1879: AND xpa.application_id = xdp.application_id
1880: AND xpa.amb_context_code = xdp.amb_context_code

Line 1897: FROM xla_desc_priorities xdp

1893: AND value_source_type_code = p_source_type_code
1894: AND value_source_code = p_source_code
1895: AND value_source_code IS NOT NULL))
1896: AND exists (SELECT 'x'
1897: FROM xla_desc_priorities xdp
1898: ,xla_line_defn_jlt_assgns xld
1899: ,xla_aad_line_defn_assgns xal
1900: ,xla_prod_acct_headers xpa
1901: WHERE xdp.description_prio_id = xco.description_prio_id

Line 2446: FROM xla_descript_details_b d, xla_desc_priorities dp

2442: SELECT x.application_id, x.amb_context_code,
2443: x.description_type_code, x.description_code
2444: FROM xla_descriptions_b x
2445: WHERE exists (SELECT 'x'
2446: FROM xla_descript_details_b d, xla_desc_priorities dp
2447: WHERE d.source_application_id = p_application_id
2448: AND d.source_code = p_source_code
2449: AND d.source_type_code = p_source_type_code
2450: AND d.source_code is not null

Line 2458: FROM xla_conditions c, xla_desc_priorities dp

2454: AND dp.description_type_code = x.description_type_code
2455: AND dp.description_code = x.description_code
2456: UNION
2457: SELECT 'x'
2458: FROM xla_conditions c, xla_desc_priorities dp
2459: WHERE ((c.source_application_id = p_application_id
2460: AND c.source_code = p_source_code
2461: AND c.source_type_code = p_source_type_code)
2462: OR (c.value_source_application_id = p_application_id