VIEW: APPS.PER_SPECIAL_INFO_TYPES_V2

Source

View Text - Preformatted

SELECT TYP.ROWID , TYP.SPECIAL_INFORMATION_TYPE_ID , TYP.BUSINESS_GROUP_ID , TYP.ID_FLEX_NUM , TYP.COMMENTS , TYP.ENABLED_FLAG , TYP.REQUEST_ID , TYP.PROGRAM_APPLICATION_ID , TYP.PROGRAM_ID , TYP.PROGRAM_UPDATE_DATE , TYP.ATTRIBUTE_CATEGORY , TYP.ATTRIBUTE1 , TYP.ATTRIBUTE2 , TYP.ATTRIBUTE3 , TYP.ATTRIBUTE4 , TYP.ATTRIBUTE5 , TYP.ATTRIBUTE6 , TYP.ATTRIBUTE7 , TYP.ATTRIBUTE8 , TYP.ATTRIBUTE9 , TYP.ATTRIBUTE10 , TYP.ATTRIBUTE11 , TYP.ATTRIBUTE12 , TYP.ATTRIBUTE13 , TYP.ATTRIBUTE14 , TYP.ATTRIBUTE15 , TYP.ATTRIBUTE16 , TYP.ATTRIBUTE17 , TYP.ATTRIBUTE18 , TYP.ATTRIBUTE19 , TYP.ATTRIBUTE20 , TYP.LAST_UPDATE_DATE , TYP.LAST_UPDATED_BY , TYP.LAST_UPDATE_LOGIN , TYP.CREATED_BY , TYP.CREATION_DATE , TYP.MULTIPLE_OCCURRENCES_FLAG , FND.ID_FLEX_STRUCTURE_NAME , FND.ENABLED_FLAG , DECODE(JOB.SPECIAL_INFORMATION_TYPE_ID,NULL,'N','Y') JOB_CATEGORY , DECODE(POS.SPECIAL_INFORMATION_TYPE_ID,NULL,'N','Y') POSITION_CATEGORY , DECODE(OTH.SPECIAL_INFORMATION_TYPE_ID,NULL,'N','Y') OTHER_CATEGORY , DECODE(SKI.SPECIAL_INFORMATION_TYPE_ID,NULL,'N','Y') SKILL_CATEGORY , DECODE(OSH.SPECIAL_INFORMATION_TYPE_ID,NULL,'N','Y') OSHA_CATEGORY , DECODE(ADA.SPECIAL_INFORMATION_TYPE_ID,NULL,'N','Y') ADA_CATEGORY FROM PER_SPECIAL_INFO_TYPES TYP, PER_SPECIAL_INFO_TYPE_USAGES JOB, PER_SPECIAL_INFO_TYPE_USAGES POS, PER_SPECIAL_INFO_TYPE_USAGES OTH, PER_SPECIAL_INFO_TYPE_USAGES SKI, PER_SPECIAL_INFO_TYPE_USAGES OSH, PER_SPECIAL_INFO_TYPE_USAGES ADA, FND_ID_FLEX_STRUCTURES_VL FND WHERE TYP.SPECIAL_INFORMATION_TYPE_ID = JOB.SPECIAL_INFORMATION_TYPE_ID (+) AND TYP.SPECIAL_INFORMATION_TYPE_ID = POS.SPECIAL_INFORMATION_TYPE_ID (+) AND TYP.SPECIAL_INFORMATION_TYPE_ID = OTH.SPECIAL_INFORMATION_TYPE_ID (+) AND TYP.SPECIAL_INFORMATION_TYPE_ID = SKI.SPECIAL_INFORMATION_TYPE_ID (+) AND TYP.SPECIAL_INFORMATION_TYPE_ID = OSH.SPECIAL_INFORMATION_TYPE_ID (+) AND TYP.SPECIAL_INFORMATION_TYPE_ID = ADA.SPECIAL_INFORMATION_TYPE_ID (+) AND JOB.SPECIAL_INFO_CATEGORY (+) = 'JOB' AND POS.SPECIAL_INFO_CATEGORY (+) = 'POS' AND OTH.SPECIAL_INFO_CATEGORY (+) = 'OTHER' AND SKI.SPECIAL_INFO_CATEGORY (+) = 'SKILL' AND OSH.SPECIAL_INFO_CATEGORY (+) = 'OSHA' AND ADA.SPECIAL_INFO_CATEGORY (+) = 'ADA' AND FND.ID_FLEX_CODE = 'PEA' AND FND.ID_FLEX_NUM = TYP.ID_FLEX_NUM

View Text - HTML Formatted

