VIEW: APPS.HRBV_ORGANIZATION_UNIT

Source

View Text - Preformatted

SELECT oT.name organization_name ,o.date_from date_from ,o.date_to date_to ,o.internal_address_line internal_address ,o.comments comments ,hr_bis.bis_decode_lookup('INTL_EXTL',o.internal_external_flag) internal_external_flag ,hr_bis.bis_decode_lookup('ORG_TYPE' ,o.type) organization_type ,'_DF:PER:PER_ORGANIZATION_UNITS:o' ,o.internal_external_flag internal_external_flag_code ,o.type type_code ,hr_api.return_legislation_code(o.business_group_id) legislation_code ,o.business_group_id business_group_id ,o.cost_allocation_keyflex_id cost_allocation_keyflex_id ,o.location_id location_id ,o.organization_id organization_id ,o.soft_coding_keyflex_id soft_coding_keyflex_id ,o.last_update_date last_update_date ,o.last_updated_by last_updated_by ,o.last_update_login last_update_login ,o.created_by created_by ,o.creation_date creation_date ,CASE WHEN (o.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, o.business_group_id)) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM hr_organization_units o ,hr_all_organization_units_tl oT WHERE o.organization_id = oT.organization_id AND oT.language = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT OT.NAME ORGANIZATION_NAME
, O.DATE_FROM DATE_FROM
, O.DATE_TO DATE_TO
, O.INTERNAL_ADDRESS_LINE INTERNAL_ADDRESS
, O.COMMENTS COMMENTS
, HR_BIS.BIS_DECODE_LOOKUP('INTL_EXTL'
, O.INTERNAL_EXTERNAL_FLAG) INTERNAL_EXTERNAL_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('ORG_TYPE'
, O.TYPE) ORGANIZATION_TYPE
, '_DF:PER:PER_ORGANIZATION_UNITS:O'
, O.INTERNAL_EXTERNAL_FLAG INTERNAL_EXTERNAL_FLAG_CODE
, O.TYPE TYPE_CODE
, HR_API.RETURN_LEGISLATION_CODE(O.BUSINESS_GROUP_ID) LEGISLATION_CODE
, O.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, O.COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID
, O.LOCATION_ID LOCATION_ID
, O.ORGANIZATION_ID ORGANIZATION_ID
, O.SOFT_CODING_KEYFLEX_ID SOFT_CODING_KEYFLEX_ID
, O.LAST_UPDATE_DATE LAST_UPDATE_DATE
, O.LAST_UPDATED_BY LAST_UPDATED_BY
, O.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, O.CREATED_BY CREATED_BY
, O.CREATION_DATE CREATION_DATE
, CASE WHEN (O.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, O.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM HR_ORGANIZATION_UNITS O
, HR_ALL_ORGANIZATION_UNITS_TL OT
WHERE O.ORGANIZATION_ID = OT.ORGANIZATION_ID
AND OT.LANGUAGE = USERENV('LANG') WITH READ ONLY