VIEW: APPS.HRBV_HR_ORGANIZATION

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 ,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 ,oino.org_information1 operating_unit_id FROM hr_organization_units o ,hr_all_organization_units_tl oT ,hr_organization_information oinf ,hr_organization_information oino WHERE o.organization_id = oT.organization_id AND oT.language = userenv('LANG') AND o.organization_id = oinf.organization_id AND oinf.org_information_context = 'CLASS' AND oinf.org_information1 = 'HR_ORG' AND oinf.org_information2 = 'Y' AND o.organization_id = oino.organization_id (+) AND oino.org_information_context (+) = 'Exp Organization Defaults' 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
, 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
, OINO.ORG_INFORMATION1 OPERATING_UNIT_ID
FROM HR_ORGANIZATION_UNITS O
, HR_ALL_ORGANIZATION_UNITS_TL OT
, HR_ORGANIZATION_INFORMATION OINF
, HR_ORGANIZATION_INFORMATION OINO
WHERE O.ORGANIZATION_ID = OT.ORGANIZATION_ID
AND OT.LANGUAGE = USERENV('LANG')
AND O.ORGANIZATION_ID = OINF.ORGANIZATION_ID
AND OINF.ORG_INFORMATION_CONTEXT = 'CLASS'
AND OINF.ORG_INFORMATION1 = 'HR_ORG'
AND OINF.ORG_INFORMATION2 = 'Y'
AND O.ORGANIZATION_ID = OINO.ORGANIZATION_ID (+)
AND OINO.ORG_INFORMATION_CONTEXT (+) = 'EXP ORGANIZATION DEFAULTS' WITH READ ONLY