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_SEG_RULE_DETAILS

Line 480: FROM xla_seg_rule_details d

476: l_exist VARCHAR2(1);
477:
478: CURSOR c_seg_details IS
479: SELECT 'x'
480: FROM xla_seg_rule_details d
481: WHERE application_id = NVL(p_segment_rule_appl_id
482: ,p_application_id)
483: AND amb_context_code = p_amb_context_code
484: AND segment_rule_type_code = p_segment_rule_type_code

Line 489: FROM xla_seg_rule_details d

485: AND segment_rule_code = p_segment_rule_code;
486:
487: CURSOR c_seg_value_sources IS
488: SELECT 'x'
489: FROM xla_seg_rule_details d
490: WHERE application_id = NVL(p_segment_rule_appl_id
491: ,p_application_id)
492: AND amb_context_code = p_amb_context_code
493: AND segment_rule_type_code = p_segment_rule_type_code

Line 508: FROM xla_seg_rule_details d

504: AND s.event_class_code = p_event_class_code
505: AND s.active_flag = 'Y')
506: UNION
507: SELECT 'x'
508: FROM xla_seg_rule_details d
509: WHERE application_id = NVL(p_segment_rule_appl_id
510: ,p_application_id)
511: AND amb_context_code = p_amb_context_code
512: AND segment_rule_type_code = p_segment_rule_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 569: FROM xla_seg_rule_details d

565: AND s.active_flag = 'Y');
566:
567: CURSOR c_seg_value_der_sources IS
568: SELECT value_source_type_code source_type_code, value_source_code source_code
569: FROM xla_seg_rule_details d
570: WHERE application_id = NVL(p_segment_rule_appl_id,
571: p_application_id)
572: AND amb_context_code = p_amb_context_code
573: AND segment_rule_type_code = p_segment_rule_type_code

Line 579: FROM xla_seg_rule_details d

575: AND value_source_code IS NOT NULL
576: AND value_source_type_code = 'D'
577: UNION
578: SELECT input_source_type_code source_type_code, input_source_code source_code
579: FROM xla_seg_rule_details d
580: WHERE application_id = NVL(p_segment_rule_appl_id,
581: p_application_id)
582: AND amb_context_code = p_amb_context_code
583: AND segment_rule_type_code = p_segment_rule_type_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 1252: FROM xla_seg_rule_details xsd

1248: l_adr c_adr%rowtype;
1249:
1250: CURSOR c_invalid_child_adr IS
1251: SELECT xsd.value_segment_rule_type_code, xsd.value_segment_rule_code
1252: FROM xla_seg_rule_details xsd
1253: ,xla_seg_rules_b xsr
1254: WHERE xsd.application_id = l_adr.application_id
1255: AND xsd.amb_context_code = l_adr.amb_context_code
1256: AND xsd.segment_rule_type_code = l_adr.segment_rule_type_code

Line 1396: FROM xla_seg_rule_details xsr

1392: AND xjl.active_flag = 'Y'
1393: AND xad.segment_rule_code is not null
1394: AND NOT EXISTS
1395: (SELECT 'x'
1396: FROM xla_seg_rule_details xsr
1397: WHERE xsr.application_id = NVL(xad.segment_rule_appl_id,xad.application_id)
1398: AND xsr.amb_context_code = xad.amb_context_code
1399: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
1400: AND xsr.segment_rule_code = xad.segment_rule_code);

Line 1433: FROM xla_seg_rule_details xsd

1429: l_adr c_adr%rowtype;
1430:
1431: CURSOR c_invalid_child_adr IS
1432: SELECT xsd.value_segment_rule_type_code, xsd.value_segment_rule_code
1433: FROM xla_seg_rule_details xsd
1434: WHERE xsd.application_id = l_adr.application_id
1435: AND xsd.amb_context_code = l_adr.amb_context_code
1436: AND xsd.segment_rule_type_code = l_adr.segment_rule_type_code
1437: AND xsd.segment_rule_code = l_adr.segment_rule_code

Line 1440: FROM xla_seg_rule_details xcd

