VIEW: APPS.HR_ORG_UNITS_NO_JOIN

Source

View Text - Preformatted

SELECT ORGANIZATION_ID , BUSINESS_GROUP_ID , COST_ALLOCATION_KEYFLEX_ID , LOCATION_ID , NAME , SOFT_CODING_KEYFLEX_ID , DATE_FROM , COMMENTS , DATE_TO , INTERNAL_EXTERNAL_FLAG , INTERNAL_ADDRESS_LINE , TYPE , REQUEST_ID , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE20 , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN , CREATED_BY , CREATION_DATE FROM HR_ALL_ORGANIZATION_UNITS HAO WHERE DECODE(HR_SECURITY.VIEW_ALL ,'Y', 'TRUE', HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS',HAO.ORGANIZATION_ID)) = 'TRUE' and decode(hr_general.get_xbg_profile,'Y', hao.business_group_id , hr_general.get_business_group_id) = hao.business_group_id

View Text - HTML Formatted

SELECT ORGANIZATION_ID
, BUSINESS_GROUP_ID
, COST_ALLOCATION_KEYFLEX_ID
, LOCATION_ID
, NAME
, SOFT_CODING_KEYFLEX_ID
, DATE_FROM
, COMMENTS
, DATE_TO
, INTERNAL_EXTERNAL_FLAG
, INTERNAL_ADDRESS_LINE
, TYPE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR_ALL_ORGANIZATION_UNITS HAO
WHERE DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS'
, HAO.ORGANIZATION_ID)) = 'TRUE'
AND DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, HAO.BUSINESS_GROUP_ID
, HR_GENERAL.GET_BUSINESS_GROUP_ID) = HAO.BUSINESS_GROUP_ID