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.MSD_SEED dependencies on MSD_HIERARCHY_LEVELS

Line 1081: insert into msd_hierarchy_levels (

1077:
1078: PROCEDURE insert_hierarchy_levels IS
1079: begin
1080:
1081: insert into msd_hierarchy_levels (
1082: HIERARCHY_ID,
1083: LEVEL_ID,
1084: PARENT_LEVEL_ID,
1085: RELATIONSHIP_VIEW,

Line 1107: from msd_hierarchy_levels

1103: 1
1104: FROM dual
1105: WHERE not exists (
1106: select 1
1107: from msd_hierarchy_levels
1108: where hierarchy_id = 1
1109: and level_id = 1
1110: and parent_level_id = 2);
1111:

Line 1113: insert into msd_hierarchy_levels (

1109: and level_id = 1
1110: and parent_level_id = 2);
1111:
1112:
1113: insert into msd_hierarchy_levels (
1114: HIERARCHY_ID,
1115: LEVEL_ID,
1116: PARENT_LEVEL_ID,
1117: RELATIONSHIP_VIEW,

Line 1139: from msd_hierarchy_levels

1135: 1
1136: FROM dual
1137: WHERE not exists (
1138: select 1
1139: from msd_hierarchy_levels
1140: where hierarchy_id = 1
1141: and level_id = 2
1142: and parent_level_id = 28);
1143:

Line 1145: insert into msd_hierarchy_levels (

1141: and level_id = 2
1142: and parent_level_id = 28);
1143:
1144:
1145: insert into msd_hierarchy_levels (
1146: HIERARCHY_ID,
1147: LEVEL_ID,
1148: PARENT_LEVEL_ID,
1149: RELATIONSHIP_VIEW,

Line 1171: from msd_hierarchy_levels

1167: 1
1168: FROM dual
1169: WHERE not exists (
1170: select 1
1171: from msd_hierarchy_levels
1172: where hierarchy_id = 2
1173: and level_id = 1
1174: and parent_level_id = 3);
1175:

Line 1177: insert into msd_hierarchy_levels (

1173: and level_id = 1
1174: and parent_level_id = 3);
1175:
1176:
1177: insert into msd_hierarchy_levels (
1178: HIERARCHY_ID,
1179: LEVEL_ID,
1180: PARENT_LEVEL_ID,
1181: RELATIONSHIP_VIEW,

Line 1203: from msd_hierarchy_levels

1199: 1
1200: FROM dual
1201: WHERE not exists (
1202: select 1
1203: from msd_hierarchy_levels
1204: where hierarchy_id = 2
1205: and level_id = 3
1206: and parent_level_id = 28);
1207:

Line 1209: insert into msd_hierarchy_levels (

1205: and level_id = 3
1206: and parent_level_id = 28);
1207:
1208:
1209: insert into msd_hierarchy_levels (
1210: HIERARCHY_ID,
1211: LEVEL_ID,
1212: PARENT_LEVEL_ID,
1213: RELATIONSHIP_VIEW,

Line 1235: from msd_hierarchy_levels

1231: 1
1232: FROM dual
1233: WHERE not exists (
1234: select 1
1235: from msd_hierarchy_levels
1236: where hierarchy_id = 4
1237: and level_id = 7
1238: and parent_level_id = 8);
1239:

Line 1241: insert into msd_hierarchy_levels (

1237: and level_id = 7
1238: and parent_level_id = 8);
1239:
1240:
1241: insert into msd_hierarchy_levels (
1242: HIERARCHY_ID,
1243: LEVEL_ID,
1244: PARENT_LEVEL_ID,
1245: RELATIONSHIP_VIEW,

Line 1267: from msd_hierarchy_levels

1263: 1
1264: FROM dual
1265: WHERE not exists (
1266: select 1
1267: from msd_hierarchy_levels
1268: where hierarchy_id = 4
1269: and level_id = 8
1270: and parent_level_id = 9);
1271:

Line 1273: insert into msd_hierarchy_levels (

1269: and level_id = 8
1270: and parent_level_id = 9);
1271:
1272:
1273: insert into msd_hierarchy_levels (
1274: HIERARCHY_ID,
1275: LEVEL_ID,
1276: PARENT_LEVEL_ID,
1277: RELATIONSHIP_VIEW,

Line 1299: from msd_hierarchy_levels

1295: 1
1296: FROM dual
1297: WHERE not exists (
1298: select 1
1299: from msd_hierarchy_levels
1300: where hierarchy_id = 4
1301: and level_id = 9
1302: and parent_level_id = 10);
1303:

Line 1305: insert into msd_hierarchy_levels (

1301: and level_id = 9
1302: and parent_level_id = 10);
1303:
1304:
1305: insert into msd_hierarchy_levels (
1306: HIERARCHY_ID,
1307: LEVEL_ID,
1308: PARENT_LEVEL_ID,
1309: RELATIONSHIP_VIEW,

Line 1331: from msd_hierarchy_levels

1327: 1
1328: FROM dual
1329: WHERE not exists (
1330: select 1
1331: from msd_hierarchy_levels
1332: where hierarchy_id = 4
1333: and level_id = 10
1334: and parent_level_id = 29);
1335:

Line 1337: insert into msd_hierarchy_levels (

1333: and level_id = 10
1334: and parent_level_id = 29);
1335:
1336:
1337: insert into msd_hierarchy_levels (
1338: HIERARCHY_ID,
1339: LEVEL_ID,
1340: PARENT_LEVEL_ID,
1341: RELATIONSHIP_VIEW,

Line 1363: from msd_hierarchy_levels

1359: 1
1360: FROM dual
1361: WHERE not exists (
1362: select 1
1363: from msd_hierarchy_levels
1364: where hierarchy_id = 5
1365: and level_id = 11
1366: and parent_level_id = 12);
1367:

Line 1369: insert into msd_hierarchy_levels (

1365: and level_id = 11
1366: and parent_level_id = 12);
1367:
1368:
1369: insert into msd_hierarchy_levels (
1370: HIERARCHY_ID,
1371: LEVEL_ID,
1372: PARENT_LEVEL_ID,
1373: RELATIONSHIP_VIEW,

Line 1395: from msd_hierarchy_levels

1391: 1
1392: FROM dual
1393: WHERE not exists (
1394: select 1
1395: from msd_hierarchy_levels
1396: where hierarchy_id = 5
1397: and level_id = 12
1398: and parent_level_id = 13);
1399:

Line 1401: insert into msd_hierarchy_levels (

1397: and level_id = 12
1398: and parent_level_id = 13);
1399:
1400:
1401: insert into msd_hierarchy_levels (
1402: HIERARCHY_ID,
1403: LEVEL_ID,
1404: PARENT_LEVEL_ID,
1405: RELATIONSHIP_VIEW,

Line 1427: from msd_hierarchy_levels

1423: 1
1424: FROM dual
1425: WHERE not exists (
1426: select 1
1427: from msd_hierarchy_levels
1428: where hierarchy_id = 5
1429: and level_id = 13
1430: and parent_level_id = 14);
1431:

Line 1433: insert into msd_hierarchy_levels (

1429: and level_id = 13
1430: and parent_level_id = 14);
1431:
1432:
1433: insert into msd_hierarchy_levels (
1434: HIERARCHY_ID,
1435: LEVEL_ID,
1436: PARENT_LEVEL_ID,
1437: RELATIONSHIP_VIEW,

Line 1459: from msd_hierarchy_levels

1455: 1
1456: FROM dual
1457: WHERE not exists (
1458: select 1
1459: from msd_hierarchy_levels
1460: where hierarchy_id = 5
1461: and level_id = 14
1462: and parent_level_id = 30);
1463:

Line 1465: insert into msd_hierarchy_levels (

1461: and level_id = 14
1462: and parent_level_id = 30);
1463:
1464:
1465: insert into msd_hierarchy_levels (
1466: HIERARCHY_ID,
1467: LEVEL_ID,
1468: PARENT_LEVEL_ID,
1469: RELATIONSHIP_VIEW,

Line 1491: from msd_hierarchy_levels

1487: 1
1488: FROM dual
1489: WHERE not exists (
1490: select 1
1491: from msd_hierarchy_levels
1492: where hierarchy_id = 6
1493: and level_id = 11
1494: and parent_level_id = 15);
1495:

Line 1497: insert into msd_hierarchy_levels (

1493: and level_id = 11
1494: and parent_level_id = 15);
1495:
1496:
1497: insert into msd_hierarchy_levels (
1498: HIERARCHY_ID,
1499: LEVEL_ID,
1500: PARENT_LEVEL_ID,
1501: RELATIONSHIP_VIEW,

Line 1523: from msd_hierarchy_levels

1519: 1
1520: FROM dual
1521: WHERE not exists (
1522: select 1
1523: from msd_hierarchy_levels
1524: where hierarchy_id = 6
1525: and level_id = 15
1526: and parent_level_id = 16);
1527:

Line 1529: insert into msd_hierarchy_levels (

1525: and level_id = 15
1526: and parent_level_id = 16);
1527:
1528:
1529: insert into msd_hierarchy_levels (
1530: HIERARCHY_ID,
1531: LEVEL_ID,
1532: PARENT_LEVEL_ID,
1533: RELATIONSHIP_VIEW,

Line 1555: from msd_hierarchy_levels

1551: 1
1552: FROM dual
1553: WHERE not exists (
1554: select 1
1555: from msd_hierarchy_levels
1556: where hierarchy_id = 6
1557: and level_id = 16
1558: and parent_level_id = 30);
1559:

Line 1565: UPDATE msd_hierarchy_levels

1561: /* zia 6/21/01:
1562: Bug fix for older seed data which had customer class views instead
1563: of customer group views
1564: */
1565: UPDATE msd_hierarchy_levels
1566: SET relationship_view = 'MSD_SR_CUS_CLASS_V'
1567: where hierarchy_id = 6
1568: and level_id = 15
1569: and parent_level_id = 16

Line 1572: UPDATE msd_hierarchy_levels

1568: and level_id = 15
1569: and parent_level_id = 16
1570: and relationship_view = 'MSD_SR_CUS_GROUP_V';
1571:
1572: UPDATE msd_hierarchy_levels
1573: SET relationship_view = 'MSD_SR_CLASS_ALL_V'
1574: where hierarchy_id = 6
1575: and level_id = 16
1576: and parent_level_id = 30

Line 1581: insert into msd_hierarchy_levels (

1577: and relationship_view = 'MSD_SR_GROUP_ALL_V';
1578: /* zia 6/21/01: end */
1579:
1580:
1581: insert into msd_hierarchy_levels (
1582: HIERARCHY_ID,
1583: LEVEL_ID,
1584: PARENT_LEVEL_ID,
1585: RELATIONSHIP_VIEW,

Line 1607: from msd_hierarchy_levels

1603: 1
1604: FROM dual
1605: WHERE not exists (
1606: select 1
1607: from msd_hierarchy_levels
1608: where hierarchy_id = 7
1609: and level_id = 11
1610: and parent_level_id = 15);
1611:

Line 1613: insert into msd_hierarchy_levels (

1609: and level_id = 11
1610: and parent_level_id = 15);
1611:
1612:
1613: insert into msd_hierarchy_levels (
1614: HIERARCHY_ID,
1615: LEVEL_ID,
1616: PARENT_LEVEL_ID,
1617: RELATIONSHIP_VIEW,

Line 1639: from msd_hierarchy_levels

1635: 1
1636: FROM dual
1637: WHERE not exists (
1638: select 1
1639: from msd_hierarchy_levels
1640: where hierarchy_id = 7
1641: and level_id = 15
1642: and parent_level_id = 17);
1643:

Line 1645: insert into msd_hierarchy_levels (

1641: and level_id = 15
1642: and parent_level_id = 17);
1643:
1644:
1645: insert into msd_hierarchy_levels (
1646: HIERARCHY_ID,
1647: LEVEL_ID,
1648: PARENT_LEVEL_ID,
1649: RELATIONSHIP_VIEW,

Line 1671: from msd_hierarchy_levels

1667: 1
1668: FROM dual
1669: WHERE not exists (
1670: select 1
1671: from msd_hierarchy_levels
1672: where hierarchy_id = 7
1673: and level_id = 17
1674: and parent_level_id = 30);
1675:

Line 1681: UPDATE msd_hierarchy_levels

1677: /* zia 6/21/01:
1678: Bug fix for older seed data which had customer class views instead
1679: of customer group views
1680: */
1681: UPDATE msd_hierarchy_levels
1682: SET relationship_view = 'MSD_SR_CUS_GROUP_V'
1683: where hierarchy_id = 7
1684: and level_id = 15
1685: and parent_level_id = 17

Line 1688: UPDATE msd_hierarchy_levels

1684: and level_id = 15
1685: and parent_level_id = 17
1686: and relationship_view = 'MSD_SR_CUS_CLASS_V';
1687:
1688: UPDATE msd_hierarchy_levels
1689: SET relationship_view = 'MSD_SR_GROUP_ALL_V'
1690: where hierarchy_id = 7
1691: and level_id = 17
1692: and parent_level_id = 30

Line 1697: insert into msd_hierarchy_levels (

1693: and relationship_view = 'MSD_SR_CLASS_ALL_V';
1694: /* zia 6/21/01: end */
1695:
1696:
1697: insert into msd_hierarchy_levels (
1698: HIERARCHY_ID,
1699: LEVEL_ID,
1700: PARENT_LEVEL_ID,
1701: RELATIONSHIP_VIEW,

Line 1723: from msd_hierarchy_levels

1719: 1
1720: FROM dual
1721: WHERE not exists (
1722: select 1
1723: from msd_hierarchy_levels
1724: where hierarchy_id = 8
1725: and level_id = 18
1726: and parent_level_id = 19);
1727:

Line 1729: insert into msd_hierarchy_levels (

1725: and level_id = 18
1726: and parent_level_id = 19);
1727:
1728:
1729: insert into msd_hierarchy_levels (
1730: HIERARCHY_ID,
1731: LEVEL_ID,
1732: PARENT_LEVEL_ID,
1733: RELATIONSHIP_VIEW,

Line 1755: from msd_hierarchy_levels

1751: 1
1752: FROM dual
1753: WHERE not exists (
1754: select 1
1755: from msd_hierarchy_levels
1756: where hierarchy_id = 8
1757: and level_id = 19
1758: and parent_level_id = 20);
1759:

Line 1761: insert into msd_hierarchy_levels (

1757: and level_id = 19
1758: and parent_level_id = 20);
1759:
1760:
1761: insert into msd_hierarchy_levels (
1762: HIERARCHY_ID,
1763: LEVEL_ID,
1764: PARENT_LEVEL_ID,
1765: RELATIONSHIP_VIEW,

Line 1787: from msd_hierarchy_levels

1783: 1
1784: FROM dual
1785: WHERE not exists (
1786: select 1
1787: from msd_hierarchy_levels
1788: where hierarchy_id = 8
1789: and level_id = 20
1790: and parent_level_id = 21);
1791:

Line 1793: insert into msd_hierarchy_levels (

1789: and level_id = 20
1790: and parent_level_id = 21);
1791:
1792:
1793: insert into msd_hierarchy_levels (
1794: HIERARCHY_ID,
1795: LEVEL_ID,
1796: PARENT_LEVEL_ID,
1797: RELATIONSHIP_VIEW,

Line 1819: from msd_hierarchy_levels

1815: 1
1816: FROM dual
1817: WHERE not exists (
1818: select 1
1819: from msd_hierarchy_levels
1820: where hierarchy_id = 8
1821: and level_id = 21
1822: and parent_level_id = 22);
1823:

Line 1825: insert into msd_hierarchy_levels (

1821: and level_id = 21
1822: and parent_level_id = 22);
1823:
1824:
1825: insert into msd_hierarchy_levels (
1826: HIERARCHY_ID,
1827: LEVEL_ID,
1828: PARENT_LEVEL_ID,
1829: RELATIONSHIP_VIEW,

Line 1851: from msd_hierarchy_levels

1847: 1
1848: FROM dual
1849: WHERE not exists (
1850: select 1
1851: from msd_hierarchy_levels
1852: where hierarchy_id = 8
1853: and level_id = 22
1854: and parent_level_id = 32);
1855:

Line 1857: insert into msd_hierarchy_levels (

1853: and level_id = 22
1854: and parent_level_id = 32);
1855:
1856:
1857: insert into msd_hierarchy_levels (
1858: HIERARCHY_ID,
1859: LEVEL_ID,
1860: PARENT_LEVEL_ID,
1861: RELATIONSHIP_VIEW,

Line 1883: from msd_hierarchy_levels

1879: 1
1880: FROM dual
1881: WHERE not exists (
1882: select 1
1883: from msd_hierarchy_levels
1884: where hierarchy_id = 9
1885: and level_id = 18
1886: and parent_level_id = 23);
1887:

Line 1889: insert into msd_hierarchy_levels (

1885: and level_id = 18
1886: and parent_level_id = 23);
1887:
1888:
1889: insert into msd_hierarchy_levels (
1890: HIERARCHY_ID,
1891: LEVEL_ID,
1892: PARENT_LEVEL_ID,
1893: RELATIONSHIP_VIEW,

Line 1915: from msd_hierarchy_levels

1911: 1
1912: FROM dual
1913: WHERE not exists (
1914: select 1
1915: from msd_hierarchy_levels
1916: where hierarchy_id = 9
1917: and level_id = 23
1918: and parent_level_id = 24);
1919:

Line 1921: insert into msd_hierarchy_levels (

1917: and level_id = 23
1918: and parent_level_id = 24);
1919:
1920:
1921: insert into msd_hierarchy_levels (
1922: HIERARCHY_ID,
1923: LEVEL_ID,
1924: PARENT_LEVEL_ID,
1925: RELATIONSHIP_VIEW,

Line 1947: from msd_hierarchy_levels

1943: 1
1944: FROM dual
1945: WHERE not exists (
1946: select 1
1947: from msd_hierarchy_levels
1948: where hierarchy_id = 9
1949: and level_id = 24
1950: and parent_level_id = 25);
1951:

Line 1953: insert into msd_hierarchy_levels (

1949: and level_id = 24
1950: and parent_level_id = 25);
1951:
1952:
1953: insert into msd_hierarchy_levels (
1954: HIERARCHY_ID,
1955: LEVEL_ID,
1956: PARENT_LEVEL_ID,
1957: RELATIONSHIP_VIEW,

Line 1979: from msd_hierarchy_levels

1975: 1
1976: FROM dual
1977: WHERE not exists (
1978: select 1
1979: from msd_hierarchy_levels
1980: where hierarchy_id = 9
1981: and level_id = 25
1982: and parent_level_id = 26);
1983:

Line 1985: insert into msd_hierarchy_levels (

1981: and level_id = 25
1982: and parent_level_id = 26);
1983:
1984:
1985: insert into msd_hierarchy_levels (
1986: HIERARCHY_ID,
1987: LEVEL_ID,
1988: PARENT_LEVEL_ID,
1989: RELATIONSHIP_VIEW,

Line 2011: from msd_hierarchy_levels

2007: 1
2008: FROM dual
2009: WHERE not exists (
2010: select 1
2011: from msd_hierarchy_levels
2012: where hierarchy_id = 9
2013: and level_id = 26
2014: and parent_level_id = 32);
2015:

Line 2017: insert into msd_hierarchy_levels (

2013: and level_id = 26
2014: and parent_level_id = 32);
2015:
2016:
2017: insert into msd_hierarchy_levels (
2018: HIERARCHY_ID,
2019: LEVEL_ID,
2020: PARENT_LEVEL_ID,
2021: RELATIONSHIP_VIEW,

Line 2043: from msd_hierarchy_levels

2039: 1
2040: FROM dual
2041: WHERE not exists (
2042: select 1
2043: from msd_hierarchy_levels
2044: where hierarchy_id = 10
2045: and level_id = 27
2046: and parent_level_id = 33);
2047: