VIEW: APPS.HR_ORGANIZATION_UNITS

Source

View Text - Preformatted

SELECT hao.organization_id , hao.rowid , hao.business_group_id , hao.cost_allocation_keyflex_id , hao.location_id , hao.soft_coding_keyflex_id , hao.date_from , haotl.name , hao.comments , hao.date_to , hao.internal_external_flag , hao.internal_address_line , hao.type, hao.request_id , hao.program_application_id , hao.program_id , hao.program_update_date , hao.attribute_category , hao.attribute1 , hao.attribute2 , hao.attribute3 , hao.attribute4 , hao.attribute5 , hao.attribute6 , hao.attribute7 , hao.attribute8 , hao.attribute9 , hao.attribute10 , hao.attribute11 , hao.attribute12 , hao.attribute13 , hao.attribute14 , hao.attribute15 , hao.attribute16 , hao.attribute17 , hao.attribute18 , hao.attribute19 , hao.attribute20 , hao.last_update_date , hao.last_updated_by , hao.last_update_login , hao.created_by , hao.creation_date , hao.object_version_number , hao.attribute21 , hao.attribute22 , hao.attribute23 , hao.attribute24 , hao.attribute25 , hao.attribute26 , hao.attribute27 , hao.attribute28 , hao.attribute29 , hao.attribute30 FROM HR_ALL_ORGANIZATION_UNITS HAO, HR_ALL_ORGANIZATION_UNITS_TL HAOTL WHERE DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', HAOTL.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 AND HAO.ORGANIZATION_ID = HAOTL.ORGANIZATION_ID AND HAOTL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT HAO.ORGANIZATION_ID
, HAO.ROWID
, HAO.BUSINESS_GROUP_ID
, HAO.COST_ALLOCATION_KEYFLEX_ID
, HAO.LOCATION_ID
, HAO.SOFT_CODING_KEYFLEX_ID
, HAO.DATE_FROM
, HAOTL.NAME
, HAO.COMMENTS
, HAO.DATE_TO
, HAO.INTERNAL_EXTERNAL_FLAG
, HAO.INTERNAL_ADDRESS_LINE
, HAO.TYPE
, HAO.REQUEST_ID
, HAO.PROGRAM_APPLICATION_ID
, HAO.PROGRAM_ID
, HAO.PROGRAM_UPDATE_DATE
, HAO.ATTRIBUTE_CATEGORY
, HAO.ATTRIBUTE1
, HAO.ATTRIBUTE2
, HAO.ATTRIBUTE3
, HAO.ATTRIBUTE4
, HAO.ATTRIBUTE5
, HAO.ATTRIBUTE6
, HAO.ATTRIBUTE7
, HAO.ATTRIBUTE8
, HAO.ATTRIBUTE9
, HAO.ATTRIBUTE10
, HAO.ATTRIBUTE11
, HAO.ATTRIBUTE12
, HAO.ATTRIBUTE13
, HAO.ATTRIBUTE14
, HAO.ATTRIBUTE15
, HAO.ATTRIBUTE16
, HAO.ATTRIBUTE17
, HAO.ATTRIBUTE18
, HAO.ATTRIBUTE19
, HAO.ATTRIBUTE20
, HAO.LAST_UPDATE_DATE
, HAO.LAST_UPDATED_BY
, HAO.LAST_UPDATE_LOGIN
, HAO.CREATED_BY
, HAO.CREATION_DATE
, HAO.OBJECT_VERSION_NUMBER
, HAO.ATTRIBUTE21
, HAO.ATTRIBUTE22
, HAO.ATTRIBUTE23
, HAO.ATTRIBUTE24
, HAO.ATTRIBUTE25
, HAO.ATTRIBUTE26
, HAO.ATTRIBUTE27
, HAO.ATTRIBUTE28
, HAO.ATTRIBUTE29
, HAO.ATTRIBUTE30
FROM HR_ALL_ORGANIZATION_UNITS HAO
, HR_ALL_ORGANIZATION_UNITS_TL HAOTL
WHERE DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS'
, HAOTL.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
AND HAO.ORGANIZATION_ID = HAOTL.ORGANIZATION_ID
AND HAOTL.LANGUAGE = USERENV('LANG')