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_CONDITIONS

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 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 528: FROM xla_conditions c, xla_seg_rule_details d

524: AND s.active_flag = 'Y');
525:
526: CURSOR c_seg_condition_sources IS
527: SELECT 'x'
528: FROM xla_conditions c, xla_seg_rule_details d
529: WHERE c.segment_rule_detail_id = d.segment_rule_detail_id
530: AND d.application_id = NVL(p_segment_rule_appl_id
531: ,p_application_id)
532: AND d.amb_context_code = p_amb_context_code

Line 548: FROM xla_conditions c, xla_seg_rule_details d

544: AND s.event_class_code = p_event_class_code
545: AND s.active_flag = 'Y')
546: UNION
547: SELECT 'x'
548: FROM xla_conditions c, xla_seg_rule_details d
549: WHERE c.segment_rule_detail_id = d.segment_rule_detail_id
550: AND d.application_id = NVL(p_segment_rule_appl_id
551: ,p_application_id)
552: AND d.amb_context_code = p_amb_context_code

Line 590: FROM xla_conditions c, xla_seg_rule_details d

586: AND input_source_type_code = 'D';
587:
588: CURSOR c_seg_condition_der_sources IS
589: SELECT c.source_type_code source_type_code, c.source_code source_code
590: FROM xla_conditions c, xla_seg_rule_details d
591: WHERE c.segment_rule_detail_id = d.segment_rule_detail_id
592: AND d.application_id = NVL(p_segment_rule_appl_id
593: ,p_application_id)
594: AND d.amb_context_code = p_amb_context_code

Line 601: FROM xla_conditions c, xla_seg_rule_details d

597: AND c.source_code IS NOT NULL
598: AND c.source_type_code = 'D'
599: UNION
600: SELECT c.value_source_type_code source_type_code, c.value_source_code source_code
601: FROM xla_conditions c, xla_seg_rule_details d
602: WHERE c.segment_rule_detail_id = d.segment_rule_detail_id
603: AND d.application_id = NVL(p_segment_rule_appl_id
604: ,p_application_id)
605: AND d.amb_context_code = p_amb_context_code

Line 1562: FROM xla_conditions xco

1558: --
1559: CURSOR c_invalid_sources IS
1560: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
1561: xco.source_type_code, xco.source_code
1562: FROM xla_conditions xco
1563: ,xla_seg_rule_details xsr
1564: ,xla_line_defn_adr_assgns xad
1565: ,xla_line_defn_jlt_assgns xjl
1566: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id

Line 1600: FROM xla_conditions xco

1596: AND xes.active_flag = 'Y')
1597: UNION
1598: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
1599: xco.value_source_type_code source_type_code, xco.value_source_code source_code
1600: FROM xla_conditions xco
1601: ,xla_seg_rule_details xsr
1602: ,xla_line_defn_adr_assgns xad
1603: ,xla_line_defn_jlt_assgns xjl
1604: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id

Line 1639: FROM xla_conditions xco

1635:
1636: CURSOR c_cond_der_sources IS
1637: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
1638: xco.source_type_code source_type_code, xco.source_code source_code
1639: FROM xla_conditions xco
1640: ,xla_seg_rule_details xsr
1641: ,xla_line_defn_adr_assgns xad
1642: ,xla_line_defn_jlt_assgns xjl
1643: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id

Line 1668: FROM xla_conditions xco

1664: AND xjl.active_flag = 'Y'
1665: UNION
1666: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
1667: xco.value_source_type_code source_type_code, xco.value_source_code source_code
1668: FROM xla_conditions xco
1669: ,xla_seg_rule_details xsr
1670: ,xla_line_defn_adr_assgns xad
1671: ,xla_line_defn_jlt_assgns xjl
1672: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id

Line 1729: FROM xla_conditions xco

1725:
1726: CURSOR c_invalid_child_sources IS
1727: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
1728: xco.source_type_code, xco.source_code
1729: FROM xla_conditions xco
1730: ,xla_seg_rule_details xsr
1731: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
1732: AND xsr.application_id = l_child_adr.value_segment_rule_appl_id
1733: AND xsr.amb_context_code = p_amb_context_code

Line 1749: FROM xla_conditions xco

1745: AND xes.active_flag = 'Y')
1746: UNION
1747: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
1748: xco.value_source_type_code source_type_code, xco.value_source_code source_code
1749: FROM xla_conditions xco
1750: ,xla_seg_rule_details xsr
1751: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
1752: AND xsr.application_id = l_child_adr.value_segment_rule_appl_id
1753: AND xsr.amb_context_code = p_amb_context_code

Line 1770: FROM xla_conditions xco

1766:
1767: CURSOR c_child_der_sources IS
1768: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
1769: xco.source_type_code source_type_code, xco.source_code source_code
1770: FROM xla_conditions xco
1771: ,xla_seg_rule_details xsr
1772: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
1773: AND xsr.application_id = l_child_adr.value_segment_rule_appl_id
1774: AND xsr.amb_context_code = p_amb_context_code

