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_CONDITIONS

Line 112: FROM xla_conditions c, xla_seg_rule_details sd

108: AND sd.segment_rule_type_code = a.segment_rule_type_code
109: AND sd.segment_rule_code = a.segment_rule_code
110: UNION
111: SELECT 'x'
112: FROM xla_conditions c, xla_seg_rule_details sd
113: WHERE ((c.source_application_id = p_der_application_id
114: AND c.source_code = p_der_source_code
115: AND c.source_type_code = p_der_source_type_code)
116: OR (c.value_source_application_id = p_der_application_id

Line 225: FROM xla_conditions c

221:
222: CURSOR check_sr_conditions
223: IS
224: SELECT 'x'
225: FROM xla_conditions c
226: WHERE ((source_application_id = p_der_application_id
227: AND source_code = p_der_source_code
228: AND source_type_code = p_der_source_type_code)
229: OR (value_source_application_id = p_der_application_id

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 462: FROM xla_conditions c, xla_seg_rule_details sd

458: AND sd.segment_rule_type_code = a.segment_rule_type_code
459: AND sd.segment_rule_code = a.segment_rule_code
460: UNION
461: SELECT 'x'
462: FROM xla_conditions c, xla_seg_rule_details sd
463: WHERE ((c.source_application_id = p_der_application_id
464: AND c.source_code = p_der_source_code
465: AND c.source_type_code = p_der_source_type_code)
466: OR (c.value_source_application_id = p_der_application_id

Line 483: ,xla_conditions c

479: IS
480: SELECT a.application_id, a.amb_context_code, a.entity_code, a.event_class_code,
481: a.accounting_line_type_code, a.accounting_line_code
482: FROM xla_acct_line_types_b a
483: ,xla_conditions c
484: WHERE a.application_id = c.application_id
485: AND a.amb_context_code = c.amb_context_code
486: AND a.entity_code = c.entity_code
487: AND a.event_class_code = c.event_class_code

Line 824: FROM xla_conditions xco

820:
821: CURSOR check_desc_conditions
822: IS
823: SELECT 'x'
824: FROM xla_conditions xco
825: WHERE ((source_application_id = p_der_application_id
826: AND source_code = p_der_source_code
827: AND source_type_code = p_der_source_type_code)
828: OR (value_source_application_id = p_der_application_id

Line 859: FROM xla_conditions xco

855:
856: CURSOR check_sr_conditions
857: IS
858: SELECT 'x'
859: FROM xla_conditions xco
860: WHERE ((source_application_id = p_der_application_id
861: AND source_code = p_der_source_code
862: AND source_type_code = p_der_source_type_code)
863: OR (value_source_application_id = p_der_application_id

Line 894: FROM xla_conditions xco

890:
891: CURSOR check_lt_conditions
892: IS
893: SELECT 'x'
894: FROM xla_conditions xco
895: WHERE ((source_application_id = p_der_application_id
896: AND source_code = p_der_source_code
897: AND source_type_code = p_der_source_type_code)
898: OR (value_source_application_id = p_der_application_id

Line 1310: FROM xla_conditions

1306: SELECT 'x'
1307: FROM DUAL
1308: WHERE EXISTS
1309: (SELECT 'x'
1310: FROM xla_conditions
1311: WHERE source_application_id = p_application_id
1312: AND source_code = p_source_code
1313: AND source_type_code = p_source_type_code
1314: UNION

Line 1316: FROM xla_conditions

1312: AND source_code = p_source_code
1313: AND source_type_code = p_source_type_code
1314: UNION
1315: SELECT 'x'
1316: FROM xla_conditions
1317: WHERE value_source_application_id = p_application_id
1318: AND value_source_code = p_source_code
1319: AND value_source_type_code = p_source_type_code
1320: AND value_source_code is not null);

Line 1888: FROM xla_conditions xco

1884:
1885: CURSOR check_desc_conditions
1886: IS
1887: SELECT 'x'
1888: FROM xla_conditions xco
1889: WHERE ((source_application_id = p_application_id
1890: AND source_code = p_source_code
1891: AND source_type_code = p_source_type_code)
1892: OR (value_source_application_id = p_application_id

Line 1924: FROM xla_conditions xco

1920:
1921: CURSOR check_sr_conditions
1922: IS
1923: SELECT 'x'
1924: FROM xla_conditions xco
1925: WHERE ((source_application_id = p_application_id
1926: AND source_code = p_source_code
1927: AND source_type_code = p_source_type_code)
1928: OR (value_source_application_id = p_application_id

Line 1960: FROM xla_conditions c

1956:
1957: CURSOR check_lt_conditions
1958: IS
1959: SELECT 'x'
1960: FROM xla_conditions c
1961: WHERE ((source_application_id = p_application_id
1962: AND source_code = p_source_code
1963: AND source_type_code = p_source_type_code)
1964: OR (value_source_application_id = p_application_id

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

Line 2493: FROM xla_conditions c, xla_seg_rule_details sd

2489: AND sd.segment_rule_type_code = a.segment_rule_type_code
2490: AND sd.segment_rule_code = a.segment_rule_code
2491: UNION
2492: SELECT 'x'
2493: FROM xla_conditions c, xla_seg_rule_details sd
2494: WHERE ((c.source_application_id = p_application_id
2495: AND c.source_code = p_source_code
2496: AND c.source_type_code = p_source_type_code)
2497: OR (c.value_source_application_id = p_application_id

Line 2515: FROM xla_conditions c

2511: SELECT application_id, a.amb_context_code, entity_code, event_class_code,
2512: accounting_line_type_code, accounting_line_code
2513: FROM xla_acct_line_types_b a
2514: WHERE exists (SELECT 'x'
2515: FROM xla_conditions c
2516: WHERE ((source_application_id = p_application_id
2517: AND source_code = p_source_code
2518: AND source_type_code = p_source_type_code)
2519: OR (value_source_application_id = p_application_id

Line 3203: FROM xla_conditions c

3199:
3200: CURSOR check_sr_conditions
3201: IS
3202: SELECT 'x'
3203: FROM xla_conditions c
3204: WHERE ((source_application_id = p_application_id
3205: AND source_code = p_source_code
3206: AND source_type_code = p_source_type_code)
3207: OR (value_source_application_id = p_application_id

Line 3433: FROM xla_conditions c, xla_seg_rule_details sd

3429: AND sd.segment_rule_type_code = a.segment_rule_type_code
3430: AND sd.segment_rule_code = a.segment_rule_code
3431: UNION
3432: SELECT 'x'
3433: FROM xla_conditions c, xla_seg_rule_details sd
3434: WHERE ((c.source_application_id = p_application_id
3435: AND c.source_code = p_source_code
3436: AND c.source_type_code = p_source_type_code)
3437: OR (c.value_source_application_id = p_application_id

Line 3625: FROM xla_conditions c

3621:
3622: CURSOR check_con_source
3623: IS
3624: SELECT 'x'
3625: FROM xla_conditions c
3626: WHERE c.source_application_id = p_application_id
3627: AND c.source_code = p_source_code
3628: AND c.source_type_code = p_source_type_code
3629: AND exists (SELECT 'x'

Line 3641: FROM xla_conditions c

3637:
3638: CURSOR check_con_value_source
3639: IS
3640: SELECT 'x'
3641: FROM xla_conditions c
3642: WHERE value_source_application_id = p_application_id
3643: AND value_source_code = p_source_code
3644: AND value_source_type_code = p_source_type_code
3645: AND value_source_code is not null