View: PER_SPECIAL_INFO_TYPES_V2

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_SPECIAL_INFO_TYPES_V2

View Text

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

Columns