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_EVENT_SOURCES

Line 102: FROM xla_event_sources s

98: AND analytical_criterion_code = p_ac_code
99: AND analytical_criterion_type_code = p_ac_type_code
100: AND source_type_code = 'S'
101: AND not exists (SELECT 'y'
102: FROM xla_event_sources s
103: WHERE s.source_application_id = a.source_application_id
104: AND s.source_type_code = a.source_type_code
105: AND s.source_code = a.source_code
106: AND s.application_id = p_application_id

Line 251: FROM xla_event_sources s

247: AND p.description_code = p_description_code
248: AND d.source_code IS NOT NULL
249: AND d.source_type_code = 'S'
250: AND NOT EXISTS (SELECT 'y'
251: FROM xla_event_sources s
252: WHERE s.source_application_id = d.source_application_id
253: AND s.source_type_code = d.source_type_code
254: AND s.source_code = d.source_code
255: AND s.application_id = p_application_id

Line 271: FROM xla_event_sources s

267: AND d.description_code = p_description_code
268: AND c.source_code IS NOT NULL
269: AND c.source_type_code = 'S'
270: AND NOT EXISTS (SELECT 'y'
271: FROM xla_event_sources s
272: WHERE s.source_application_id = c.source_application_id
273: AND s.source_type_code = c.source_type_code
274: AND s.source_code = c.source_code
275: AND s.application_id = p_application_id

Line 290: FROM xla_event_sources s

286: AND d.description_code = p_description_code
287: AND c.value_source_code IS NOT NULL
288: AND c.value_source_type_code = 'S'
289: AND NOT EXISTS (SELECT 'y'
290: FROM xla_event_sources s
291: WHERE s.source_application_id = c.value_source_application_id
292: AND s.source_type_code = c.value_source_type_code
293: AND s.source_code = c.value_source_code
294: AND s.application_id = p_application_id

Line 498: FROM xla_event_sources s

494: AND segment_rule_code = p_segment_rule_code
495: AND value_source_code IS NOT NULL
496: AND value_source_type_code = 'S'
497: AND NOT EXISTS (SELECT 'y'
498: FROM xla_event_sources s
499: WHERE s.source_application_id = d.value_source_application_id
500: AND s.source_type_code = d.value_source_type_code
501: AND s.source_code = d.value_source_code
502: AND s.application_id = p_application_id

Line 517: FROM xla_event_sources s

513: AND segment_rule_code = p_segment_rule_code
514: AND input_source_code IS NOT NULL
515: AND input_source_type_code = 'S'
516: AND NOT EXISTS (SELECT 'y'
517: FROM xla_event_sources s
518: WHERE s.source_application_id = d.input_source_application_id
519: AND s.source_type_code = d.input_source_type_code
520: AND s.source_code = d.input_source_code
521: AND s.application_id = p_application_id

Line 538: FROM xla_event_sources s

534: AND d.segment_rule_code = p_segment_rule_code
535: AND c.source_code IS NOT NULL
536: AND c.source_type_code = 'S'
537: AND NOT EXISTS (SELECT 'y'
538: FROM xla_event_sources s
539: WHERE s.source_application_id = c.source_application_id
540: AND s.source_type_code = c.source_type_code
541: AND s.source_code = c.source_code
542: AND s.application_id = p_application_id

Line 558: FROM xla_event_sources s

554: AND d.segment_rule_code = p_segment_rule_code
555: AND c.value_source_code IS NOT NULL
556: AND c.value_source_type_code = 'S'
557: AND NOT EXISTS (SELECT 'y'
558: FROM xla_event_sources s
559: WHERE s.source_application_id = c.value_source_application_id
560: AND s.source_type_code = c.value_source_type_code
561: AND s.source_code = c.value_source_code
562: AND s.application_id = p_application_id

Line 1590: FROM xla_event_sources xes

1586: AND xjl.line_definition_code = p_line_definition_code
1587: AND xjl.active_flag = 'Y'
1588: AND NOT EXISTS
1589: (SELECT 'y'
1590: FROM xla_event_sources xes
1591: WHERE xes.source_application_id = xco.source_application_id
1592: AND xes.source_type_code = xco.source_type_code
1593: AND xes.source_code = xco.source_code
1594: AND xes.application_id = p_application_id

Line 1628: FROM xla_event_sources xes

1624: AND xjl.line_definition_code = p_line_definition_code
1625: AND xjl.active_flag = 'Y'
1626: AND NOT EXISTS
1627: (SELECT 'y'
1628: FROM xla_event_sources xes
1629: WHERE xes.source_application_id = xco.value_source_application_id
1630: AND xes.source_type_code = xco.value_source_type_code
1631: AND xes.source_code = xco.value_source_code
1632: AND xes.application_id = p_application_id

Line 1739: FROM xla_event_sources xes

1735: AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
1736: AND xco.source_type_code = 'S'
1737: AND NOT EXISTS
1738: (SELECT 'y'
1739: FROM xla_event_sources xes
1740: WHERE xes.source_application_id = xco.source_application_id
1741: AND xes.source_type_code = xco.source_type_code
1742: AND xes.source_code = xco.source_code
1743: AND xes.application_id = p_application_id

Line 1759: FROM xla_event_sources xes

1755: AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
1756: AND xco.value_source_type_code = 'S'
1757: AND NOT EXISTS
1758: (SELECT 'y'
1759: FROM xla_event_sources xes
1760: WHERE xes.source_application_id = xco.value_source_application_id
1761: AND xes.source_type_code = xco.value_source_type_code
1762: AND xes.source_code = xco.value_source_code
1763: AND xes.application_id = p_application_id

Line 1998: FROM xla_event_sources xes

1994: AND xjl.line_definition_code = p_line_definition_code
1995: AND xjl.active_flag = 'Y'
1996: AND NOT EXISTS
1997: (SELECT 'y'
1998: FROM xla_event_sources xes
1999: WHERE xes.source_application_id = xsr.value_source_application_id
2000: AND xes.source_type_code = xsr.value_source_type_code
2001: AND xes.source_code = xsr.value_source_code
2002: AND xes.application_id = xsr.application_id

Line 2034: FROM xla_event_sources xes

2030: AND xjl.line_definition_code = p_line_definition_code
2031: AND xjl.active_flag = 'Y'
2032: AND NOT EXISTS
2033: (SELECT 'y'
2034: FROM xla_event_sources xes
2035: WHERE xes.source_application_id = xsr.input_source_application_id
2036: AND xes.source_type_code = xsr.input_source_type_code
2037: AND xes.source_code = xsr.input_source_code
2038: AND xes.application_id = xsr.application_id

Line 2136: FROM xla_event_sources xes

2132: AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
2133: AND xsr.value_source_type_code = 'S'
2134: AND NOT EXISTS
2135: (SELECT 'y'
2136: FROM xla_event_sources xes
2137: WHERE xes.source_application_id = xsr.value_source_application_id
2138: AND xes.source_type_code = xsr.value_source_type_code
2139: AND xes.source_code = xsr.value_source_code
2140: AND xes.application_id = xsr.application_id

Line 2154: FROM xla_event_sources xes

2150: AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
2151: AND xsr.input_source_type_code = 'S'
2152: AND NOT EXISTS
2153: (SELECT 'y'
2154: FROM xla_event_sources xes
2155: WHERE xes.source_application_id = xsr.input_source_application_id
2156: AND xes.source_type_code = xsr.input_source_type_code
2157: AND xes.source_code = xsr.input_source_code
2158: AND xes.application_id = xsr.application_id

Line 3648: FROM xla_event_sources xes

3644: AND xco.accounting_line_code = xld.accounting_line_code
3645: AND xco.source_type_code = 'S'
3646: AND NOT EXISTS
3647: (SELECT 'y'
3648: FROM xla_event_sources xes
3649: WHERE xes.source_application_id = xco.source_application_id
3650: AND xes.source_type_code = xco.source_type_code
3651: AND xes.source_code = xco.source_code
3652: AND xes.application_id = p_application_id

Line 3675: FROM xla_event_sources xes

3671: AND xco.accounting_line_code = xld.accounting_line_code
3672: AND xco.value_source_type_code = 'S'
3673: AND NOT EXISTS
3674: (SELECT 'y'
3675: FROM xla_event_sources xes
3676: WHERE xes.source_application_id = xco.value_source_application_id
3677: AND xes.source_type_code = xco.value_source_type_code
3678: AND xes.source_code = xco.value_source_code
3679: AND xes.application_id = p_application_id

Line 4823: FROM xla_event_sources xes

4819: AND xjl.active_flag = 'Y'
4820: AND xco.source_type_code = 'S'
4821: AND NOT EXISTS
4822: (SELECT 'y'
4823: FROM xla_event_sources xes
4824: WHERE xes.source_application_id = xco.source_application_id
4825: AND xes.source_type_code = xco.source_type_code
4826: AND xes.source_code = xco.source_code
4827: AND xes.application_id = xjl.application_id

Line 4851: FROM xla_event_sources xes

4847: AND xjl.active_flag = 'Y'
4848: AND xco.value_source_type_code = 'S'
4849: AND NOT EXISTS
4850: (SELECT 'y'
4851: FROM xla_event_sources xes
4852: WHERE xes.source_application_id = xco.value_source_application_id
4853: AND xes.source_type_code = xco.value_source_type_code
4854: AND xes.source_code = xco.value_source_code
4855: AND xes.application_id = xjl.application_id

Line 5047: FROM xla_event_sources xes

5043: AND xjl.active_flag = 'Y'
5044: AND xdd.source_type_code = 'S'
5045: AND NOT EXISTS
5046: (SELECT 'y'
5047: FROM xla_event_sources xes
5048: WHERE xes.source_application_id = xdd.source_application_id
5049: AND xes.source_type_code = xdd.source_type_code
5050: AND xes.source_code = xdd.source_code
5051: AND xes.application_id = xjl.application_id

Line 5510: ,xla_event_sources xes

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
5512: AND xas.amb_context_code = xac.amb_context_code
5513: AND xas.event_class_code = xac.event_class_code
5514: AND xas.analytical_criterion_code = xac.analytical_criterion_code

Line 5533: FROM xla_event_sources xes

5529: AND xjl.line_definition_owner_code = p_line_definition_owner_code
5530: AND xjl.line_definition_code = p_line_definition_code
5531: AND xjl.active_flag = 'Y'
5532: AND not exists (SELECT 'y'
5533: FROM xla_event_sources xes
5534: WHERE xes.source_application_id = xas.source_application_id
5535: AND xes.source_type_code = xas.source_type_code
5536: AND xes.source_code = xas.source_code
5537: AND xes.application_id = xas.application_id

Line 6390: FROM xla_event_sources xes

6386: AND xld1.accounting_line_type_code = mpa.mpa_accounting_line_type_code
6387: AND xld1.accounting_line_code = mpa.mpa_accounting_line_code)
6388: AND NOT EXISTS
6389: (SELECT 'y'
6390: FROM xla_event_sources xes
6391: WHERE xes.source_application_id = xco.source_application_id
6392: AND xes.source_type_code = xco.source_type_code
6393: AND xes.source_code = xco.source_code
6394: AND xes.application_id = p_application_id

Line 6437: FROM xla_event_sources xes

6433: AND xld1.accounting_line_type_code = mpa.mpa_accounting_line_type_code
6434: AND xld1.accounting_line_code = mpa.mpa_accounting_line_code)
6435: AND NOT EXISTS
6436: (SELECT 'y'
6437: FROM xla_event_sources xes
6438: WHERE xes.source_application_id = xco.value_source_application_id
6439: AND xes.source_type_code = xco.value_source_type_code
6440: AND xes.source_code = xco.value_source_code
6441: AND xes.application_id = p_application_id

Line 7398: FROM xla_event_sources xes

7394: AND mjl.description_code IS NOT NULL
7395: AND xco.source_type_code = 'S'
7396: AND NOT EXISTS
7397: (SELECT 'y'
7398: FROM xla_event_sources xes
7399: WHERE xes.source_application_id = xco.source_application_id
7400: AND xes.source_type_code = xco.source_type_code
7401: AND xes.source_code = xco.source_code
7402: AND xes.application_id = mjl.application_id

Line 7436: FROM xla_event_sources xes

7432: AND xjl.accounting_line_code = mjl.accounting_line_code
7433: AND mjl.description_code IS NOT NULL
7434: AND NOT EXISTS
7435: (SELECT 'y'
7436: FROM xla_event_sources xes
7437: WHERE xes.source_application_id = xco.value_source_application_id
7438: AND xes.source_type_code = xco.value_source_type_code
7439: AND xes.source_code = xco.value_source_code
7440: AND xes.application_id = mjl.application_id

Line 7662: FROM xla_event_sources xes

7658: AND xjl.accounting_line_code = mjl.accounting_line_code
7659: AND mjl.description_code IS NOT NULL
7660: AND NOT EXISTS
7661: (SELECT 'y'
7662: FROM xla_event_sources xes
7663: WHERE xes.source_application_id = xdd.source_application_id
7664: AND xes.source_type_code = xdd.source_type_code
7665: AND xes.source_code = xdd.source_code
7666: AND xes.application_id = mjl.application_id

Line 8134: ,xla_event_sources xes

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
8136: AND xas.amb_context_code = xac.amb_context_code
8137: AND xas.event_class_code = xac.event_class_code
8138: AND xas.analytical_criterion_code = xac.analytical_criterion_code

Line 8157: FROM xla_event_sources xes

8153: AND xjl.line_definition_owner_code = p_line_definition_owner_code
8154: AND xjl.line_definition_code = p_line_definition_code
8155: AND xjl.active_flag = 'Y'
8156: AND not exists (SELECT 'y'
8157: FROM xla_event_sources xes
8158: WHERE xes.source_application_id = xas.source_application_id
8159: AND xes.source_type_code = xas.source_type_code
8160: AND xes.source_code = xas.source_code
8161: AND xes.application_id = xas.application_id

Line 9090: FROM xla_event_sources xes

9086: AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
9087: AND xld1.accounting_line_code = xad.mpa_accounting_line_code)
9088: AND NOT EXISTS
9089: (SELECT 'y'
9090: FROM xla_event_sources xes
9091: WHERE xes.source_application_id = xco.source_application_id
9092: AND xes.source_type_code = xco.source_type_code
9093: AND xes.source_code = xco.source_code
9094: AND xes.application_id = p_application_id

Line 9138: FROM xla_event_sources xes

9134: AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
9135: AND xld1.accounting_line_code = xad.mpa_accounting_line_code)
9136: AND NOT EXISTS
9137: (SELECT 'y'
9138: FROM xla_event_sources xes
9139: WHERE xes.source_application_id = xco.value_source_application_id
9140: AND xes.source_type_code = xco.value_source_type_code
9141: AND xes.source_code = xco.value_source_code
9142: AND xes.application_id = p_application_id

Line 9278: FROM xla_event_sources xes

9274: AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
9275: AND xco.source_type_code = 'S'
9276: AND NOT EXISTS
9277: (SELECT 'y'
9278: FROM xla_event_sources xes
9279: WHERE xes.source_application_id = xco.source_application_id
9280: AND xes.source_type_code = xco.source_type_code
9281: AND xes.source_code = xco.source_code
9282: AND xes.application_id = p_application_id

Line 9298: FROM xla_event_sources xes

9294: AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
9295: AND xco.value_source_type_code = 'S'
9296: AND NOT EXISTS
9297: (SELECT 'y'
9298: FROM xla_event_sources xes
9299: WHERE xes.source_application_id = xco.value_source_application_id
9300: AND xes.source_type_code = xco.value_source_type_code
9301: AND xes.source_code = xco.value_source_code
9302: AND xes.application_id = p_application_id

Line 9550: FROM xla_event_sources xes

9546: AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
9547: AND xld1.accounting_line_code = xad.mpa_accounting_line_code)
9548: AND NOT EXISTS
9549: (SELECT 'y'
9550: FROM xla_event_sources xes
9551: WHERE xes.source_application_id = xsr.value_source_application_id
9552: AND xes.source_type_code = xsr.value_source_type_code
9553: AND xes.source_code = xsr.value_source_code
9554: AND xes.application_id = xsr.application_id

Line 9596: FROM xla_event_sources xes

9592: AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
9593: AND xld1.accounting_line_code = xad.mpa_accounting_line_code)
9594: AND NOT EXISTS
9595: (SELECT 'y'
9596: FROM xla_event_sources xes
9597: WHERE xes.source_application_id = xsr.input_source_application_id
9598: AND xes.source_type_code = xsr.input_source_type_code
9599: AND xes.source_code = xsr.input_source_code
9600: AND xes.application_id = xsr.application_id

Line 9727: FROM xla_event_sources xes

9723: AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
9724: AND xsr.value_source_type_code = 'S'
9725: AND NOT EXISTS
9726: (SELECT 'y'
9727: FROM xla_event_sources xes
9728: WHERE xes.source_application_id = xsr.value_source_application_id
9729: AND xes.source_type_code = xsr.value_source_type_code
9730: AND xes.source_code = xsr.value_source_code
9731: AND xes.application_id = xsr.application_id

Line 9745: FROM xla_event_sources xes

9741: AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code
9742: AND xsr.input_source_type_code = 'S'
9743: AND NOT EXISTS
9744: (SELECT 'y'
9745: FROM xla_event_sources xes
9746: WHERE xes.source_application_id = xsr.input_source_application_id
9747: AND xes.source_type_code = xsr.input_source_type_code
9748: AND xes.source_code = xsr.input_source_code
9749: AND xes.application_id = xsr.application_id

Line 10624: FROM xla_event_sources xes

10620: AND xjl.active_flag = 'Y'
10621: AND xdd.source_type_code = 'S'
10622: AND NOT EXISTS
10623: (SELECT 'y'
10624: FROM xla_event_sources xes
10625: WHERE xes.source_application_id = xdd.source_application_id
10626: AND xes.source_type_code = xdd.source_type_code
10627: AND xes.source_code = xdd.source_code
10628: AND xes.application_id = xjl.application_id

Line 10782: FROM xla_event_sources xes

10778: AND xjl.active_flag = 'Y'
10779: AND xco.source_type_code = 'S'
10780: AND NOT EXISTS
10781: (SELECT 'y'
10782: FROM xla_event_sources xes
10783: WHERE xes.source_application_id = xco.source_application_id
10784: AND xes.source_type_code = xco.source_type_code
10785: AND xes.source_code = xco.source_code
10786: AND xes.application_id = xjl.application_id

Line 10810: FROM xla_event_sources xes

10806: AND xjl.active_flag = 'Y'
10807: AND xco.value_source_type_code = 'S'
10808: AND NOT EXISTS
10809: (SELECT 'y'
10810: FROM xla_event_sources xes
10811: WHERE xes.source_application_id = xco.value_source_application_id
10812: AND xes.source_type_code = xco.value_source_type_code
10813: AND xes.source_code = xco.value_source_code
10814: AND xes.application_id = xjl.application_id

Line 11280: ,xla_event_sources xes

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
11282: AND xas.amb_context_code = xac.amb_context_code
11283: AND xas.event_class_code = xac.event_class_code
11284: AND xas.analytical_criterion_code = xac.analytical_criterion_code

Line 11303: FROM xla_event_sources xes

11299: AND xjl.line_definition_owner_code = p_line_definition_owner_code
11300: AND xjl.line_definition_code = p_line_definition_code
11301: AND xjl.active_flag = 'Y'
11302: AND not exists (SELECT 'y'
11303: FROM xla_event_sources xes
11304: WHERE xes.source_application_id = xas.source_application_id
11305: AND xes.source_type_code = xas.source_type_code
11306: AND xes.source_code = xas.source_code
11307: AND xes.application_id = xas.application_id