VIEW: APPS.PQH_ROLE_EXTRA_INFO1_DFV

Source

View Text - Preformatted

SELECT ROWID, INFORMATION_CATEGORY, INFORMATION1, INFORMATION2, INFORMATION1, INFORMATION2, INFORMATION3, INFORMATION1, (DECODE (INFORMATION_CATEGORY, 'FR_PQH_COMMITTEE_VOTE_RULES', INFORMATION2, 'FR_PQH_COMMITTEE_CORPS_ESTAB', INFORMATION2, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_PQH_COMMITTEE_VOTE_RULES', INFORMATION6, 'FR_PQH_COMMITTEE_CORPS_ESTAB', INFORMATION3, NULL)), INFORMATION4, INFORMATION5, (DECODE (INFORMATION_CATEGORY, 'FR_PQH_COMMITTEE_ELECTION', TO_DATE(INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_PQH_COMMITTEE_ELECTION', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION2), NULL)), INFORMATION3, (DECODE (INFORMATION_CATEGORY, 'FR_PQH_COMMITTEE_ELECTION', TO_DATE(INFORMATION4, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_PQH_COMMITTEE_ELECTION', TO_DATE(INFORMATION5, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_PQH_COMMITTEE_ELECTION', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION6), NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_PQH_COMMITTEE_ELECTION', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION7), NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_PQH_COMMITTEE_ELECTION', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION8), NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_PQH_COMMITTEE_ELECTION', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION9), NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_PQH_COMMITTEE_ELECTION', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION10), NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_PQH_COMMITTEE_ELECTION', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION11), NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_PQH_COMMITTEE_RULES', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1), NULL)), INFORMATION2, (DECODE (INFORMATION_CATEGORY, 'FR_PQH_COMMITTEE_RULES', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION3), NULL)), INFORMATION4, (DECODE (INFORMATION_CATEGORY, 'FR_PQH_COMMITTEE_RULES', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION5), NULL)), INFORMATION6, INFORMATION7, INFORMATION8, INFORMATION1, INFORMATION3, (DECODE (INFORMATION_CATEGORY, 'FR_PQH_COMMITTEE_VOTE_RULES', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION4), NULL)), INFORMATION5,  
 (DECODE (INFORMATION_CATEGORY,  
      'BEN_LER_TYP_CD', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2,  
      'BEN_SS_ROLE_COMP_OBJECTS', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3,  
      'FR_PQH_COMMITTEE_CORPS_ESTAB', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5,  
      'FR_PQH_COMMITTEE_ELECTION', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6 || '.' || INFORMATION7 || '.' || INFORMATION8 || '.' || INFORMATION9 || '.' || INFORMATION10 || '.' || INFORMATION11,  
      'FR_PQH_COMMITTEE_RULES', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6 || '.' || INFORMATION7 || '.' || INFORMATION8,  
      'FR_PQH_COMMITTEE_VOTE_RULES', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6, NULL)) 
 FROM PQH_ROLE_EXTRA_INFO

View Text - HTML Formatted

SELECT ROWID
, INFORMATION_CATEGORY
, INFORMATION1
, INFORMATION2
, INFORMATION1
, INFORMATION2
, INFORMATION3
, INFORMATION1
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_COMMITTEE_VOTE_RULES'
, INFORMATION2
, 'FR_PQH_COMMITTEE_CORPS_ESTAB'
, INFORMATION2
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_COMMITTEE_VOTE_RULES'
, INFORMATION6
, 'FR_PQH_COMMITTEE_CORPS_ESTAB'
, INFORMATION3
, NULL))
, INFORMATION4
, INFORMATION5
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_COMMITTEE_ELECTION'
, TO_DATE(INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_COMMITTEE_ELECTION'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION2)
, NULL))
, INFORMATION3
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_COMMITTEE_ELECTION'
, TO_DATE(INFORMATION4
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_COMMITTEE_ELECTION'
, TO_DATE(INFORMATION5
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_COMMITTEE_ELECTION'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION6)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_COMMITTEE_ELECTION'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION7)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_COMMITTEE_ELECTION'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION8)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_COMMITTEE_ELECTION'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION9)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_COMMITTEE_ELECTION'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION10)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_COMMITTEE_ELECTION'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION11)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_COMMITTEE_RULES'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1)
, NULL))
, INFORMATION2
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_COMMITTEE_RULES'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION3)
, NULL))
, INFORMATION4
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_COMMITTEE_RULES'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION5)
, NULL))
, INFORMATION6
, INFORMATION7
, INFORMATION8
, INFORMATION1
, INFORMATION3
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH_COMMITTEE_VOTE_RULES'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION4)
, NULL))
, INFORMATION5
, (DECODE (INFORMATION_CATEGORY
, 'BEN_LER_TYP_CD'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2
, 'BEN_SS_ROLE_COMP_OBJECTS'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3
, 'FR_PQH_COMMITTEE_CORPS_ESTAB'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5
, 'FR_PQH_COMMITTEE_ELECTION'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6 || '.' || INFORMATION7 || '.' || INFORMATION8 || '.' || INFORMATION9 || '.' || INFORMATION10 || '.' || INFORMATION11
, 'FR_PQH_COMMITTEE_RULES'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6 || '.' || INFORMATION7 || '.' || INFORMATION8
, 'FR_PQH_COMMITTEE_VOTE_RULES'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6
, NULL))
FROM PQH_ROLE_EXTRA_INFO