VIEW: APPS.HRBV_SHARED_TYPES_V

Source

View Text - Preformatted

SELECT SHTL.SHARED_TYPE_NAME, SHT.LOOKUP_TYPE, SHT.INFORMATION1, SHT.INFORMATION2, SHT.INFORMATION3, SHT.INFORMATION4, SHT.INFORMATION5, SHT.INFORMATION6, SHT.INFORMATION7, SHT.INFORMATION8, SHT.INFORMATION9, SHT.INFORMATION10, SHT.INFORMATION11, SHT.INFORMATION12, SHT.INFORMATION13, SHT.INFORMATION14, SHT.INFORMATION15, SHT.INFORMATION16, SHT.INFORMATION17, SHT.INFORMATION18, SHT.INFORMATION19, SHT.INFORMATION20, SHT.INFORMATION21, SHT.INFORMATION22, SHT.INFORMATION23, SHT.INFORMATION24, SHT.INFORMATION25, SHT.INFORMATION26, SHT.INFORMATION27, SHT.INFORMATION28, SHT.INFORMATION29, SHT.INFORMATION30, SHT.INFORMATION_CATEGORY, SHT.SHARED_TYPE_CODE, SHT.SYSTEM_TYPE_CD, HR_BIS.BIS_DECODE_LOOKUP(SHT.LOOKUP_TYPE,SHT.SYSTEM_TYPE_CD), SHT.SHARED_TYPE_ID, SHT.BUSINESS_GROUP_ID, SHT.LAST_UPDATE_DATE, SHT.LAST_UPDATED_BY, SHT.CREATED_BY, SHT.CREATION_DATE, CASE WHEN SHT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, SHT.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_SHARED_TYPES SHT, PER_SHARED_TYPES_TL SHTL WHERE SHT.SHARED_TYPE_ID = SHTL.SHARED_TYPE_ID AND SHTL.language = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT SHTL.SHARED_TYPE_NAME
, SHT.LOOKUP_TYPE
, SHT.INFORMATION1
, SHT.INFORMATION2
, SHT.INFORMATION3
, SHT.INFORMATION4
, SHT.INFORMATION5
, SHT.INFORMATION6
, SHT.INFORMATION7
, SHT.INFORMATION8
, SHT.INFORMATION9
, SHT.INFORMATION10
, SHT.INFORMATION11
, SHT.INFORMATION12
, SHT.INFORMATION13
, SHT.INFORMATION14
, SHT.INFORMATION15
, SHT.INFORMATION16
, SHT.INFORMATION17
, SHT.INFORMATION18
, SHT.INFORMATION19
, SHT.INFORMATION20
, SHT.INFORMATION21
, SHT.INFORMATION22
, SHT.INFORMATION23
, SHT.INFORMATION24
, SHT.INFORMATION25
, SHT.INFORMATION26
, SHT.INFORMATION27
, SHT.INFORMATION28
, SHT.INFORMATION29
, SHT.INFORMATION30
, SHT.INFORMATION_CATEGORY
, SHT.SHARED_TYPE_CODE
, SHT.SYSTEM_TYPE_CD
, HR_BIS.BIS_DECODE_LOOKUP(SHT.LOOKUP_TYPE
, SHT.SYSTEM_TYPE_CD)
, SHT.SHARED_TYPE_ID
, SHT.BUSINESS_GROUP_ID
, SHT.LAST_UPDATE_DATE
, SHT.LAST_UPDATED_BY
, SHT.CREATED_BY
, SHT.CREATION_DATE
, CASE WHEN SHT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, SHT.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_SHARED_TYPES SHT
, PER_SHARED_TYPES_TL SHTL
WHERE SHT.SHARED_TYPE_ID = SHTL.SHARED_TYPE_ID
AND SHTL.LANGUAGE = USERENV('LANG') WITH READ ONLY