SELECT TYP.ROWID
, TYP.SPECIAL_INFORMATION_TYPE_ID
, TYP.BUSINESS_GROUP_ID
, TYP.ID_FLEX_NUM
, TYP.COMMENTS
, TYP.ENABLED_FLAG
, TYP.REQUEST_ID
, TYP.PROGRAM_APPLICATION_ID
, TYP.PROGRAM_ID
, TYP.PROGRAM_UPDATE_DATE
, TYP.ATTRIBUTE_CATEGORY
, TYP.ATTRIBUTE1
, TYP.ATTRIBUTE2
, TYP.ATTRIBUTE3
, TYP.ATTRIBUTE4
, TYP.ATTRIBUTE5
, TYP.ATTRIBUTE6
, TYP.ATTRIBUTE7
, TYP.ATTRIBUTE8
, TYP.ATTRIBUTE9
, TYP.ATTRIBUTE10
, TYP.ATTRIBUTE11
, TYP.ATTRIBUTE12
, TYP.ATTRIBUTE13
, TYP.ATTRIBUTE14
, TYP.ATTRIBUTE15
, TYP.ATTRIBUTE16
, TYP.ATTRIBUTE17
, TYP.ATTRIBUTE18
, TYP.ATTRIBUTE19
, TYP.ATTRIBUTE20
, TYP.LAST_UPDATE_DATE
, TYP.LAST_UPDATED_BY
, TYP.LAST_UPDATE_LOGIN
, TYP.CREATED_BY
, TYP.CREATION_DATE
, TYP.MULTIPLE_OCCURRENCES_FLAG
, FND.ID_FLEX_STRUCTURE_NAME
, FND.ENABLED_FLAG
, DECODE(JOB.SPECIAL_INFORMATION_TYPE_ID
, NULL
, 'N'
, 'Y') JOB_CATEGORY
, DECODE(POS.SPECIAL_INFORMATION_TYPE_ID
, NULL
, 'N'
, 'Y') POSITION_CATEGORY
, DECODE(OTH.SPECIAL_INFORMATION_TYPE_ID
, NULL
, 'N'
, 'Y') OTHER_CATEGORY
, DECODE(SKI.SPECIAL_INFORMATION_TYPE_ID
, NULL
, 'N'
, 'Y') SKILL_CATEGORY
, DECODE(OSH.SPECIAL_INFORMATION_TYPE_ID
, NULL
, 'N'
, 'Y') OSHA_CATEGORY
, DECODE(ADA.SPECIAL_INFORMATION_TYPE_ID
, NULL
, 'N'
, 'Y') ADA_CATEGORY
FROM PER_SPECIAL_INFO_TYPES TYP
, PER_SPECIAL_INFO_TYPE_USAGES JOB
, PER_SPECIAL_INFO_TYPE_USAGES POS
, PER_SPECIAL_INFO_TYPE_USAGES OTH
, PER_SPECIAL_INFO_TYPE_USAGES SKI
, PER_SPECIAL_INFO_TYPE_USAGES OSH
, PER_SPECIAL_INFO_TYPE_USAGES ADA
, FND_ID_FLEX_STRUCTURES_VL FND
WHERE TYP.SPECIAL_INFORMATION_TYPE_ID = JOB.SPECIAL_INFORMATION_TYPE_ID (+)
AND TYP.SPECIAL_INFORMATION_TYPE_ID = POS.SPECIAL_INFORMATION_TYPE_ID (+)
AND TYP.SPECIAL_INFORMATION_TYPE_ID = OTH.SPECIAL_INFORMATION_TYPE_ID (+)
AND TYP.SPECIAL_INFORMATION_TYPE_ID = SKI.SPECIAL_INFORMATION_TYPE_ID (+)
AND TYP.SPECIAL_INFORMATION_TYPE_ID = OSH.SPECIAL_INFORMATION_TYPE_ID (+)
AND TYP.SPECIAL_INFORMATION_TYPE_ID = ADA.SPECIAL_INFORMATION_TYPE_ID (+)
AND JOB.SPECIAL_INFO_CATEGORY (+) = 'JOB'
AND POS.SPECIAL_INFO_CATEGORY (+) = 'POS'
AND OTH.SPECIAL_INFO_CATEGORY (+) = 'OTHER'
AND SKI.SPECIAL_INFO_CATEGORY (+) = 'SKILL'
AND OSH.SPECIAL_INFO_CATEGORY (+) = 'OSHA'
AND ADA.SPECIAL_INFO_CATEGORY (+) = 'ADA'
AND FND.ID_FLEX_CODE = 'PEA'
AND FND.ID_FLEX_NUM = TYP.ID_FLEX_NUM