Line 1781: FROM xla_conditions xco

1777: AND xco.source_type_code = 'D'
1778: UNION
1779: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
1780: xco.value_source_type_code source_type_code, xco.value_source_code source_code
1781: FROM xla_conditions xco
1782: ,xla_seg_rule_details xsr
1783: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
1784: AND xsr.application_id = l_child_adr.value_segment_rule_appl_id
1785: AND xsr.amb_context_code = p_amb_context_code

Line 3632: FROM xla_conditions xco, xla_line_defn_jlt_assgns xld

3628: CURSOR c_invalid_sources IS
3629: SELECT distinct xld.event_class_code, xld.event_type_code,
3630: xld.accounting_line_type_code, xld.accounting_line_code,
3631: xco.source_type_code, xco.source_code
3632: FROM xla_conditions xco, xla_line_defn_jlt_assgns xld
3633: WHERE xld.application_id = p_application_id
3634: AND xld.amb_context_code = p_amb_context_code
3635: AND xld.event_class_code = p_event_class_code
3636: AND xld.event_type_code = p_event_type_code

Line 3659: FROM xla_conditions xco, xla_line_defn_jlt_assgns xld

3655: UNION
3656: SELECT distinct xld.event_class_code, xld.event_type_code,
3657: xld.accounting_line_type_code, xld.accounting_line_code,
3658: xco.value_source_type_code source_type_code, xco.value_source_code source_code
3659: FROM xla_conditions xco, xla_line_defn_jlt_assgns xld
3660: WHERE xld.application_id = p_application_id
3661: AND xld.amb_context_code = p_amb_context_code
3662: AND xld.event_class_code = p_event_class_code
3663: AND xld.event_type_code = p_event_type_code

Line 3690: FROM xla_conditions xco, xla_line_defn_jlt_assgns xld

3686: CURSOR c_jlt_cond_der_sources IS
3687: SELECT distinct xld.event_class_code, xld.event_type_code,
3688: xld.accounting_line_type_code, xld.accounting_line_code,
3689: xco.source_type_code, xco.source_code
3690: FROM xla_conditions xco, xla_line_defn_jlt_assgns xld
3691: WHERE xld.application_id = p_application_id
3692: AND xld.amb_context_code = p_amb_context_code
3693: AND xld.event_class_code = p_event_class_code
3694: AND xld.event_type_code = p_event_type_code

Line 3708: FROM xla_conditions xco, xla_line_defn_jlt_assgns xld

3704: UNION
3705: SELECT distinct xld.event_class_code, xld.event_type_code,
3706: xld.accounting_line_type_code, xld.accounting_line_code,
3707: xco.value_source_type_code source_type_code, xco.value_source_code source_code
3708: FROM xla_conditions xco, xla_line_defn_jlt_assgns xld
3709: WHERE xld.application_id = p_application_id
3710: AND xld.amb_context_code = p_amb_context_code
3711: AND xld.event_class_code = p_event_class_code
3712: AND xld.event_type_code = p_event_type_code

Line 4805: FROM xla_conditions xco

4801: --
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

Line 4833: FROM xla_conditions xco

4829: AND xes.active_flag = 'Y')
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

Line 4862: FROM xla_conditions xco

4858:
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

Line 4881: FROM xla_conditions xco

4877: AND xco.source_type_code = 'D'
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

Line 6354: FROM xla_conditions xco

6350: CURSOR c_invalid_sources IS
6351: SELECT distinct mpa.event_class_code, mpa.event_type_code,
6352: mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code,
6353: xco.source_type_code, xco.source_code
6354: FROM xla_conditions xco
6355: ,xla_line_defn_jlt_assgns xld
6356: ,xla_mpa_jlt_assgns mpa
6357: WHERE xld.application_id = p_application_id
6358: AND xld.amb_context_code = p_amb_context_code

Line 6401: FROM xla_conditions xco

6397: UNION
6398: SELECT distinct mpa.event_class_code, mpa.event_type_code,
6399: mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code,
6400: xco.value_source_type_code source_type_code, xco.value_source_code source_code
6401: FROM xla_conditions xco
6402: ,xla_line_defn_jlt_assgns xld
6403: ,xla_mpa_jlt_assgns mpa
6404: WHERE xld.application_id = p_application_id
6405: AND xld.amb_context_code = p_amb_context_code

Line 6452: FROM xla_conditions xco

6448: CURSOR c_jlt_cond_der_sources IS
6449: SELECT distinct mpa.event_class_code, mpa.event_type_code,
6450: mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code,
6451: xco.source_type_code, xco.source_code
6452: FROM xla_conditions xco
6453: ,xla_line_defn_jlt_assgns xld
6454: ,xla_mpa_jlt_assgns mpa
6455: WHERE xld.application_id = p_application_id
6456: AND xld.amb_context_code = p_amb_context_code

