VIEW: APPS.PER_GEN_HIERARCHY_NODES1_DFV

Source

View Text - Preformatted

SELECT ROWID, INFORMATION_CATEGORY, INFORMATION3, INFORMATION4, INFORMATION5, INFORMATION6, INFORMATION7, INFORMATION8, INFORMATION9, INFORMATION10, (DECODE (INFORMATION_CATEGORY, 'CAREER_NODE', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION11), NULL)), (DECODE (INFORMATION_CATEGORY, 'CAREER_NODE', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION12), NULL)), (DECODE (INFORMATION_CATEGORY, 'CAREER_NODE', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION13), NULL)), (DECODE (INFORMATION_CATEGORY, 'CAREER_NODE', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION14), NULL)), (DECODE (INFORMATION_CATEGORY, 'CAREER_NODE', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION15), NULL)), (DECODE (INFORMATION_CATEGORY, 'CAREER_NODE', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION16), NULL)), (DECODE (INFORMATION_CATEGORY, 'CAREER_NODE', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION17), NULL)), (DECODE (INFORMATION_CATEGORY, 'CAREER_NODE', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION18), NULL)), (DECODE (INFORMATION_CATEGORY, 'CAREER_NODE', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION19), NULL)), (DECODE (INFORMATION_CATEGORY, 'CAREER_NODE', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION20), NULL)), (DECODE (INFORMATION_CATEGORY, 'CAREER_NODE', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION21), NULL)), (DECODE (INFORMATION_CATEGORY, 'CAREER_NODE', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION22), NULL)), INFORMATION30, (DECODE (INFORMATION_CATEGORY, 'CAREER_NODE', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION23), NULL)), (DECODE (INFORMATION_CATEGORY, 'TYPE_OF_SERVICE', INFORMATION1, 'TATIGKEIT', INFORMATION1, 'TARIFF_GROUP', INFORMATION1, 'TARIFF_CONTRACT', INFORMATION1, 'TARIFF_CLASS', INFORMATION7, 'SUB_CASE_GRP', INFORMATION1, 'REMUN_REGLT', INFORMATION1, 'PAY_GRADE', INFORMATION1, 'OPR_OPTS', INFORMATION1, 'OPR_JOB_FTR', INFORMATION1, 'OPR_JOB_DTLS', INFORMATION1, 'OPR_GROUP', INFORMATION1, 'LCOL_PAY_GRADES', INFORMATION1, 'JOB_GROUP', INFORMATION1, 'JOB_FTR', INFORMATION1, 'EMP_TYPE', INFORMATION1, 'CASE_GROUP', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'JOB_FTR', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION2), NULL)), INFORMATION2, (DECODE (INFORMATION_CATEGORY, 'TARIFF_CLASS', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1), NULL)), (DECODE (INFORMATION_CATEGORY, 'TARIFF_CLASS', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION3), NULL)), (DECODE (INFORMATION_CATEGORY, 'TARIFF_CLASS', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION4), NULL)), (DECODE (INFORMATION_CATEGORY, 'TARIFF_CLASS', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION5), NULL)), (DECODE (INFORMATION_CATEGORY, 'TARIFF_CLASS', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION6), NULL)), (DECODE (INFORMATION_CATEGORY, 'TARIFF_CLASS', FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION2), NULL)),  
 (DECODE (INFORMATION_CATEGORY,  
      'CAREER_NODE', INFORMATION_CATEGORY || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6 || '.' || INFORMATION7 || '.' || INFORMATION8 || '.' || INFORMATION9 || '.' || INFORMATION10 || '.' || INFORMATION11 || '.' || INFORMATION12 || '.' || INFORMATION13 || '.' || INFORMATION14 || '.' || INFORMATION15 || '.' || INFORMATION16 || '.' || INFORMATION17 || '.' || INFORMATION18 || '.' || INFORMATION19 || '.' || INFORMATION20 || '.' || INFORMATION21 || '.' || INFORMATION22 || '.' || INFORMATION30 || '.' || INFORMATION23,  
      'CASE_GROUP', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'EMP_TYPE', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'JOB_FTR', INFORMATION_CATEGORY || '.' || INFORMATION2 || '.' || INFORMATION1,  
      'JOB_GROUP', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'LCOL_PAY_GRADES', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'OPR_GROUP', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'OPR_JOB_DTLS', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'OPR_JOB_FTR', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'OPR_OPTS', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'PAY_GRADE', INFORMATION_CATEGORY || '.' || INFORMATION2 || '.' || INFORMATION1,  
      'REMUN_REGLT', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'SUB_CASE_GRP', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'TARIFF_CLASS', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6 || '.' || INFORMATION2 || '.' || INFORMATION7,  
      'TARIFF_CONTRACT', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'TARIFF_GROUP', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'TATIGKEIT', INFORMATION_CATEGORY || '.' || INFORMATION1,  
      'TYPE_OF_SERVICE', INFORMATION_CATEGORY || '.' || INFORMATION1, NULL)) 
 FROM PER_GEN_HIERARCHY_NODES

