VIEW: APPS.PER_SPECIAL_INFO_TYPES_V

Source

View Text - Preformatted

SELECT X.ROWID , X.SPECIAL_INFORMATION_TYPE_ID , X.BUSINESS_GROUP_ID , X.ID_FLEX_NUM , F.ID_FLEX_STRUCTURE_NAME ,null , X.COMMENTS , X.ENABLED_FLAG , X.REQUEST_ID , X.PROGRAM_APPLICATION_ID , X.PROGRAM_ID , X.PROGRAM_UPDATE_DATE , X.ATTRIBUTE_CATEGORY , X.ATTRIBUTE1 , X.ATTRIBUTE2 , X.ATTRIBUTE3 , X.ATTRIBUTE4 , X.ATTRIBUTE5 , X.ATTRIBUTE6 , X.ATTRIBUTE7 , X.ATTRIBUTE8 , X.ATTRIBUTE9 , X.ATTRIBUTE10 , X.ATTRIBUTE11 , X.ATTRIBUTE12 , X.ATTRIBUTE13 , X.ATTRIBUTE14 , X.ATTRIBUTE15 , X.ATTRIBUTE16 , X.ATTRIBUTE17 , X.ATTRIBUTE18 , X.ATTRIBUTE19 , X.ATTRIBUTE20 , X.LAST_UPDATE_DATE , X.LAST_UPDATED_BY , X.LAST_UPDATE_LOGIN , X.CREATED_BY , X.CREATION_DATE FROM PER_SPECIAL_INFO_TYPES X , FND_ID_FLEX_STRUCTURES_VL F WHERE X.ID_FLEX_NUM = F.ID_FLEX_NUM AND F.ID_FLEX_CODE = 'PEA'

View Text - HTML Formatted

SELECT X.ROWID
, X.SPECIAL_INFORMATION_TYPE_ID
, X.BUSINESS_GROUP_ID
, X.ID_FLEX_NUM
, F.ID_FLEX_STRUCTURE_NAME
, NULL
, X.COMMENTS
, X.ENABLED_FLAG
, X.REQUEST_ID
, X.PROGRAM_APPLICATION_ID
, X.PROGRAM_ID
, X.PROGRAM_UPDATE_DATE
, X.ATTRIBUTE_CATEGORY
, X.ATTRIBUTE1
, X.ATTRIBUTE2
, X.ATTRIBUTE3
, X.ATTRIBUTE4
, X.ATTRIBUTE5
, X.ATTRIBUTE6
, X.ATTRIBUTE7
, X.ATTRIBUTE8
, X.ATTRIBUTE9
, X.ATTRIBUTE10
, X.ATTRIBUTE11
, X.ATTRIBUTE12
, X.ATTRIBUTE13
, X.ATTRIBUTE14
, X.ATTRIBUTE15
, X.ATTRIBUTE16
, X.ATTRIBUTE17
, X.ATTRIBUTE18
, X.ATTRIBUTE19
, X.ATTRIBUTE20
, X.LAST_UPDATE_DATE
, X.LAST_UPDATED_BY
, X.LAST_UPDATE_LOGIN
, X.CREATED_BY
, X.CREATION_DATE
FROM PER_SPECIAL_INFO_TYPES X
, FND_ID_FLEX_STRUCTURES_VL F
WHERE X.ID_FLEX_NUM = F.ID_FLEX_NUM
AND F.ID_FLEX_CODE = 'PEA'