[Home] [Help]
11:
12: merge INTO MTH_DIM_HIERARCHY t
13: USING
14: (
15: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Resource Group Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_RG' HIER_INTERNAL_NAME, 3 NUMBER_OF_LEVEL FROM DUAL UNION ALL
16: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Department Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_DEPT' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
17: SELECT -1 DIMENSION_ID, -3 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Equipment Hierarchy 01' HIERARCHY_NAME, 'MTH_EQUIP_HIER1' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
18: SELECT -1 DIMENSION_ID, -4 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Equipment Hierarchy 02' HIERARCHY_NAME, 'MTH_EQUIP_HIER2' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
19: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Facility Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_FACILITY' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
12: merge INTO MTH_DIM_HIERARCHY t
13: USING
14: (
15: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Resource Group Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_RG' HIER_INTERNAL_NAME, 3 NUMBER_OF_LEVEL FROM DUAL UNION ALL
16: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Department Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_DEPT' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
17: SELECT -1 DIMENSION_ID, -3 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Equipment Hierarchy 01' HIERARCHY_NAME, 'MTH_EQUIP_HIER1' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
18: SELECT -1 DIMENSION_ID, -4 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Equipment Hierarchy 02' HIERARCHY_NAME, 'MTH_EQUIP_HIER2' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
19: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Facility Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_FACILITY' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
20: SELECT -2 DIMENSION_ID, -5 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 01' HIERARCHY_NAME, 'MTH_ITEM_HIER1' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
13: USING
14: (
15: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Resource Group Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_RG' HIER_INTERNAL_NAME, 3 NUMBER_OF_LEVEL FROM DUAL UNION ALL
16: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Department Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_DEPT' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
17: SELECT -1 DIMENSION_ID, -3 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Equipment Hierarchy 01' HIERARCHY_NAME, 'MTH_EQUIP_HIER1' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
18: SELECT -1 DIMENSION_ID, -4 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Equipment Hierarchy 02' HIERARCHY_NAME, 'MTH_EQUIP_HIER2' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
19: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Facility Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_FACILITY' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
20: SELECT -2 DIMENSION_ID, -5 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 01' HIERARCHY_NAME, 'MTH_ITEM_HIER1' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
21: SELECT -2 DIMENSION_ID, -6 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 02' HIERARCHY_NAME, 'MTH_ITEM_HIER2' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
14: (
15: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Resource Group Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_RG' HIER_INTERNAL_NAME, 3 NUMBER_OF_LEVEL FROM DUAL UNION ALL
16: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Department Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_DEPT' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
17: SELECT -1 DIMENSION_ID, -3 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Equipment Hierarchy 01' HIERARCHY_NAME, 'MTH_EQUIP_HIER1' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
18: SELECT -1 DIMENSION_ID, -4 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Equipment Hierarchy 02' HIERARCHY_NAME, 'MTH_EQUIP_HIER2' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
19: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Facility Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_FACILITY' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
20: SELECT -2 DIMENSION_ID, -5 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 01' HIERARCHY_NAME, 'MTH_ITEM_HIER1' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
21: SELECT -2 DIMENSION_ID, -6 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 02' HIERARCHY_NAME, 'MTH_ITEM_HIER2' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
22: SELECT -2 DIMENSION_ID, -7 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 03' HIERARCHY_NAME, 'MTH_ITEM_HIER3' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
15: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Resource Group Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_RG' HIER_INTERNAL_NAME, 3 NUMBER_OF_LEVEL FROM DUAL UNION ALL
16: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Department Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_DEPT' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
17: SELECT -1 DIMENSION_ID, -3 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Equipment Hierarchy 01' HIERARCHY_NAME, 'MTH_EQUIP_HIER1' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
18: SELECT -1 DIMENSION_ID, -4 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Equipment Hierarchy 02' HIERARCHY_NAME, 'MTH_EQUIP_HIER2' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
19: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Facility Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_FACILITY' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
20: SELECT -2 DIMENSION_ID, -5 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 01' HIERARCHY_NAME, 'MTH_ITEM_HIER1' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
21: SELECT -2 DIMENSION_ID, -6 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 02' HIERARCHY_NAME, 'MTH_ITEM_HIER2' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
22: SELECT -2 DIMENSION_ID, -7 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 03' HIERARCHY_NAME, 'MTH_ITEM_HIER3' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
23: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Gregorian Calendar' HIERARCHY_NAME, 'MTH_GREGORIAN CALENDAR' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
16: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Department Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_DEPT' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
17: SELECT -1 DIMENSION_ID, -3 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Equipment Hierarchy 01' HIERARCHY_NAME, 'MTH_EQUIP_HIER1' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
18: SELECT -1 DIMENSION_ID, -4 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Equipment Hierarchy 02' HIERARCHY_NAME, 'MTH_EQUIP_HIER2' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
19: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Facility Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_FACILITY' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
20: SELECT -2 DIMENSION_ID, -5 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 01' HIERARCHY_NAME, 'MTH_ITEM_HIER1' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
21: SELECT -2 DIMENSION_ID, -6 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 02' HIERARCHY_NAME, 'MTH_ITEM_HIER2' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
22: SELECT -2 DIMENSION_ID, -7 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 03' HIERARCHY_NAME, 'MTH_ITEM_HIER3' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
23: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Gregorian Calendar' HIERARCHY_NAME, 'MTH_GREGORIAN CALENDAR' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
24: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Fiscal Calendar' HIERARCHY_NAME, 'MTH_FISCAL_CALENDAR' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
17: SELECT -1 DIMENSION_ID, -3 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Equipment Hierarchy 01' HIERARCHY_NAME, 'MTH_EQUIP_HIER1' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
18: SELECT -1 DIMENSION_ID, -4 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Equipment Hierarchy 02' HIERARCHY_NAME, 'MTH_EQUIP_HIER2' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
19: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Facility Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_FACILITY' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
20: SELECT -2 DIMENSION_ID, -5 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 01' HIERARCHY_NAME, 'MTH_ITEM_HIER1' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
21: SELECT -2 DIMENSION_ID, -6 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 02' HIERARCHY_NAME, 'MTH_ITEM_HIER2' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
22: SELECT -2 DIMENSION_ID, -7 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 03' HIERARCHY_NAME, 'MTH_ITEM_HIER3' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
23: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Gregorian Calendar' HIERARCHY_NAME, 'MTH_GREGORIAN CALENDAR' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
24: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Fiscal Calendar' HIERARCHY_NAME, 'MTH_FISCAL_CALENDAR' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
25: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'MTH 445 Period Calendar' HIERARCHY_NAME, 'MTH_445_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
18: SELECT -1 DIMENSION_ID, -4 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Equipment Hierarchy 02' HIERARCHY_NAME, 'MTH_EQUIP_HIER2' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
19: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Facility Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_FACILITY' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
20: SELECT -2 DIMENSION_ID, -5 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 01' HIERARCHY_NAME, 'MTH_ITEM_HIER1' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
21: SELECT -2 DIMENSION_ID, -6 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 02' HIERARCHY_NAME, 'MTH_ITEM_HIER2' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
22: SELECT -2 DIMENSION_ID, -7 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 03' HIERARCHY_NAME, 'MTH_ITEM_HIER3' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
23: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Gregorian Calendar' HIERARCHY_NAME, 'MTH_GREGORIAN CALENDAR' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
24: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Fiscal Calendar' HIERARCHY_NAME, 'MTH_FISCAL_CALENDAR' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
25: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'MTH 445 Period Calendar' HIERARCHY_NAME, 'MTH_445_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
26: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'MTH 544 Period Calendar' HIERARCHY_NAME, 'MTH_544_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
19: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 'EQUIPMENT' DIMENSION_NAME, 'Facility Hierarchy' HIERARCHY_NAME, 'MTH_EQUIP_FACILITY' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
20: SELECT -2 DIMENSION_ID, -5 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 01' HIERARCHY_NAME, 'MTH_ITEM_HIER1' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
21: SELECT -2 DIMENSION_ID, -6 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 02' HIERARCHY_NAME, 'MTH_ITEM_HIER2' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
22: SELECT -2 DIMENSION_ID, -7 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 03' HIERARCHY_NAME, 'MTH_ITEM_HIER3' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
23: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Gregorian Calendar' HIERARCHY_NAME, 'MTH_GREGORIAN CALENDAR' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
24: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Fiscal Calendar' HIERARCHY_NAME, 'MTH_FISCAL_CALENDAR' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
25: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'MTH 445 Period Calendar' HIERARCHY_NAME, 'MTH_445_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
26: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'MTH 544 Period Calendar' HIERARCHY_NAME, 'MTH_544_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
27: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 'TIME' DIMENSION_NAME, '13 Period Calendar' HIERARCHY_NAME, 'MTH_13_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
20: SELECT -2 DIMENSION_ID, -5 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 01' HIERARCHY_NAME, 'MTH_ITEM_HIER1' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
21: SELECT -2 DIMENSION_ID, -6 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 02' HIERARCHY_NAME, 'MTH_ITEM_HIER2' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
22: SELECT -2 DIMENSION_ID, -7 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 03' HIERARCHY_NAME, 'MTH_ITEM_HIER3' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
23: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Gregorian Calendar' HIERARCHY_NAME, 'MTH_GREGORIAN CALENDAR' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
24: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Fiscal Calendar' HIERARCHY_NAME, 'MTH_FISCAL_CALENDAR' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
25: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'MTH 445 Period Calendar' HIERARCHY_NAME, 'MTH_445_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
26: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'MTH 544 Period Calendar' HIERARCHY_NAME, 'MTH_544_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
27: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 'TIME' DIMENSION_NAME, '13 Period Calendar' HIERARCHY_NAME, 'MTH_13_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
28: SELECT -3 DIMENSION_ID, -13 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Custom Calendar' HIERARCHY_NAME, 'MTH_CUSTOM_CALENDAR' HIER_INTERNAL_NAME, NULL FROM DUAL
21: SELECT -2 DIMENSION_ID, -6 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 02' HIERARCHY_NAME, 'MTH_ITEM_HIER2' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
22: SELECT -2 DIMENSION_ID, -7 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 03' HIERARCHY_NAME, 'MTH_ITEM_HIER3' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
23: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Gregorian Calendar' HIERARCHY_NAME, 'MTH_GREGORIAN CALENDAR' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
24: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Fiscal Calendar' HIERARCHY_NAME, 'MTH_FISCAL_CALENDAR' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
25: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'MTH 445 Period Calendar' HIERARCHY_NAME, 'MTH_445_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
26: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'MTH 544 Period Calendar' HIERARCHY_NAME, 'MTH_544_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
27: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 'TIME' DIMENSION_NAME, '13 Period Calendar' HIERARCHY_NAME, 'MTH_13_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
28: SELECT -3 DIMENSION_ID, -13 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Custom Calendar' HIERARCHY_NAME, 'MTH_CUSTOM_CALENDAR' HIER_INTERNAL_NAME, NULL FROM DUAL
29: ) s
22: SELECT -2 DIMENSION_ID, -7 HIERARCHY_ID, 'ITEM' DIMENSION_NAME, 'Item Hierarchy 03' HIERARCHY_NAME, 'MTH_ITEM_HIER3' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
23: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Gregorian Calendar' HIERARCHY_NAME, 'MTH_GREGORIAN CALENDAR' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
24: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Fiscal Calendar' HIERARCHY_NAME, 'MTH_FISCAL_CALENDAR' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
25: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'MTH 445 Period Calendar' HIERARCHY_NAME, 'MTH_445_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
26: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'MTH 544 Period Calendar' HIERARCHY_NAME, 'MTH_544_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
27: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 'TIME' DIMENSION_NAME, '13 Period Calendar' HIERARCHY_NAME, 'MTH_13_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
28: SELECT -3 DIMENSION_ID, -13 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Custom Calendar' HIERARCHY_NAME, 'MTH_CUSTOM_CALENDAR' HIER_INTERNAL_NAME, NULL FROM DUAL
29: ) s
30: ON (s.DIMENSION_NAME = t.DIMENSION_NAME AND s.HIERARCHY_NAME=t.HIERARCHY_NAME)
23: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Gregorian Calendar' HIERARCHY_NAME, 'MTH_GREGORIAN CALENDAR' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
24: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Fiscal Calendar' HIERARCHY_NAME, 'MTH_FISCAL_CALENDAR' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
25: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'MTH 445 Period Calendar' HIERARCHY_NAME, 'MTH_445_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
26: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'MTH 544 Period Calendar' HIERARCHY_NAME, 'MTH_544_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
27: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 'TIME' DIMENSION_NAME, '13 Period Calendar' HIERARCHY_NAME, 'MTH_13_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
28: SELECT -3 DIMENSION_ID, -13 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Custom Calendar' HIERARCHY_NAME, 'MTH_CUSTOM_CALENDAR' HIER_INTERNAL_NAME, NULL FROM DUAL
29: ) s
30: ON (s.DIMENSION_NAME = t.DIMENSION_NAME AND s.HIERARCHY_NAME=t.HIERARCHY_NAME)
31: WHEN matched THEN
24: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Fiscal Calendar' HIERARCHY_NAME, 'MTH_FISCAL_CALENDAR' HIER_INTERNAL_NAME, NULL NUMBER_OF_LEVEL FROM DUAL UNION ALL
25: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'MTH 445 Period Calendar' HIERARCHY_NAME, 'MTH_445_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
26: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'MTH 544 Period Calendar' HIERARCHY_NAME, 'MTH_544_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 5 NUMBER_OF_LEVEL FROM DUAL UNION ALL
27: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 'TIME' DIMENSION_NAME, '13 Period Calendar' HIERARCHY_NAME, 'MTH_13_PERIOD_CALENDAR' HIER_INTERNAL_NAME, 4 NUMBER_OF_LEVEL FROM DUAL UNION ALL
28: SELECT -3 DIMENSION_ID, -13 HIERARCHY_ID, 'TIME' DIMENSION_NAME, 'Custom Calendar' HIERARCHY_NAME, 'MTH_CUSTOM_CALENDAR' HIER_INTERNAL_NAME, NULL FROM DUAL
29: ) s
30: ON (s.DIMENSION_NAME = t.DIMENSION_NAME AND s.HIERARCHY_NAME=t.HIERARCHY_NAME)
31: WHEN matched THEN
32: UPDATE SET
64: merge INTO MTH_DIM_LEVEL_LOOKUP t
65: USING
66: (
67:
68: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 8 LEVEL_NUM, 'RESOURCE GROUP' LEVEL_TYPE, 'RESOURCE GROUP' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
69: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
70: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 9 LEVEL_NUM, 'RESOURCE' LEVEL_TYPE, 'RESOURCE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
71: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
72: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 7 LEVEL_NUM, 'SITE' LEVEL_TYPE, 'SITE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
65: USING
66: (
67:
68: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 8 LEVEL_NUM, 'RESOURCE GROUP' LEVEL_TYPE, 'RESOURCE GROUP' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
69: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
70: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 9 LEVEL_NUM, 'RESOURCE' LEVEL_TYPE, 'RESOURCE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
71: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
72: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 7 LEVEL_NUM, 'SITE' LEVEL_TYPE, 'SITE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
73: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 9 LEVEL_NUM, 'RESOURCE' LEVEL_TYPE, 'RESOURCE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
66: (
67:
68: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 8 LEVEL_NUM, 'RESOURCE GROUP' LEVEL_TYPE, 'RESOURCE GROUP' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
69: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
70: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 9 LEVEL_NUM, 'RESOURCE' LEVEL_TYPE, 'RESOURCE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
71: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
72: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 7 LEVEL_NUM, 'SITE' LEVEL_TYPE, 'SITE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
73: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 9 LEVEL_NUM, 'RESOURCE' LEVEL_TYPE, 'RESOURCE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
74: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 8 LEVEL_NUM, 'DEPARTMENT' LEVEL_TYPE, 'DEPARTMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
67:
68: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 8 LEVEL_NUM, 'RESOURCE GROUP' LEVEL_TYPE, 'RESOURCE GROUP' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
69: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
70: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 9 LEVEL_NUM, 'RESOURCE' LEVEL_TYPE, 'RESOURCE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
71: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
72: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 7 LEVEL_NUM, 'SITE' LEVEL_TYPE, 'SITE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
73: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 9 LEVEL_NUM, 'RESOURCE' LEVEL_TYPE, 'RESOURCE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
74: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 8 LEVEL_NUM, 'DEPARTMENT' LEVEL_TYPE, 'DEPARTMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
75: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
68: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 8 LEVEL_NUM, 'RESOURCE GROUP' LEVEL_TYPE, 'RESOURCE GROUP' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
69: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
70: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 9 LEVEL_NUM, 'RESOURCE' LEVEL_TYPE, 'RESOURCE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
71: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
72: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 7 LEVEL_NUM, 'SITE' LEVEL_TYPE, 'SITE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
73: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 9 LEVEL_NUM, 'RESOURCE' LEVEL_TYPE, 'RESOURCE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
74: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 8 LEVEL_NUM, 'DEPARTMENT' LEVEL_TYPE, 'DEPARTMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
75: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
76: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 8 LEVEL_NUM, 'FLR' LEVEL_TYPE, 'FLR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
69: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
70: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 9 LEVEL_NUM, 'RESOURCE' LEVEL_TYPE, 'RESOURCE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
71: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
72: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 7 LEVEL_NUM, 'SITE' LEVEL_TYPE, 'SITE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
73: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 9 LEVEL_NUM, 'RESOURCE' LEVEL_TYPE, 'RESOURCE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
74: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 8 LEVEL_NUM, 'DEPARTMENT' LEVEL_TYPE, 'DEPARTMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
75: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
76: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 8 LEVEL_NUM, 'FLR' LEVEL_TYPE, 'FLR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
77: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 6 LEVEL_NUM, 'SITE' LEVEL_TYPE, 'SITE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
70: SELECT -1 DIMENSION_ID, -1 HIERARCHY_ID, 9 LEVEL_NUM, 'RESOURCE' LEVEL_TYPE, 'RESOURCE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
71: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
72: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 7 LEVEL_NUM, 'SITE' LEVEL_TYPE, 'SITE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
73: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 9 LEVEL_NUM, 'RESOURCE' LEVEL_TYPE, 'RESOURCE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
74: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 8 LEVEL_NUM, 'DEPARTMENT' LEVEL_TYPE, 'DEPARTMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
75: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
76: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 8 LEVEL_NUM, 'FLR' LEVEL_TYPE, 'FLR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
77: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 6 LEVEL_NUM, 'SITE' LEVEL_TYPE, 'SITE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
78: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 7 LEVEL_NUM, 'BLD' LEVEL_TYPE, 'BLD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
71: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
72: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 7 LEVEL_NUM, 'SITE' LEVEL_TYPE, 'SITE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
73: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 9 LEVEL_NUM, 'RESOURCE' LEVEL_TYPE, 'RESOURCE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
74: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 8 LEVEL_NUM, 'DEPARTMENT' LEVEL_TYPE, 'DEPARTMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
75: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
76: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 8 LEVEL_NUM, 'FLR' LEVEL_TYPE, 'FLR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
77: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 6 LEVEL_NUM, 'SITE' LEVEL_TYPE, 'SITE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
78: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 7 LEVEL_NUM, 'BLD' LEVEL_TYPE, 'BLD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
79: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 9 LEVEL_NUM, 'FS' LEVEL_TYPE, 'FS' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
72: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 7 LEVEL_NUM, 'SITE' LEVEL_TYPE, 'SITE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
73: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 9 LEVEL_NUM, 'RESOURCE' LEVEL_TYPE, 'RESOURCE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
74: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 8 LEVEL_NUM, 'DEPARTMENT' LEVEL_TYPE, 'DEPARTMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
75: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
76: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 8 LEVEL_NUM, 'FLR' LEVEL_TYPE, 'FLR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
77: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 6 LEVEL_NUM, 'SITE' LEVEL_TYPE, 'SITE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
78: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 7 LEVEL_NUM, 'BLD' LEVEL_TYPE, 'BLD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
79: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 9 LEVEL_NUM, 'FS' LEVEL_TYPE, 'FS' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
80: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
73: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 9 LEVEL_NUM, 'RESOURCE' LEVEL_TYPE, 'RESOURCE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
74: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 8 LEVEL_NUM, 'DEPARTMENT' LEVEL_TYPE, 'DEPARTMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
75: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
76: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 8 LEVEL_NUM, 'FLR' LEVEL_TYPE, 'FLR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
77: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 6 LEVEL_NUM, 'SITE' LEVEL_TYPE, 'SITE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
78: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 7 LEVEL_NUM, 'BLD' LEVEL_TYPE, 'BLD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
79: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 9 LEVEL_NUM, 'FS' LEVEL_TYPE, 'FS' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
80: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
81: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 3 LEVEL_NUM, 'MONTH' LEVEL_TYPE, 'MONTH' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
74: SELECT -1 DIMENSION_ID, -2 HIERARCHY_ID, 8 LEVEL_NUM, 'DEPARTMENT' LEVEL_TYPE, 'DEPARTMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
75: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
76: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 8 LEVEL_NUM, 'FLR' LEVEL_TYPE, 'FLR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
77: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 6 LEVEL_NUM, 'SITE' LEVEL_TYPE, 'SITE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
78: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 7 LEVEL_NUM, 'BLD' LEVEL_TYPE, 'BLD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
79: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 9 LEVEL_NUM, 'FS' LEVEL_TYPE, 'FS' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
80: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
81: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 3 LEVEL_NUM, 'MONTH' LEVEL_TYPE, 'MONTH' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
82: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
75: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 10 LEVEL_NUM, 'EQUIPMENT' LEVEL_TYPE, 'EQUIPMENT' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
76: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 8 LEVEL_NUM, 'FLR' LEVEL_TYPE, 'FLR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
77: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 6 LEVEL_NUM, 'SITE' LEVEL_TYPE, 'SITE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
78: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 7 LEVEL_NUM, 'BLD' LEVEL_TYPE, 'BLD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
79: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 9 LEVEL_NUM, 'FS' LEVEL_TYPE, 'FS' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
80: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
81: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 3 LEVEL_NUM, 'MONTH' LEVEL_TYPE, 'MONTH' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
82: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
83: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
76: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 8 LEVEL_NUM, 'FLR' LEVEL_TYPE, 'FLR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
77: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 6 LEVEL_NUM, 'SITE' LEVEL_TYPE, 'SITE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
78: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 7 LEVEL_NUM, 'BLD' LEVEL_TYPE, 'BLD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
79: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 9 LEVEL_NUM, 'FS' LEVEL_TYPE, 'FS' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
80: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
81: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 3 LEVEL_NUM, 'MONTH' LEVEL_TYPE, 'MONTH' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
82: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
83: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
84: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 1 LEVEL_NUM, 'FISCAL YEAR' LEVEL_TYPE, 'FISCAL YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
77: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 6 LEVEL_NUM, 'SITE' LEVEL_TYPE, 'SITE' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
78: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 7 LEVEL_NUM, 'BLD' LEVEL_TYPE, 'BLD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
79: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 9 LEVEL_NUM, 'FS' LEVEL_TYPE, 'FS' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
80: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
81: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 3 LEVEL_NUM, 'MONTH' LEVEL_TYPE, 'MONTH' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
82: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
83: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
84: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 1 LEVEL_NUM, 'FISCAL YEAR' LEVEL_TYPE, 'FISCAL YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
85: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 3 LEVEL_NUM, 'MONTH' LEVEL_TYPE, 'MONTH' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
78: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 7 LEVEL_NUM, 'BLD' LEVEL_TYPE, 'BLD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
79: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 9 LEVEL_NUM, 'FS' LEVEL_TYPE, 'FS' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
80: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
81: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 3 LEVEL_NUM, 'MONTH' LEVEL_TYPE, 'MONTH' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
82: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
83: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
84: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 1 LEVEL_NUM, 'FISCAL YEAR' LEVEL_TYPE, 'FISCAL YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
85: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 3 LEVEL_NUM, 'MONTH' LEVEL_TYPE, 'MONTH' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
86: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
79: SELECT -1 DIMENSION_ID, -14 HIERARCHY_ID, 9 LEVEL_NUM, 'FS' LEVEL_TYPE, 'FS' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
80: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
81: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 3 LEVEL_NUM, 'MONTH' LEVEL_TYPE, 'MONTH' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
82: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
83: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
84: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 1 LEVEL_NUM, 'FISCAL YEAR' LEVEL_TYPE, 'FISCAL YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
85: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 3 LEVEL_NUM, 'MONTH' LEVEL_TYPE, 'MONTH' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
86: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
87: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 2 LEVEL_NUM, 'FISCAL QUARTER' LEVEL_TYPE, 'FISCAL QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
80: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
81: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 3 LEVEL_NUM, 'MONTH' LEVEL_TYPE, 'MONTH' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
82: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
83: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
84: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 1 LEVEL_NUM, 'FISCAL YEAR' LEVEL_TYPE, 'FISCAL YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
85: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 3 LEVEL_NUM, 'MONTH' LEVEL_TYPE, 'MONTH' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
86: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
87: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 2 LEVEL_NUM, 'FISCAL QUARTER' LEVEL_TYPE, 'FISCAL QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
88: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
81: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 3 LEVEL_NUM, 'MONTH' LEVEL_TYPE, 'MONTH' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
82: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
83: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
84: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 1 LEVEL_NUM, 'FISCAL YEAR' LEVEL_TYPE, 'FISCAL YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
85: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 3 LEVEL_NUM, 'MONTH' LEVEL_TYPE, 'MONTH' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
86: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
87: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 2 LEVEL_NUM, 'FISCAL QUARTER' LEVEL_TYPE, 'FISCAL QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
88: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
89: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
82: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
83: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
84: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 1 LEVEL_NUM, 'FISCAL YEAR' LEVEL_TYPE, 'FISCAL YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
85: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 3 LEVEL_NUM, 'MONTH' LEVEL_TYPE, 'MONTH' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
86: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
87: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 2 LEVEL_NUM, 'FISCAL QUARTER' LEVEL_TYPE, 'FISCAL QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
88: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
89: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
90: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
83: SELECT -3 DIMENSION_ID, -8 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
84: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 1 LEVEL_NUM, 'FISCAL YEAR' LEVEL_TYPE, 'FISCAL YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
85: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 3 LEVEL_NUM, 'MONTH' LEVEL_TYPE, 'MONTH' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
86: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
87: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 2 LEVEL_NUM, 'FISCAL QUARTER' LEVEL_TYPE, 'FISCAL QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
88: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
89: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
90: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
91: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
84: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 1 LEVEL_NUM, 'FISCAL YEAR' LEVEL_TYPE, 'FISCAL YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
85: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 3 LEVEL_NUM, 'MONTH' LEVEL_TYPE, 'MONTH' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
86: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
87: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 2 LEVEL_NUM, 'FISCAL QUARTER' LEVEL_TYPE, 'FISCAL QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
88: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
89: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
90: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
91: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
92: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
85: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 3 LEVEL_NUM, 'MONTH' LEVEL_TYPE, 'MONTH' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
86: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
87: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 2 LEVEL_NUM, 'FISCAL QUARTER' LEVEL_TYPE, 'FISCAL QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
88: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
89: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
90: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
91: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
92: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
93: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
86: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
87: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 2 LEVEL_NUM, 'FISCAL QUARTER' LEVEL_TYPE, 'FISCAL QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
88: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
89: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
90: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
91: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
92: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
93: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
94: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
87: SELECT -3 DIMENSION_ID, -9 HIERARCHY_ID, 2 LEVEL_NUM, 'FISCAL QUARTER' LEVEL_TYPE, 'FISCAL QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
88: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
89: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
90: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
91: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
92: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
93: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
94: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
95: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
88: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
89: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
90: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
91: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
92: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
93: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
94: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
95: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
96: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
89: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
90: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
91: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
92: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
93: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
94: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
95: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
96: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
97: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
90: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
91: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
92: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
93: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
94: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
95: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
96: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
97: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
98: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
91: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
92: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
93: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
94: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
95: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
96: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
97: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
98: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
99: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
92: SELECT -3 DIMENSION_ID, -10 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
93: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
94: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
95: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
96: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
97: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
98: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
99: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
100: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
93: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
94: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
95: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
96: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
97: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
98: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
99: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
100: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
101: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL
94: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
95: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
96: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
97: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
98: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
99: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
100: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
101: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL
102:
95: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 2 LEVEL_NUM, 'QUARTER' LEVEL_TYPE, 'QUARTER' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
96: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
97: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
98: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
99: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
100: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
101: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL
102:
103: ) s
96: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
97: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
98: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
99: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
100: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
101: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL
102:
103: ) s
104:
97: SELECT -3 DIMENSION_ID, -11 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
98: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 4 LEVEL_NUM, 'WEEK' LEVEL_TYPE, 'WEEK' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
99: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 5 LEVEL_NUM, 'DAY' LEVEL_TYPE, 'DAY' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
100: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 3 LEVEL_NUM, 'PERIOD' LEVEL_TYPE, 'PERIOD' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL UNION ALL
101: SELECT -3 DIMENSION_ID, -12 HIERARCHY_ID, 1 LEVEL_NUM, 'YEAR' LEVEL_TYPE, 'YEAR' LEVEL_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() CREATION_SYSTEM_ID FROM DUAL
102:
103: ) s
104:
105: ON (
144: merge INTO MTH_ENTITIES t
145: USING
146: (
147:
148: SELECT 'Shift' MTH_ALIAS, 1 ID FROM DUAL UNION ALL
149: SELECT 'Workorder' MTH_ALIAS, 2 ID FROM DUAL UNION ALL
150: SELECT 'Workorder Segment' MTH_ALIAS, 3 ID FROM DUAL UNION ALL
151: SELECT 'Item' MTH_ALIAS, 4 ID FROM DUAL UNION ALL
152: SELECT 'Status' MTH_ALIAS, 5 ID FROM DUAL UNION ALL
145: USING
146: (
147:
148: SELECT 'Shift' MTH_ALIAS, 1 ID FROM DUAL UNION ALL
149: SELECT 'Workorder' MTH_ALIAS, 2 ID FROM DUAL UNION ALL
150: SELECT 'Workorder Segment' MTH_ALIAS, 3 ID FROM DUAL UNION ALL
151: SELECT 'Item' MTH_ALIAS, 4 ID FROM DUAL UNION ALL
152: SELECT 'Status' MTH_ALIAS, 5 ID FROM DUAL UNION ALL
153: SELECT 'Completed Quantity' MTH_ALIAS, 6 ID FROM DUAL UNION ALL
146: (
147:
148: SELECT 'Shift' MTH_ALIAS, 1 ID FROM DUAL UNION ALL
149: SELECT 'Workorder' MTH_ALIAS, 2 ID FROM DUAL UNION ALL
150: SELECT 'Workorder Segment' MTH_ALIAS, 3 ID FROM DUAL UNION ALL
151: SELECT 'Item' MTH_ALIAS, 4 ID FROM DUAL UNION ALL
152: SELECT 'Status' MTH_ALIAS, 5 ID FROM DUAL UNION ALL
153: SELECT 'Completed Quantity' MTH_ALIAS, 6 ID FROM DUAL UNION ALL
154: SELECT 'Equipment' MTH_ALIAS, 7 ID FROM DUAL UNION ALL
147:
148: SELECT 'Shift' MTH_ALIAS, 1 ID FROM DUAL UNION ALL
149: SELECT 'Workorder' MTH_ALIAS, 2 ID FROM DUAL UNION ALL
150: SELECT 'Workorder Segment' MTH_ALIAS, 3 ID FROM DUAL UNION ALL
151: SELECT 'Item' MTH_ALIAS, 4 ID FROM DUAL UNION ALL
152: SELECT 'Status' MTH_ALIAS, 5 ID FROM DUAL UNION ALL
153: SELECT 'Completed Quantity' MTH_ALIAS, 6 ID FROM DUAL UNION ALL
154: SELECT 'Equipment' MTH_ALIAS, 7 ID FROM DUAL UNION ALL
155: SELECT 'Equipment Downtime Reason' MTH_ALIAS, 8 ID FROM DUAL UNION ALL
148: SELECT 'Shift' MTH_ALIAS, 1 ID FROM DUAL UNION ALL
149: SELECT 'Workorder' MTH_ALIAS, 2 ID FROM DUAL UNION ALL
150: SELECT 'Workorder Segment' MTH_ALIAS, 3 ID FROM DUAL UNION ALL
151: SELECT 'Item' MTH_ALIAS, 4 ID FROM DUAL UNION ALL
152: SELECT 'Status' MTH_ALIAS, 5 ID FROM DUAL UNION ALL
153: SELECT 'Completed Quantity' MTH_ALIAS, 6 ID FROM DUAL UNION ALL
154: SELECT 'Equipment' MTH_ALIAS, 7 ID FROM DUAL UNION ALL
155: SELECT 'Equipment Downtime Reason' MTH_ALIAS, 8 ID FROM DUAL UNION ALL
156: SELECT 'Output Quantity' MTH_ALIAS, 9 ID FROM DUAL UNION ALL
149: SELECT 'Workorder' MTH_ALIAS, 2 ID FROM DUAL UNION ALL
150: SELECT 'Workorder Segment' MTH_ALIAS, 3 ID FROM DUAL UNION ALL
151: SELECT 'Item' MTH_ALIAS, 4 ID FROM DUAL UNION ALL
152: SELECT 'Status' MTH_ALIAS, 5 ID FROM DUAL UNION ALL
153: SELECT 'Completed Quantity' MTH_ALIAS, 6 ID FROM DUAL UNION ALL
154: SELECT 'Equipment' MTH_ALIAS, 7 ID FROM DUAL UNION ALL
155: SELECT 'Equipment Downtime Reason' MTH_ALIAS, 8 ID FROM DUAL UNION ALL
156: SELECT 'Output Quantity' MTH_ALIAS, 9 ID FROM DUAL UNION ALL
157: SELECT 'Rejected Quantity' MTH_ALIAS, 10 ID FROM DUAL UNION ALL
150: SELECT 'Workorder Segment' MTH_ALIAS, 3 ID FROM DUAL UNION ALL
151: SELECT 'Item' MTH_ALIAS, 4 ID FROM DUAL UNION ALL
152: SELECT 'Status' MTH_ALIAS, 5 ID FROM DUAL UNION ALL
153: SELECT 'Completed Quantity' MTH_ALIAS, 6 ID FROM DUAL UNION ALL
154: SELECT 'Equipment' MTH_ALIAS, 7 ID FROM DUAL UNION ALL
155: SELECT 'Equipment Downtime Reason' MTH_ALIAS, 8 ID FROM DUAL UNION ALL
156: SELECT 'Output Quantity' MTH_ALIAS, 9 ID FROM DUAL UNION ALL
157: SELECT 'Rejected Quantity' MTH_ALIAS, 10 ID FROM DUAL UNION ALL
158: SELECT 'Rework Quantity' MTH_ALIAS, 11 ID FROM DUAL UNION ALL
151: SELECT 'Item' MTH_ALIAS, 4 ID FROM DUAL UNION ALL
152: SELECT 'Status' MTH_ALIAS, 5 ID FROM DUAL UNION ALL
153: SELECT 'Completed Quantity' MTH_ALIAS, 6 ID FROM DUAL UNION ALL
154: SELECT 'Equipment' MTH_ALIAS, 7 ID FROM DUAL UNION ALL
155: SELECT 'Equipment Downtime Reason' MTH_ALIAS, 8 ID FROM DUAL UNION ALL
156: SELECT 'Output Quantity' MTH_ALIAS, 9 ID FROM DUAL UNION ALL
157: SELECT 'Rejected Quantity' MTH_ALIAS, 10 ID FROM DUAL UNION ALL
158: SELECT 'Rework Quantity' MTH_ALIAS, 11 ID FROM DUAL UNION ALL
159: SELECT 'Scrap Quantity' MTH_ALIAS, 12 ID FROM DUAL UNION ALL
152: SELECT 'Status' MTH_ALIAS, 5 ID FROM DUAL UNION ALL
153: SELECT 'Completed Quantity' MTH_ALIAS, 6 ID FROM DUAL UNION ALL
154: SELECT 'Equipment' MTH_ALIAS, 7 ID FROM DUAL UNION ALL
155: SELECT 'Equipment Downtime Reason' MTH_ALIAS, 8 ID FROM DUAL UNION ALL
156: SELECT 'Output Quantity' MTH_ALIAS, 9 ID FROM DUAL UNION ALL
157: SELECT 'Rejected Quantity' MTH_ALIAS, 10 ID FROM DUAL UNION ALL
158: SELECT 'Rework Quantity' MTH_ALIAS, 11 ID FROM DUAL UNION ALL
159: SELECT 'Scrap Quantity' MTH_ALIAS, 12 ID FROM DUAL UNION ALL
160: SELECT 'Scrap Reason' MTH_ALIAS, 13 ID FROM DUAL UNION ALL
153: SELECT 'Completed Quantity' MTH_ALIAS, 6 ID FROM DUAL UNION ALL
154: SELECT 'Equipment' MTH_ALIAS, 7 ID FROM DUAL UNION ALL
155: SELECT 'Equipment Downtime Reason' MTH_ALIAS, 8 ID FROM DUAL UNION ALL
156: SELECT 'Output Quantity' MTH_ALIAS, 9 ID FROM DUAL UNION ALL
157: SELECT 'Rejected Quantity' MTH_ALIAS, 10 ID FROM DUAL UNION ALL
158: SELECT 'Rework Quantity' MTH_ALIAS, 11 ID FROM DUAL UNION ALL
159: SELECT 'Scrap Quantity' MTH_ALIAS, 12 ID FROM DUAL UNION ALL
160: SELECT 'Scrap Reason' MTH_ALIAS, 13 ID FROM DUAL UNION ALL
161: SELECT 'Recipe Number' MTH_ALIAS, 14 ID FROM DUAL UNION ALL
154: SELECT 'Equipment' MTH_ALIAS, 7 ID FROM DUAL UNION ALL
155: SELECT 'Equipment Downtime Reason' MTH_ALIAS, 8 ID FROM DUAL UNION ALL
156: SELECT 'Output Quantity' MTH_ALIAS, 9 ID FROM DUAL UNION ALL
157: SELECT 'Rejected Quantity' MTH_ALIAS, 10 ID FROM DUAL UNION ALL
158: SELECT 'Rework Quantity' MTH_ALIAS, 11 ID FROM DUAL UNION ALL
159: SELECT 'Scrap Quantity' MTH_ALIAS, 12 ID FROM DUAL UNION ALL
160: SELECT 'Scrap Reason' MTH_ALIAS, 13 ID FROM DUAL UNION ALL
161: SELECT 'Recipe Number' MTH_ALIAS, 14 ID FROM DUAL UNION ALL
162: SELECT 'Recipe Version' MTH_ALIAS, 15 ID FROM DUAL UNION ALL
155: SELECT 'Equipment Downtime Reason' MTH_ALIAS, 8 ID FROM DUAL UNION ALL
156: SELECT 'Output Quantity' MTH_ALIAS, 9 ID FROM DUAL UNION ALL
157: SELECT 'Rejected Quantity' MTH_ALIAS, 10 ID FROM DUAL UNION ALL
158: SELECT 'Rework Quantity' MTH_ALIAS, 11 ID FROM DUAL UNION ALL
159: SELECT 'Scrap Quantity' MTH_ALIAS, 12 ID FROM DUAL UNION ALL
160: SELECT 'Scrap Reason' MTH_ALIAS, 13 ID FROM DUAL UNION ALL
161: SELECT 'Recipe Number' MTH_ALIAS, 14 ID FROM DUAL UNION ALL
162: SELECT 'Recipe Version' MTH_ALIAS, 15 ID FROM DUAL UNION ALL
163: SELECT 'Equipment Uptime' MTH_ALIAS, 16 ID FROM DUAL UNION ALL
156: SELECT 'Output Quantity' MTH_ALIAS, 9 ID FROM DUAL UNION ALL
157: SELECT 'Rejected Quantity' MTH_ALIAS, 10 ID FROM DUAL UNION ALL
158: SELECT 'Rework Quantity' MTH_ALIAS, 11 ID FROM DUAL UNION ALL
159: SELECT 'Scrap Quantity' MTH_ALIAS, 12 ID FROM DUAL UNION ALL
160: SELECT 'Scrap Reason' MTH_ALIAS, 13 ID FROM DUAL UNION ALL
161: SELECT 'Recipe Number' MTH_ALIAS, 14 ID FROM DUAL UNION ALL
162: SELECT 'Recipe Version' MTH_ALIAS, 15 ID FROM DUAL UNION ALL
163: SELECT 'Equipment Uptime' MTH_ALIAS, 16 ID FROM DUAL UNION ALL
164: SELECT 'Equipment Idle Reason' MTH_ALIAS, 17 ID FROM DUAL UNION ALL
157: SELECT 'Rejected Quantity' MTH_ALIAS, 10 ID FROM DUAL UNION ALL
158: SELECT 'Rework Quantity' MTH_ALIAS, 11 ID FROM DUAL UNION ALL
159: SELECT 'Scrap Quantity' MTH_ALIAS, 12 ID FROM DUAL UNION ALL
160: SELECT 'Scrap Reason' MTH_ALIAS, 13 ID FROM DUAL UNION ALL
161: SELECT 'Recipe Number' MTH_ALIAS, 14 ID FROM DUAL UNION ALL
162: SELECT 'Recipe Version' MTH_ALIAS, 15 ID FROM DUAL UNION ALL
163: SELECT 'Equipment Uptime' MTH_ALIAS, 16 ID FROM DUAL UNION ALL
164: SELECT 'Equipment Idle Reason' MTH_ALIAS, 17 ID FROM DUAL UNION ALL
165: SELECT 'Equipment Cycles' MTH_ALIAS, 18 ID FROM DUAL UNION ALL
158: SELECT 'Rework Quantity' MTH_ALIAS, 11 ID FROM DUAL UNION ALL
159: SELECT 'Scrap Quantity' MTH_ALIAS, 12 ID FROM DUAL UNION ALL
160: SELECT 'Scrap Reason' MTH_ALIAS, 13 ID FROM DUAL UNION ALL
161: SELECT 'Recipe Number' MTH_ALIAS, 14 ID FROM DUAL UNION ALL
162: SELECT 'Recipe Version' MTH_ALIAS, 15 ID FROM DUAL UNION ALL
163: SELECT 'Equipment Uptime' MTH_ALIAS, 16 ID FROM DUAL UNION ALL
164: SELECT 'Equipment Idle Reason' MTH_ALIAS, 17 ID FROM DUAL UNION ALL
165: SELECT 'Equipment Cycles' MTH_ALIAS, 18 ID FROM DUAL UNION ALL
166: SELECT 'Equipment Fault' MTH_ALIAS, 19 ID FROM DUAL
159: SELECT 'Scrap Quantity' MTH_ALIAS, 12 ID FROM DUAL UNION ALL
160: SELECT 'Scrap Reason' MTH_ALIAS, 13 ID FROM DUAL UNION ALL
161: SELECT 'Recipe Number' MTH_ALIAS, 14 ID FROM DUAL UNION ALL
162: SELECT 'Recipe Version' MTH_ALIAS, 15 ID FROM DUAL UNION ALL
163: SELECT 'Equipment Uptime' MTH_ALIAS, 16 ID FROM DUAL UNION ALL
164: SELECT 'Equipment Idle Reason' MTH_ALIAS, 17 ID FROM DUAL UNION ALL
165: SELECT 'Equipment Cycles' MTH_ALIAS, 18 ID FROM DUAL UNION ALL
166: SELECT 'Equipment Fault' MTH_ALIAS, 19 ID FROM DUAL
167:
160: SELECT 'Scrap Reason' MTH_ALIAS, 13 ID FROM DUAL UNION ALL
161: SELECT 'Recipe Number' MTH_ALIAS, 14 ID FROM DUAL UNION ALL
162: SELECT 'Recipe Version' MTH_ALIAS, 15 ID FROM DUAL UNION ALL
163: SELECT 'Equipment Uptime' MTH_ALIAS, 16 ID FROM DUAL UNION ALL
164: SELECT 'Equipment Idle Reason' MTH_ALIAS, 17 ID FROM DUAL UNION ALL
165: SELECT 'Equipment Cycles' MTH_ALIAS, 18 ID FROM DUAL UNION ALL
166: SELECT 'Equipment Fault' MTH_ALIAS, 19 ID FROM DUAL
167:
168: ) s
161: SELECT 'Recipe Number' MTH_ALIAS, 14 ID FROM DUAL UNION ALL
162: SELECT 'Recipe Version' MTH_ALIAS, 15 ID FROM DUAL UNION ALL
163: SELECT 'Equipment Uptime' MTH_ALIAS, 16 ID FROM DUAL UNION ALL
164: SELECT 'Equipment Idle Reason' MTH_ALIAS, 17 ID FROM DUAL UNION ALL
165: SELECT 'Equipment Cycles' MTH_ALIAS, 18 ID FROM DUAL UNION ALL
166: SELECT 'Equipment Fault' MTH_ALIAS, 19 ID FROM DUAL
167:
168: ) s
169: ON (s.ID = t.ID)
162: SELECT 'Recipe Version' MTH_ALIAS, 15 ID FROM DUAL UNION ALL
163: SELECT 'Equipment Uptime' MTH_ALIAS, 16 ID FROM DUAL UNION ALL
164: SELECT 'Equipment Idle Reason' MTH_ALIAS, 17 ID FROM DUAL UNION ALL
165: SELECT 'Equipment Cycles' MTH_ALIAS, 18 ID FROM DUAL UNION ALL
166: SELECT 'Equipment Fault' MTH_ALIAS, 19 ID FROM DUAL
167:
168: ) s
169: ON (s.ID = t.ID)
170: WHEN matched THEN
197:
198: merge INTO MTH_EQUIP_ENTITIES_MST t
199: USING
200: (
201: SELECT MTH_UTIL_PKG.MTH_UA_GET_VAL() ENTITY_PK_KEY, MTH_UTIL_PKG.MTH_UA_GET_VAL() ENTITY_PK, MTH_UTIL_PKG.MTH_UA_GET_MEANING() ENTITY_NAME, MTH_UTIL_PKG.MTH_UA_GET_MEANING() ENTITY_TYPE, MTH_UTIL_PKG.MTH_UA_GET_VAL() SYSTEM_FK_KEY FROM DUAL
202: )s
203: ON (s.ENTITY_PK_KEY = t.ENTITY_PK_KEY)
204:
205: WHEN matched THEN
239:
240: merge INTO MTH_EQUIPMENTS_D t
241: USING
242: (
243: SELECT MTH_UTIL_PKG.MTH_UA_GET_VAL() EQUIPMENT_PK_KEY, MTH_UTIL_PKG.MTH_UA_GET_VAL() EQUIPMENT_PK, MTH_UTIL_PKG.MTH_UA_GET_VAL() PLANT_FK_KEY, MTH_UTIL_PKG.MTH_UA_GET_MEANING() EQUIPMENT_NAME, MTH_UTIL_PKG.MTH_UA_GET_VAL() SYSTEM_FK_KEY FROM DUAL
244: )s
245: ON (s.EQUIPMENT_PK_KEY = t.EQUIPMENT_PK_KEY )
246:
247: WHEN matched THEN
308: NULL SEGMENT18,
309: NULL SEGMENT19,
310: NULL SEGMENT20
311:
312: FROM DUAL CONSTANT
313: )s
314: ON (s.CATEGORY_PK_KEY = t.CATEGORY_PK_KEY )
315:
316: WHEN matched THEN
428: NULL USER_ATTR5,
429: NULL CREATED_BY,
430: NULL LAST_UPDATE_LOGIN,
431: NULL LAST_UPDATED_BY
432: FROM DUAL
433: )s
434: ON (t.ITEM_FK_KEY = s.ITEM_FK_KEY)
435:
436: WHEN matched THEN
477: '0' PRIMARY_UOM,
478: MTH_UTIL_PKG.MTH_UA_GET_VAL() PLANT_FK_KEY,
479: MTH_UTIL_PKG.MTH_UA_GET_VAL() SYSTEM_FK_KEY,
480: MTH_UTIL_PKG.MTH_UA_GET_MEANING() ITEM_NAME
481: FROM DUAL CONSTANT
482: )s
483: ON (t.ITEM_PK_KEY = s.ITEM_PK_KEY)
484:
485: WHEN matched THEN
523:
524: merge INTO MTH_LOOKUPS_D t
525: USING
526: (
527: SELECT 'MTH_BATCH_TERM_IND_L' LOOKUP_TYPE, 0 LOOKUP_CODE, 'No' REPORTING_CODE FROM DUAL UNION ALL
528: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 1 LOOKUP_CODE, 'Unreleased' REPORTING_CODE FROM DUAL UNION ALL
529: SELECT 'MTH_BATCH_TERM_IND_L' LOOKUP_TYPE, 1 LOOKUP_CODE, 'Yes' REPORTING_CODE FROM DUAL UNION ALL
530: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 2 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
531: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 3 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
524: merge INTO MTH_LOOKUPS_D t
525: USING
526: (
527: SELECT 'MTH_BATCH_TERM_IND_L' LOOKUP_TYPE, 0 LOOKUP_CODE, 'No' REPORTING_CODE FROM DUAL UNION ALL
528: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 1 LOOKUP_CODE, 'Unreleased' REPORTING_CODE FROM DUAL UNION ALL
529: SELECT 'MTH_BATCH_TERM_IND_L' LOOKUP_TYPE, 1 LOOKUP_CODE, 'Yes' REPORTING_CODE FROM DUAL UNION ALL
530: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 2 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
531: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 3 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
532: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 4 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
525: USING
526: (
527: SELECT 'MTH_BATCH_TERM_IND_L' LOOKUP_TYPE, 0 LOOKUP_CODE, 'No' REPORTING_CODE FROM DUAL UNION ALL
528: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 1 LOOKUP_CODE, 'Unreleased' REPORTING_CODE FROM DUAL UNION ALL
529: SELECT 'MTH_BATCH_TERM_IND_L' LOOKUP_TYPE, 1 LOOKUP_CODE, 'Yes' REPORTING_CODE FROM DUAL UNION ALL
530: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 2 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
531: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 3 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
532: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 4 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
533: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 5 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
526: (
527: SELECT 'MTH_BATCH_TERM_IND_L' LOOKUP_TYPE, 0 LOOKUP_CODE, 'No' REPORTING_CODE FROM DUAL UNION ALL
528: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 1 LOOKUP_CODE, 'Unreleased' REPORTING_CODE FROM DUAL UNION ALL
529: SELECT 'MTH_BATCH_TERM_IND_L' LOOKUP_TYPE, 1 LOOKUP_CODE, 'Yes' REPORTING_CODE FROM DUAL UNION ALL
530: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 2 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
531: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 3 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
532: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 4 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
533: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 5 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
534: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 6 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
527: SELECT 'MTH_BATCH_TERM_IND_L' LOOKUP_TYPE, 0 LOOKUP_CODE, 'No' REPORTING_CODE FROM DUAL UNION ALL
528: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 1 LOOKUP_CODE, 'Unreleased' REPORTING_CODE FROM DUAL UNION ALL
529: SELECT 'MTH_BATCH_TERM_IND_L' LOOKUP_TYPE, 1 LOOKUP_CODE, 'Yes' REPORTING_CODE FROM DUAL UNION ALL
530: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 2 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
531: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 3 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
532: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 4 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
533: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 5 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
534: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 6 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
535: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 7 LOOKUP_CODE, 'Cancel' REPORTING_CODE FROM DUAL UNION ALL
528: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 1 LOOKUP_CODE, 'Unreleased' REPORTING_CODE FROM DUAL UNION ALL
529: SELECT 'MTH_BATCH_TERM_IND_L' LOOKUP_TYPE, 1 LOOKUP_CODE, 'Yes' REPORTING_CODE FROM DUAL UNION ALL
530: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 2 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
531: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 3 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
532: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 4 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
533: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 5 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
534: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 6 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
535: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 7 LOOKUP_CODE, 'Cancel' REPORTING_CODE FROM DUAL UNION ALL
536: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 8 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
529: SELECT 'MTH_BATCH_TERM_IND_L' LOOKUP_TYPE, 1 LOOKUP_CODE, 'Yes' REPORTING_CODE FROM DUAL UNION ALL
530: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 2 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
531: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 3 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
532: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 4 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
533: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 5 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
534: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 6 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
535: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 7 LOOKUP_CODE, 'Cancel' REPORTING_CODE FROM DUAL UNION ALL
536: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 8 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
537: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 9 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
530: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 2 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
531: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 3 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
532: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 4 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
533: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 5 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
534: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 6 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
535: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 7 LOOKUP_CODE, 'Cancel' REPORTING_CODE FROM DUAL UNION ALL
536: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 8 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
537: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 9 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
538: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 10 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
531: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 3 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
532: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 4 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
533: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 5 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
534: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 6 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
535: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 7 LOOKUP_CODE, 'Cancel' REPORTING_CODE FROM DUAL UNION ALL
536: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 8 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
537: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 9 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
538: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 10 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
539: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 11 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
532: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 4 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
533: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 5 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
534: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 6 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
535: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 7 LOOKUP_CODE, 'Cancel' REPORTING_CODE FROM DUAL UNION ALL
536: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 8 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
537: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 9 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
538: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 10 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
539: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 11 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
540: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 12 LOOKUP_CODE, 'Close' REPORTING_CODE FROM DUAL UNION ALL
533: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 5 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
534: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 6 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
535: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 7 LOOKUP_CODE, 'Cancel' REPORTING_CODE FROM DUAL UNION ALL
536: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 8 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
537: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 9 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
538: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 10 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
539: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 11 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
540: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 12 LOOKUP_CODE, 'Close' REPORTING_CODE FROM DUAL UNION ALL
541: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 13 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
534: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 6 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
535: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 7 LOOKUP_CODE, 'Cancel' REPORTING_CODE FROM DUAL UNION ALL
536: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 8 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
537: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 9 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
538: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 10 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
539: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 11 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
540: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 12 LOOKUP_CODE, 'Close' REPORTING_CODE FROM DUAL UNION ALL
541: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 13 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
542: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 14 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
535: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 7 LOOKUP_CODE, 'Cancel' REPORTING_CODE FROM DUAL UNION ALL
536: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 8 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
537: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 9 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
538: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 10 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
539: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 11 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
540: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 12 LOOKUP_CODE, 'Close' REPORTING_CODE FROM DUAL UNION ALL
541: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 13 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
542: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 14 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
543: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 15 LOOKUP_CODE, 'Cancel' REPORTING_CODE FROM DUAL UNION ALL
536: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 8 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
537: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 9 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
538: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 10 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
539: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 11 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
540: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 12 LOOKUP_CODE, 'Close' REPORTING_CODE FROM DUAL UNION ALL
541: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 13 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
542: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 14 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
543: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 15 LOOKUP_CODE, 'Cancel' REPORTING_CODE FROM DUAL UNION ALL
544: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 16 LOOKUP_CODE, 'Terminated' REPORTING_CODE FROM DUAL UNION ALL
537: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 9 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
538: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 10 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
539: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 11 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
540: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 12 LOOKUP_CODE, 'Close' REPORTING_CODE FROM DUAL UNION ALL
541: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 13 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
542: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 14 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
543: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 15 LOOKUP_CODE, 'Cancel' REPORTING_CODE FROM DUAL UNION ALL
544: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 16 LOOKUP_CODE, 'Terminated' REPORTING_CODE FROM DUAL UNION ALL
545: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 17 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL
538: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 10 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
539: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 11 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
540: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 12 LOOKUP_CODE, 'Close' REPORTING_CODE FROM DUAL UNION ALL
541: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 13 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
542: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 14 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
543: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 15 LOOKUP_CODE, 'Cancel' REPORTING_CODE FROM DUAL UNION ALL
544: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 16 LOOKUP_CODE, 'Terminated' REPORTING_CODE FROM DUAL UNION ALL
545: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 17 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL
546: )s
539: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 11 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL UNION ALL
540: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 12 LOOKUP_CODE, 'Close' REPORTING_CODE FROM DUAL UNION ALL
541: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 13 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
542: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 14 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
543: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 15 LOOKUP_CODE, 'Cancel' REPORTING_CODE FROM DUAL UNION ALL
544: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 16 LOOKUP_CODE, 'Terminated' REPORTING_CODE FROM DUAL UNION ALL
545: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 17 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL
546: )s
547:
540: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 12 LOOKUP_CODE, 'Close' REPORTING_CODE FROM DUAL UNION ALL
541: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 13 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
542: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 14 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
543: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 15 LOOKUP_CODE, 'Cancel' REPORTING_CODE FROM DUAL UNION ALL
544: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 16 LOOKUP_CODE, 'Terminated' REPORTING_CODE FROM DUAL UNION ALL
545: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 17 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL
546: )s
547:
548: ON (
541: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 13 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
542: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 14 LOOKUP_CODE, 'Complete' REPORTING_CODE FROM DUAL UNION ALL
543: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 15 LOOKUP_CODE, 'Cancel' REPORTING_CODE FROM DUAL UNION ALL
544: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 16 LOOKUP_CODE, 'Terminated' REPORTING_CODE FROM DUAL UNION ALL
545: SELECT 'MTH_WORKORDER_STATUS_L' LOOKUP_TYPE, 17 LOOKUP_CODE, 'Open' REPORTING_CODE FROM DUAL
546: )s
547:
548: ON (
549: t.LOOKUP_TYPE = s.LOOKUP_TYPE AND
589: MTH_UTIL_PKG.MTH_UA_GET_MEANING() PLANT_NAME,
590: 0 GRAVEYARD_SHIFT_FLAG,
591: TO_DATE ('01-01-1900','DD-MM-YYYY' ) FROM_DATE
592: FROM
593: DUAL
594: )s
595: ON (t.PLANT_PK_KEY = s.PLANT_PK_KEY)
596:
597: WHEN matched THEN
646: MTH_UTIL_PKG.MTH_UA_GET_VAL() SYSTEM_FK_KEY,
647: MTH_UTIL_PKG.MTH_UA_GET_MEANING() DESCRIPTION
648:
649: FROM
650: DUAL CONSTANT
651: )s
652: ON (t.SUB_SEGMENT_PK_KEY = s.SUB_SEGMENT_PK_KEY)
653:
654: WHEN matched THEN
699: 1 STATUS_CODE,
700: MTH_UTIL_PKG.MTH_UA_GET_VAL() SYSTEM_FK_KEY
701:
702: FROM
703: DUAL CONSTANT
704: )s
705: ON (t.WORKORDER_PK_KEY = s.WORKORDER_PK_KEY)
706:
707: WHEN matched THEN
758: MTH_UTIL_PKG.MTH_UA_GET_MEANING() WORKORDER_NAME,
759: 1 WORKORDER_TYPE,
760: 1 STATUS_CODE
761: FROM
762: DUAL CONSTANT
763: )s
764: ON (t.SEGMENT_PK_KEY = s.SEGMENT_PK_KEY)
765:
766: WHEN matched THEN
808: 0 COST,
809: 1 ISCURRENT,
810: MTH_UTIL_PKG.MTH_UA_GET_VAL() SYSTEM_FK_KEY
811: FROM
812: DUAL
813: )s
814: ON (t.RESOURCE_FK_KEY = s.RESOURCE_FK_KEY)
815:
816: WHEN matched THEN
859: MTH_UTIL_PKG.MTH_UA_GET_VAL() PLANT_FK_KEY,
860: MTH_UTIL_PKG.MTH_UA_GET_VAL() SYSTEM_FK_KEY,
861: 'MACHINE' RESOURCE_TYPE
862: FROM
863: DUAL
864: )s
865: ON (t.RESOURCE_PK_KEY = s.RESOURCE_PK_KEY)
866:
867: WHEN matched THEN
911: MTH_UTIL_PKG.MTH_UA_GET_VAL() SYSTEM_PK,
912: MTH_UTIL_PKG.MTH_UA_GET_MEANING() SYSTEM_NAME,
913: 'OTH' SYSTEM_TYPE
914: FROM
915: DUAL
916: )s
917: ON (t.SYSTEM_PK_KEY = s.SYSTEM_PK_KEY)
918:
919: WHEN matched THEN