View Text - HTML Formatted

SELECT ROWID
, INFORMATION_CATEGORY
, INFORMATION3
, INFORMATION4
, INFORMATION5
, INFORMATION6
, INFORMATION7
, INFORMATION8
, INFORMATION9
, INFORMATION10
, (DECODE (INFORMATION_CATEGORY
, 'CAREER_NODE'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION11)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'CAREER_NODE'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION12)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'CAREER_NODE'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION13)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'CAREER_NODE'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION14)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'CAREER_NODE'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION15)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'CAREER_NODE'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION16)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'CAREER_NODE'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION17)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'CAREER_NODE'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION18)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'CAREER_NODE'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION19)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'CAREER_NODE'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION20)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'CAREER_NODE'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION21)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'CAREER_NODE'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION22)
, NULL))
, INFORMATION30
, (DECODE (INFORMATION_CATEGORY
, 'CAREER_NODE'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION23)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'TYPE_OF_SERVICE'
, INFORMATION1
, 'TATIGKEIT'
, INFORMATION1
, 'TARIFF_GROUP'
, INFORMATION1
, 'TARIFF_CONTRACT'
, INFORMATION1
, 'TARIFF_CLASS'
, INFORMATION7
, 'SUB_CASE_GRP'
, INFORMATION1
, 'REMUN_REGLT'
, INFORMATION1
, 'PAY_GRADE'
, INFORMATION1
, 'OPR_OPTS'
, INFORMATION1
, 'OPR_JOB_FTR'
, INFORMATION1
, 'OPR_JOB_DTLS'
, INFORMATION1
, 'OPR_GROUP'
, INFORMATION1
, 'LCOL_PAY_GRADES'
, INFORMATION1
, 'JOB_GROUP'
, INFORMATION1
, 'JOB_FTR'
, INFORMATION1
, 'EMP_TYPE'
, INFORMATION1
, 'CASE_GROUP'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'JOB_FTR'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION2)
, NULL))
, INFORMATION2
, (DECODE (INFORMATION_CATEGORY
, 'TARIFF_CLASS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION1)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'TARIFF_CLASS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION3)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'TARIFF_CLASS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION4)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'TARIFF_CLASS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION5)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'TARIFF_CLASS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION6)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'TARIFF_CLASS'
, FND_NUMBER.CANONICAL_TO_NUMBER(INFORMATION2)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'CAREER_NODE'
, INFORMATION_CATEGORY || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6 || '.' || INFORMATION7 || '.' || INFORMATION8 || '.' || INFORMATION9 || '.' || INFORMATION10 || '.' || INFORMATION11 || '.' || INFORMATION12 || '.' || INFORMATION13 || '.' || INFORMATION14 || '.' || INFORMATION15 || '.' || INFORMATION16 || '.' || INFORMATION17 || '.' || INFORMATION18 || '.' || INFORMATION19 || '.' || INFORMATION20 || '.' || INFORMATION21 || '.' || INFORMATION22 || '.' || INFORMATION30 || '.' || INFORMATION23
, 'CASE_GROUP'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'EMP_TYPE'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'JOB_FTR'
, INFORMATION_CATEGORY || '.' || INFORMATION2 || '.' || INFORMATION1
, 'JOB_GROUP'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'LCOL_PAY_GRADES'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'OPR_GROUP'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'OPR_JOB_DTLS'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'OPR_JOB_FTR'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'OPR_OPTS'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'PAY_GRADE'
, INFORMATION_CATEGORY || '.' || INFORMATION2 || '.' || INFORMATION1
, 'REMUN_REGLT'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'SUB_CASE_GRP'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'TARIFF_CLASS'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5 || '.' || INFORMATION6 || '.' || INFORMATION2 || '.' || INFORMATION7
, 'TARIFF_CONTRACT'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'TARIFF_GROUP'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'TATIGKEIT'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, 'TYPE_OF_SERVICE'
, INFORMATION_CATEGORY || '.' || INFORMATION1
, NULL))
FROM PER_GEN_HIERARCHY_NODES