1436: AND xsd.segment_rule_type_code = l_adr.segment_rule_type_code
1437: AND xsd.segment_rule_code = l_adr.segment_rule_code
1438: AND xsd.value_type_code = 'A'
1439: AND not exists (SELECT 'x'
1440: FROM xla_seg_rule_details xcd
1441: WHERE xcd.application_id = xsd.value_segment_rule_appl_id
1442: AND xcd.amb_context_code = xsd.amb_context_code
1443: AND xcd.segment_rule_type_code = xsd.value_segment_rule_type_code
1444: AND xcd.segment_rule_code = xsd.value_segment_rule_code);

Line 1563: ,xla_seg_rule_details xsr

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
1567: AND xsr.application_id = xad.application_id

Line 1601: ,xla_seg_rule_details xsr

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
1605: AND xsr.application_id = xad.application_id

Line 1640: ,xla_seg_rule_details xsr

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
1644: AND xsr.application_id = xad.application_id

Line 1669: ,xla_seg_rule_details xsr

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
1673: AND xsr.application_id = xad.application_id

Line 1701: ,xla_seg_rule_details xsr

1697: xsr.value_segment_rule_appl_id,
1698: xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
1699: FROM xla_line_defn_jlt_assgns xjl
1700: ,xla_line_defn_adr_assgns xad
1701: ,xla_seg_rule_details xsr
1702: WHERE xsr.application_id = xad.application_id
1703: AND xsr.amb_context_code = xad.amb_context_code
1704: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
1705: AND xsr.segment_rule_code = xad.segment_rule_code

Line 1730: ,xla_seg_rule_details xsr

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
1734: AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code

Line 1750: ,xla_seg_rule_details xsr

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
1754: AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code

Line 1771: ,xla_seg_rule_details xsr

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
1775: AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code

Line 1782: ,xla_seg_rule_details xsr

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
1786: AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code

Line 1972: FROM xla_seg_rule_details xsr

1968: --
1969: CURSOR c_invalid_sources IS
1970: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
1971: xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
1972: FROM xla_seg_rule_details xsr
1973: ,xla_line_defn_adr_assgns xad
1974: ,xla_line_defn_jlt_assgns xjl
1975: WHERE xsr.application_id = xad.application_id
1976: AND xsr.amb_context_code = xad.amb_context_code

Line 2008: FROM xla_seg_rule_details xsr

2004: AND xes.active_flag = 'Y')
2005: UNION
2006: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
2007: xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
2008: FROM xla_seg_rule_details xsr
2009: ,xla_line_defn_adr_assgns xad
2010: ,xla_line_defn_jlt_assgns xjl
2011: WHERE xsr.application_id = xad.application_id
2012: AND xsr.amb_context_code = xad.amb_context_code

Line 2045: FROM xla_seg_rule_details xsr

2041:
2042: CURSOR c_der_sources IS
2043: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
2044: xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
2045: FROM xla_seg_rule_details xsr
2046: ,xla_line_defn_adr_assgns xad
2047: ,xla_line_defn_jlt_assgns xjl
2048: WHERE xsr.application_id = xad.application_id
2049: AND xsr.amb_context_code = xad.amb_context_code

Line 2070: FROM xla_seg_rule_details xsr

2066: AND xjl.active_flag = 'Y'
2067: UNION
2068: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
2069: xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
2070: FROM xla_seg_rule_details xsr
2071: ,xla_line_defn_adr_assgns xad
2072: ,xla_line_defn_jlt_assgns xjl
2073: WHERE xsr.application_id = xad.application_id
2074: AND xsr.amb_context_code = xad.amb_context_code

Line 2100: ,xla_seg_rule_details xsr

2096: xsr.value_segment_rule_appl_id,
2097: xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
2098: FROM xla_line_defn_jlt_assgns xjl
2099: ,xla_line_defn_adr_assgns xad
2100: ,xla_seg_rule_details xsr
2101: WHERE xsr.application_id = xad.application_id
2102: AND xsr.amb_context_code = xad.amb_context_code
2103: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
2104: AND xsr.segment_rule_code = xad.segment_rule_code

Line 2128: FROM xla_seg_rule_details xsr

2124:
2125: CURSOR c_invalid_child_sources IS
2126: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
2127: xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
2128: FROM xla_seg_rule_details xsr
2129: WHERE xsr.application_id = l_child_adr.value_segment_rule_appl_id
2130: AND xsr.amb_context_code = p_amb_context_code
2131: AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
2132: AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code

Line 2146: FROM xla_seg_rule_details xsr

2142: AND xes.active_flag = 'Y')
2143: UNION
2144: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
2145: xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
2146: FROM xla_seg_rule_details xsr
2147: WHERE xsr.application_id = l_child_adr.value_segment_rule_appl_id
2148: AND xsr.amb_context_code = p_amb_context_code
2149: AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
2150: AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code

Line 2165: FROM xla_seg_rule_details xsr

2161:
2162: CURSOR c_child_der_sources IS
2163: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
2164: xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
2165: FROM xla_seg_rule_details xsr
2166: WHERE xsr.application_id = l_child_adr.value_segment_rule_appl_id
2167: AND xsr.amb_context_code = p_amb_context_code
2168: AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
2169: AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code

Line 2174: FROM xla_seg_rule_details xsr

2170: AND xsr.value_source_type_code = 'D'
2171: UNION
2172: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
2173: xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
2174: FROM xla_seg_rule_details xsr
2175: WHERE xsr.application_id = l_child_adr.value_segment_rule_appl_id
2176: AND xsr.amb_context_code = p_amb_context_code
2177: AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
2178: AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code

Line 5776: FROM xla_seg_rule_details xsr

5772: IS
5773: CURSOR c_invalid_ms IS
5774: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
5775: xsr.value_mapping_set_code
5776: FROM xla_seg_rule_details xsr
5777: ,xla_line_defn_adr_assgns xad
5778: ,xla_line_defn_jlt_assgns xjl
5779: ,xla_mapping_sets_b xms
5780: WHERE xms.mapping_set_code = xsr.value_mapping_set_code

Line 8721: FROM xla_seg_rule_details xsd

8717: l_adr c_adr%rowtype;
8718:
8719: CURSOR c_invalid_child_adr IS
8720: SELECT xsd.value_segment_rule_type_code, xsd.value_segment_rule_code
8721: FROM xla_seg_rule_details xsd
8722: ,xla_seg_rules_b xsr
8723: WHERE xsd.application_id = l_adr.application_id
8724: AND xsd.amb_context_code = l_adr.amb_context_code
8725: AND xsd.segment_rule_type_code = l_adr.segment_rule_type_code

Line 8876: FROM xla_seg_rule_details xsr

8872: AND xld1.accounting_line_type_code = xad.mpa_accounting_line_type_code
8873: AND xld1.accounting_line_code = xad.mpa_accounting_line_code)
8874: AND NOT EXISTS
8875: (SELECT 'x'
8876: FROM xla_seg_rule_details xsr
8877: WHERE xsr.application_id = NVL(xad.segment_rule_appl_id,xad.application_id)
8878: AND xsr.amb_context_code = xad.amb_context_code
8879: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
8880: AND xsr.segment_rule_code = xad.segment_rule_code);

Line 8923: FROM xla_seg_rule_details xsd

8919: l_adr c_adr%rowtype;
8920:
8921: CURSOR c_invalid_child_adr IS
8922: SELECT xsd.value_segment_rule_type_code, xsd.value_segment_rule_code
8923: FROM xla_seg_rule_details xsd
8924: WHERE xsd.application_id = l_adr.application_id
8925: AND xsd.amb_context_code = l_adr.amb_context_code
8926: AND xsd.segment_rule_type_code = l_adr.segment_rule_type_code
8927: AND xsd.segment_rule_code = l_adr.segment_rule_code

Line 8930: FROM xla_seg_rule_details xcd

8926: AND xsd.segment_rule_type_code = l_adr.segment_rule_type_code
8927: AND xsd.segment_rule_code = l_adr.segment_rule_code
8928: AND xsd.value_type_code = 'A'
8929: AND not exists (SELECT 'x'
8930: FROM xla_seg_rule_details xcd
8931: WHERE xcd.application_id = xsd.value_segment_rule_appl_id
8932: AND xcd.amb_context_code = xsd.amb_context_code
8933: AND xcd.segment_rule_type_code = xsd.value_segment_rule_type_code
8934: AND xcd.segment_rule_code = xsd.value_segment_rule_code);

Line 9053: ,xla_seg_rule_details xsr

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
9057: AND xsr.application_id = xad.application_id

