eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.SSP_MATERNITIES1_DFV

Source

View Text - Preformatted


SELECT ROWID, MAT_INFORMATION_CATEGORY, (DECODE (MAT_INFORMATION_CATEGORY, 'GB_MATERNITY_KIT', TO_DATE(MAT_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_BIRTH_KIT', TO_DATE(MAT_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_ADOPTION_KIT', TO_DATE(MAT_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ADOPTION_KIT', TO_DATE(MAT_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (MAT_INFORMATION_CATEGORY, 'GB_MATERNITY_KIT', TO_DATE(MAT_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_BIRTH_KIT', TO_DATE(MAT_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_ADOPTION_KIT', TO_DATE(MAT_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ADOPTION_KIT', TO_DATE(MAT_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (MAT_INFORMATION_CATEGORY, 'GB_MATERNITY_KIT', TO_DATE(MAT_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_BIRTH_KIT', TO_DATE(MAT_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_ADOPTION_KIT', TO_DATE(MAT_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ADOPTION_KIT', TO_DATE(MAT_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (MAT_INFORMATION_CATEGORY, 'GB_MATERNITY_KIT', TO_DATE(MAT_INFORMATION4, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_BIRTH_KIT', TO_DATE(MAT_INFORMATION4, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_ADOPTION_KIT', TO_DATE(MAT_INFORMATION4, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ADOPTION_KIT', TO_DATE(MAT_INFORMATION4, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (MAT_INFORMATION_CATEGORY, 'GB_MATERNITY_KIT', TO_DATE(MAT_INFORMATION5, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_BIRTH_KIT', TO_DATE(MAT_INFORMATION5, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_ADOPTION_KIT', TO_DATE(MAT_INFORMATION5, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ADOPTION_KIT', TO_DATE(MAT_INFORMATION5, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (MAT_INFORMATION_CATEGORY, 'GB_MATERNITY_KIT', TO_DATE(MAT_INFORMATION6, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_BIRTH_KIT', TO_DATE(MAT_INFORMATION6, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_ADOPTION_KIT', TO_DATE(MAT_INFORMATION6, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ADOPTION_KIT', TO_DATE(MAT_INFORMATION6, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (MAT_INFORMATION_CATEGORY, 'GB_MATERNITY_KIT', TO_DATE(MAT_INFORMATION7, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_BIRTH_KIT', TO_DATE(MAT_INFORMATION7, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_ADOPTION_KIT', TO_DATE(MAT_INFORMATION7, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ADOPTION_KIT', TO_DATE(MAT_INFORMATION7, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (MAT_INFORMATION_CATEGORY, 'GB_MATERNITY_KIT', TO_DATE(MAT_INFORMATION8, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_BIRTH_KIT', TO_DATE(MAT_INFORMATION8, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_ADOPTION_KIT', TO_DATE(MAT_INFORMATION8, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ADOPTION_KIT', TO_DATE(MAT_INFORMATION8, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (MAT_INFORMATION_CATEGORY, 'GB_MATERNITY_KIT', TO_DATE(MAT_INFORMATION9, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_BIRTH_KIT', TO_DATE(MAT_INFORMATION9, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_ADOPTION_KIT', TO_DATE(MAT_INFORMATION9, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ADOPTION_KIT', TO_DATE(MAT_INFORMATION9, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (MAT_INFORMATION_CATEGORY, 'GB_MATERNITY_KIT', TO_DATE(MAT_INFORMATION10, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_BIRTH_KIT', TO_DATE(MAT_INFORMATION10, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ASPP_ADOPTION_KIT', TO_DATE(MAT_INFORMATION10, 'YYYY/MM/DD HH24:MI:SS'), 'GB_ADOPTION_KIT', TO_DATE(MAT_INFORMATION10, 'YYYY/MM/DD HH24:MI:SS'), NULL)),  
 (DECODE (MAT_INFORMATION_CATEGORY,  
      'GB_ADOPTION_KIT', MAT_INFORMATION_CATEGORY || '.' || MAT_INFORMATION1 || '.' || MAT_INFORMATION2 || '.' || MAT_INFORMATION3 || '.' || MAT_INFORMATION4 || '.' || MAT_INFORMATION5 || '.' || MAT_INFORMATION6 || '.' || MAT_INFORMATION7 || '.' || MAT_INFORMATION8 || '.' || MAT_INFORMATION9 || '.' || MAT_INFORMATION10,  
      'GB_ASPP_ADOPTION_KIT', MAT_INFORMATION_CATEGORY || '.' || MAT_INFORMATION1 || '.' || MAT_INFORMATION2 || '.' || MAT_INFORMATION3 || '.' || MAT_INFORMATION4 || '.' || MAT_INFORMATION5 || '.' || MAT_INFORMATION6 || '.' || MAT_INFORMATION7 || '.' || MAT_INFORMATION8 || '.' || MAT_INFORMATION9 || '.' || MAT_INFORMATION10,  
      'GB_ASPP_BIRTH_KIT', MAT_INFORMATION_CATEGORY || '.' || MAT_INFORMATION1 || '.' || MAT_INFORMATION2 || '.' || MAT_INFORMATION3 || '.' || MAT_INFORMATION4 || '.' || MAT_INFORMATION5 || '.' || MAT_INFORMATION6 || '.' || MAT_INFORMATION7 || '.' || MAT_INFORMATION8 || '.' || MAT_INFORMATION9 || '.' || MAT_INFORMATION10,  
      'GB_MATERNITY_KIT', MAT_INFORMATION_CATEGORY || '.' || MAT_INFORMATION1 || '.' || MAT_INFORMATION2 || '.' || MAT_INFORMATION3 || '.' || MAT_INFORMATION4 || '.' || MAT_INFORMATION5 || '.' || MAT_INFORMATION6 || '.' || MAT_INFORMATION7 || '.' || MAT_INFORMATION8 || '.' || MAT_INFORMATION9 || '.' || MAT_INFORMATION10, NULL)) 
 FROM SSP_MATERNITIES

View Text - HTML Formatted

SELECT ROWID
, MAT_INFORMATION_CATEGORY
, (DECODE (MAT_INFORMATION_CATEGORY
, 'GB_MATERNITY_KIT'
, TO_DATE(MAT_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_BIRTH_KIT'
, TO_DATE(MAT_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (MAT_INFORMATION_CATEGORY
, 'GB_MATERNITY_KIT'
, TO_DATE(MAT_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_BIRTH_KIT'
, TO_DATE(MAT_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (MAT_INFORMATION_CATEGORY
, 'GB_MATERNITY_KIT'
, TO_DATE(MAT_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_BIRTH_KIT'
, TO_DATE(MAT_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (MAT_INFORMATION_CATEGORY
, 'GB_MATERNITY_KIT'
, TO_DATE(MAT_INFORMATION4
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_BIRTH_KIT'
, TO_DATE(MAT_INFORMATION4
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION4
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION4
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (MAT_INFORMATION_CATEGORY
, 'GB_MATERNITY_KIT'
, TO_DATE(MAT_INFORMATION5
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_BIRTH_KIT'
, TO_DATE(MAT_INFORMATION5
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION5
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION5
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (MAT_INFORMATION_CATEGORY
, 'GB_MATERNITY_KIT'
, TO_DATE(MAT_INFORMATION6
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_BIRTH_KIT'
, TO_DATE(MAT_INFORMATION6
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION6
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION6
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (MAT_INFORMATION_CATEGORY
, 'GB_MATERNITY_KIT'
, TO_DATE(MAT_INFORMATION7
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_BIRTH_KIT'
, TO_DATE(MAT_INFORMATION7
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION7
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION7
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (MAT_INFORMATION_CATEGORY
, 'GB_MATERNITY_KIT'
, TO_DATE(MAT_INFORMATION8
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_BIRTH_KIT'
, TO_DATE(MAT_INFORMATION8
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION8
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION8
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (MAT_INFORMATION_CATEGORY
, 'GB_MATERNITY_KIT'
, TO_DATE(MAT_INFORMATION9
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_BIRTH_KIT'
, TO_DATE(MAT_INFORMATION9
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION9
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION9
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (MAT_INFORMATION_CATEGORY
, 'GB_MATERNITY_KIT'
, TO_DATE(MAT_INFORMATION10
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_BIRTH_KIT'
, TO_DATE(MAT_INFORMATION10
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ASPP_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION10
, 'YYYY/MM/DD HH24:MI:SS')
, 'GB_ADOPTION_KIT'
, TO_DATE(MAT_INFORMATION10
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (MAT_INFORMATION_CATEGORY
, 'GB_ADOPTION_KIT'
, MAT_INFORMATION_CATEGORY || '.' || MAT_INFORMATION1 || '.' || MAT_INFORMATION2 || '.' || MAT_INFORMATION3 || '.' || MAT_INFORMATION4 || '.' || MAT_INFORMATION5 || '.' || MAT_INFORMATION6 || '.' || MAT_INFORMATION7 || '.' || MAT_INFORMATION8 || '.' || MAT_INFORMATION9 || '.' || MAT_INFORMATION10
, 'GB_ASPP_ADOPTION_KIT'
, MAT_INFORMATION_CATEGORY || '.' || MAT_INFORMATION1 || '.' || MAT_INFORMATION2 || '.' || MAT_INFORMATION3 || '.' || MAT_INFORMATION4 || '.' || MAT_INFORMATION5 || '.' || MAT_INFORMATION6 || '.' || MAT_INFORMATION7 || '.' || MAT_INFORMATION8 || '.' || MAT_INFORMATION9 || '.' || MAT_INFORMATION10
, 'GB_ASPP_BIRTH_KIT'
, MAT_INFORMATION_CATEGORY || '.' || MAT_INFORMATION1 || '.' || MAT_INFORMATION2 || '.' || MAT_INFORMATION3 || '.' || MAT_INFORMATION4 || '.' || MAT_INFORMATION5 || '.' || MAT_INFORMATION6 || '.' || MAT_INFORMATION7 || '.' || MAT_INFORMATION8 || '.' || MAT_INFORMATION9 || '.' || MAT_INFORMATION10
, 'GB_MATERNITY_KIT'
, MAT_INFORMATION_CATEGORY || '.' || MAT_INFORMATION1 || '.' || MAT_INFORMATION2 || '.' || MAT_INFORMATION3 || '.' || MAT_INFORMATION4 || '.' || MAT_INFORMATION5 || '.' || MAT_INFORMATION6 || '.' || MAT_INFORMATION7 || '.' || MAT_INFORMATION8 || '.' || MAT_INFORMATION9 || '.' || MAT_INFORMATION10
, NULL))
FROM SSP_MATERNITIES