Line 6490: FROM xla_conditions xco

6486: UNION
6487: SELECT distinct mpa.event_class_code, mpa.event_type_code,
6488: mpa.mpa_accounting_line_type_code, mpa.mpa_accounting_line_code,
6489: xco.value_source_type_code source_type_code, xco.value_source_code source_code
6490: FROM xla_conditions xco
6491: ,xla_line_defn_jlt_assgns xld
6492: ,xla_mpa_jlt_assgns mpa
6493: WHERE xld.application_id = p_application_id
6494: AND xld.amb_context_code = p_amb_context_code

Line 7370: FROM xla_conditions xco

7366: --
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

Line 7408: FROM xla_conditions xco

7404: AND xes.active_flag = 'Y')
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

Line 7447: FROM xla_conditions xco

7443:
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

Line 7476: FROM xla_conditions xco

7472: AND mjl.description_code IS NOT NULL
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

Line 9052: FROM xla_conditions xco

9048: --
9049: CURSOR c_invalid_sources IS
9050: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9051: xco.source_type_code, xco.source_code
9052: FROM xla_conditions xco
9053: ,xla_seg_rule_details xsr
9054: ,xla_mpa_jlt_adr_assgns xad
9055: ,xla_line_defn_jlt_assgns xjl
9056: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id

Line 9100: FROM xla_conditions xco

9096: AND xes.active_flag = 'Y')
9097: UNION
9098: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9099: xco.value_source_type_code source_type_code, xco.value_source_code source_code
9100: FROM xla_conditions xco
9101: ,xla_seg_rule_details xsr
9102: ,xla_mpa_jlt_adr_assgns xad
9103: ,xla_line_defn_jlt_assgns xjl
9104: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id

Line 9149: FROM xla_conditions xco

9145:
9146: CURSOR c_cond_der_sources IS
9147: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9148: xco.source_type_code source_type_code, xco.source_code source_code
9149: FROM xla_conditions xco
9150: ,xla_seg_rule_details xsr
9151: ,xla_mpa_jlt_adr_assgns xad
9152: ,xla_line_defn_jlt_assgns xjl
9153: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id

Line 9188: FROM xla_conditions xco

9184: AND xld1.accounting_line_code = xad.mpa_accounting_line_code)
9185: UNION
9186: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9187: xco.value_source_type_code source_type_code, xco.value_source_code source_code
9188: FROM xla_conditions xco
9189: ,xla_seg_rule_details xsr
9190: ,xla_mpa_jlt_adr_assgns xad
9191: ,xla_line_defn_jlt_assgns xjl
9192: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id

Line 9268: FROM xla_conditions xco

9264:
9265: CURSOR c_invalid_child_sources IS
9266: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9267: xco.source_type_code, xco.source_code
9268: FROM xla_conditions xco
9269: ,xla_seg_rule_details xsr
9270: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
9271: AND xsr.application_id = l_child_adr.value_segment_rule_appl_id
9272: AND xsr.amb_context_code = p_amb_context_code

Line 9288: FROM xla_conditions xco

9284: AND xes.active_flag = 'Y')
9285: UNION
9286: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9287: xco.value_source_type_code source_type_code, xco.value_source_code source_code
9288: FROM xla_conditions xco
9289: ,xla_seg_rule_details xsr
9290: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
9291: AND xsr.application_id = l_child_adr.value_segment_rule_appl_id
9292: AND xsr.amb_context_code = p_amb_context_code

Line 9309: FROM xla_conditions xco

9305:
9306: CURSOR c_child_der_sources IS
9307: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9308: xco.source_type_code source_type_code, xco.source_code source_code
9309: FROM xla_conditions xco
9310: ,xla_seg_rule_details xsr
9311: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
9312: AND xsr.application_id = l_child_adr.value_segment_rule_appl_id
9313: AND xsr.amb_context_code = p_amb_context_code

Line 9320: FROM xla_conditions xco

9316: AND xco.source_type_code = 'D'
9317: UNION
9318: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9319: xco.value_source_type_code source_type_code, xco.value_source_code source_code
9320: FROM xla_conditions xco
9321: ,xla_seg_rule_details xsr
9322: WHERE xco.segment_rule_detail_id = xsr.segment_rule_detail_id
9323: AND xsr.application_id = l_child_adr.value_segment_rule_appl_id
9324: AND xsr.amb_context_code = p_amb_context_code

Line 10764: FROM xla_conditions xco

10760: IS
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

Line 10792: FROM xla_conditions xco

10788: AND xes.active_flag = 'Y')
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

Line 10821: FROM xla_conditions xco

10817:
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

Line 10840: FROM xla_conditions xco

10836: AND xco.source_type_code = 'D'
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