Line 9101: ,xla_seg_rule_details xsr

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
9105: AND xsr.application_id = xad.application_id

Line 9150: ,xla_seg_rule_details xsr

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
9154: AND xsr.application_id = xad.application_id

Line 9189: ,xla_seg_rule_details xsr

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
9193: AND xsr.application_id = xad.application_id

Line 9230: ,xla_seg_rule_details xsr

9226: SELECT distinct xsr.value_segment_rule_appl_id,
9227: xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
9228: FROM xla_line_defn_jlt_assgns xjl
9229: ,xla_mpa_jlt_adr_assgns xad
9230: ,xla_seg_rule_details xsr
9231: WHERE xsr.application_id = xad.application_id
9232: AND xsr.amb_context_code = xad.amb_context_code
9233: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
9234: AND xsr.segment_rule_code = xad.segment_rule_code

Line 9269: ,xla_seg_rule_details xsr

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
9273: AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code

Line 9289: ,xla_seg_rule_details xsr

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
9293: AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code

Line 9310: ,xla_seg_rule_details xsr

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
9314: AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code

Line 9321: ,xla_seg_rule_details xsr

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
9325: AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code

Line 9514: FROM xla_seg_rule_details xsr

9510: --
9511: CURSOR c_invalid_sources IS
9512: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9513: xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
9514: FROM xla_seg_rule_details xsr
9515: ,xla_mpa_jlt_adr_assgns xad
9516: ,xla_line_defn_jlt_assgns xjl
9517: WHERE xsr.application_id = xad.application_id
9518: AND xsr.amb_context_code = xad.amb_context_code

Line 9560: FROM xla_seg_rule_details xsr

9556: AND xes.active_flag = 'Y')
9557: UNION
9558: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9559: xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
9560: FROM xla_seg_rule_details xsr
9561: ,xla_mpa_jlt_adr_assgns xad
9562: ,xla_line_defn_jlt_assgns xjl
9563: WHERE xsr.application_id = xad.application_id
9564: AND xsr.amb_context_code = xad.amb_context_code

Line 9607: FROM xla_seg_rule_details xsr

9603:
9604: CURSOR c_der_sources IS
9605: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9606: xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
9607: FROM xla_seg_rule_details xsr
9608: ,xla_mpa_jlt_adr_assgns xad
9609: ,xla_line_defn_jlt_assgns xjl
9610: WHERE xsr.application_id = xad.application_id
9611: AND xsr.amb_context_code = xad.amb_context_code

Line 9642: FROM xla_seg_rule_details xsr

9638: AND xld1.accounting_line_code = xad.mpa_accounting_line_code)
9639: UNION
9640: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9641: xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
9642: FROM xla_seg_rule_details xsr
9643: ,xla_mpa_jlt_adr_assgns xad
9644: ,xla_line_defn_jlt_assgns xjl
9645: WHERE xsr.application_id = xad.application_id
9646: AND xsr.amb_context_code = xad.amb_context_code

Line 9681: ,xla_seg_rule_details xsr

9677: SELECT distinct xsr.value_segment_rule_appl_id,
9678: xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
9679: FROM xla_line_defn_jlt_assgns xjl
9680: ,xla_mpa_jlt_adr_assgns xad
9681: ,xla_seg_rule_details xsr
9682: WHERE xsr.application_id = xad.application_id
9683: AND xsr.amb_context_code = xad.amb_context_code
9684: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
9685: AND xsr.segment_rule_code = xad.segment_rule_code

Line 9719: FROM xla_seg_rule_details xsr

9715:
9716: CURSOR c_invalid_child_sources IS
9717: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9718: xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
9719: FROM xla_seg_rule_details xsr
9720: WHERE xsr.application_id = l_child_adr.value_segment_rule_appl_id
9721: AND xsr.amb_context_code = p_amb_context_code
9722: AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
9723: AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code

Line 9737: FROM xla_seg_rule_details xsr

9733: AND xes.active_flag = 'Y')
9734: UNION
9735: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9736: xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
9737: FROM xla_seg_rule_details xsr
9738: WHERE xsr.application_id = l_child_adr.value_segment_rule_appl_id
9739: AND xsr.amb_context_code = p_amb_context_code
9740: AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
9741: AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code

Line 9756: FROM xla_seg_rule_details xsr

9752:
9753: CURSOR c_child_der_sources IS
9754: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9755: xsr.value_source_type_code source_type_code, xsr.value_source_code source_code
9756: FROM xla_seg_rule_details xsr
9757: WHERE xsr.application_id = l_child_adr.value_segment_rule_appl_id
9758: AND xsr.amb_context_code = p_amb_context_code
9759: AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
9760: AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code

Line 9765: FROM xla_seg_rule_details xsr

9761: AND xsr.value_source_type_code = 'D'
9762: UNION
9763: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
9764: xsr.input_source_type_code source_type_code, xsr.input_source_code source_code
9765: FROM xla_seg_rule_details xsr
9766: WHERE xsr.application_id = l_child_adr.value_segment_rule_appl_id
9767: AND xsr.amb_context_code = p_amb_context_code
9768: AND xsr.segment_rule_type_code = l_child_adr.value_segment_rule_type_code
9769: AND xsr.segment_rule_code = l_child_adr.value_segment_rule_code

Line 9963: ,xla_seg_rule_details xsr

9959: xsr.value_segment_rule_appl_id,
9960: xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
9961: FROM xla_line_defn_jlt_assgns xjl
9962: ,xla_mpa_jlt_adr_assgns xad
9963: ,xla_seg_rule_details xsr
9964: WHERE xsr.application_id = xad.application_id
9965: AND xsr.amb_context_code = xad.amb_context_code
9966: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
9967: AND xsr.segment_rule_code = xad.segment_rule_code

Line 10000: FROM xla_seg_rule_details xsd

9996: l_child_adr c_child_adr%rowtype;
9997:
9998: CURSOR c_adr_loop IS
9999: SELECT 'x'
10000: FROM xla_seg_rule_details xsd
10001: WHERE application_id = l_child_adr.value_segment_rule_appl_id
10002: AND amb_context_code = p_amb_context_code
10003: AND segment_rule_type_code = l_child_adr.value_segment_rule_type_code
10004: AND segment_rule_code = l_child_adr.value_segment_rule_code

Line 10215: FROM xla_seg_rule_details xsr

10211: IS
10212: CURSOR c_invalid_ms IS
10213: SELECT distinct xsr.segment_rule_code, xsr.segment_rule_type_code,
10214: xsr.value_mapping_set_code
10215: FROM xla_seg_rule_details xsr
10216: ,xla_mpa_jlt_adr_assgns xad
10217: ,xla_line_defn_jlt_assgns xjl
10218: ,xla_mapping_sets_b xms
10219: WHERE xms.mapping_set_code = xsr.value_mapping_set_code

Line 12832: FROM xla_seg_rule_details

12828: IS
12829: SELECT value_segment_rule_appl_id
12830: ,value_segment_rule_type_code
12831: ,value_segment_rule_code
12832: FROM xla_seg_rule_details
12833: WHERE application_id = p_application_id
12834: AND amb_context_code = p_amb_context_code
12835: AND segment_rule_type_code = p_segment_rule_type_code
12836: AND segment_rule_code = p_segment_rule_code

Line 14047: ,xla_seg_rule_details xsr

14043: SELECT distinct xsr.value_segment_rule_appl_id,
14044: xsr.value_segment_rule_type_code, xsr.value_segment_rule_code
14045: FROM xla_line_defn_jlt_assgns xjl
14046: ,xla_line_defn_adr_assgns xad
14047: ,xla_seg_rule_details xsr
14048: WHERE xsr.application_id = xad.application_id
14049: AND xsr.amb_context_code = xad.amb_context_code
14050: AND xsr.segment_rule_type_code = xad.segment_rule_type_code
14051: AND xsr.segment_rule_code = xad.segment_rule_code

Line 14074: FROM xla_seg_rule_details xsd

14070: l_child_adr c_child_adr%rowtype;
14071:
14072: CURSOR c_adr_loop IS
14073: SELECT 'x'
14074: FROM xla_seg_rule_details xsd
14075: WHERE application_id = l_child_adr.value_segment_rule_appl_id
14076: AND amb_context_code = p_amb_context_code
14077: AND segment_rule_type_code = l_child_adr.value_segment_rule_type_code
14078: AND segment_rule_code = l_child_adr.value_segment_rule_code