Found as a view used extensively in custom code written for an enterprisey tool we use:
[code]CREATE OR REPLACE VIEW ITIL_SERVICE_V1 AS
SELECT 'SS1' SERVICIO, 'Low' IMPACTO TIME, 'Low' URGENCIA TIME, 48 RESPONSE TIME, 96 RESOLUTION TIME, 4 ESCALATES TIME FROM DUAL -- Priority Low
UNION ALL
SELECT 'SS1', 'Low', 'Medium', 48,96,4 FROM DUAL -- Priority low
UNION ALL
SELECT 'SS1', 'Medium', 'Low', 48,96,4 FROM DUAL -- Priority low
UNION ALL
SELECT 'SS1', 'High', 'Low', 1.5,24,1 FROM DUAL -- Priority Medium
UNION ALL
SELECT 'SS1', 'Medium', 'Medium', 3,36,2 FROM DUAL -- Priority normal
UNION ALL
SELECT 'SS1', 'Low', 'High', 48,96,4 FROM DUAL -- Priority low
UNION ALL
SELECT 'SS1', 'Medium', 'High', 1.5,24,1 FROM DUAL -- Priority medium
UNION ALL
SELECT 'SS1', 'High', 'Medium', 0.30,16,0.30 FROM DUAL -- Priority High
UNION ALL
SELECT 'SS1', 'High', 'High', 0.15,8,0.15 FROM DUAL -- Priority Urgent
UNION ALL
--Hardware Support (HS2)
SELECT 'HS2', 'Low', 'Low', 48,96,4 FROM DUAL -- Priority Low
UNION ALL
SELECT 'HS2', 'Low', 'Medium', 48,96,4 FROM DUAL -- Priority Low
UNION ALL
SELECT 'HS2', 'Medium', 'Low', 48,96,4 FROM DUAL -- Priority low
UNION ALL
SELECT 'HS2', 'High', 'Low', 1.5,24,1 FROM DUAL -- Priority Medium
UNION ALL
SELECT 'HS2', 'Medium', 'Medium', 3,36,2 FROM DUAL -- Priority Medium
UNION ALL
SELECT 'HS2', 'Low', 'High', 48,96,4 FROM DUAL -- Priority low
UNION ALL
SELECT 'HS2', 'Medium', 'High', 1.5,24,1 FROM DUAL -- Priority medium
UNION ALL
SELECT 'HS2', 'High', 'Medium', 0.30,16,0.30 FROM DUAL -- Priority High
UNION ALL
SELECT 'HS2', 'High', 'High', 0.15,8,0.15 FROM DUAL -- Priority Urgent
UNION ALL
--Asset Managemetn (AM3)
SELECT 'AM3', 'Low', 'Low', 48,96,4 FROM DUAL -- Priority Low
UNION ALL
SELECT 'AM3', 'Low', 'Medium', 48,96,4 FROM DUAL -- Priority Low
...snip 800 lines...
UNION ALL
SELECT 'ACC45', 'Medium', 'High', 1.5,24,1 FROM DUAL -- Priority medium
UNION ALL
SELECT 'ACC45', 'High', 'Medium', 0.30,16,0.30 FROM DUAL -- Priority High
UNION ALL
SELECT 'ACC45', 'High', 'High', 0.15,8,0.15 FROM DUAL -- Priority Urgent;
[/code]
I dont even know man.