VIEW: APPS.HRFV_OPERATING_UNITS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,orgT.name operating_unit_name ,org.date_from date_from ,org.date_to date_to ,hr_bis.bis_decode_lookup('ORG_TYPE',org.type) organization_type ,org.internal_address_line internal_address ,org.comments comments ,'' legal_entity_name ,locT.location_code location_name ,'_DF:PER:PER_ORGANIZATION_UNITS:org' ,org.business_group_id business_group_id ,'' legal_entity_id ,org.location_id location_id ,org.organization_id operating_units_id ,oi2.org_information5 short_code ,oi2.org_information6 usable_flag FROM hr_locations_all_tl locT ,hr_organization_units org ,hr_all_organization_units_tl orgT ,hr_organization_information oi2 ,hr_organization_information oi3 ,hr_all_organization_units_tl bgrT WHERE org.organization_id = oi2.organization_id AND org.organization_id = oi3.organization_id AND oi2.org_information_context = 'Operating Unit Information' AND oi3.org_information_context = 'CLASS' AND oi3.org_information1 = 'OPERATING_UNIT' AND oi3.org_information2 = 'Y' AND org.location_id = locT.location_id (+) AND locT.language (+) = userenv('LANG') AND org.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND org.organization_id = orgT.organization_id AND orgT.language = userenv('LANG') AND org.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, org.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, ORGT.NAME OPERATING_UNIT_NAME
, ORG.DATE_FROM DATE_FROM
, ORG.DATE_TO DATE_TO
, HR_BIS.BIS_DECODE_LOOKUP('ORG_TYPE'
, ORG.TYPE) ORGANIZATION_TYPE
, ORG.INTERNAL_ADDRESS_LINE INTERNAL_ADDRESS
, ORG.COMMENTS COMMENTS
, '' LEGAL_ENTITY_NAME
, LOCT.LOCATION_CODE LOCATION_NAME
, '_DF:PER:PER_ORGANIZATION_UNITS:ORG'
, ORG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, '' LEGAL_ENTITY_ID
, ORG.LOCATION_ID LOCATION_ID
, ORG.ORGANIZATION_ID OPERATING_UNITS_ID
, OI2.ORG_INFORMATION5 SHORT_CODE
, OI2.ORG_INFORMATION6 USABLE_FLAG
FROM HR_LOCATIONS_ALL_TL LOCT
, HR_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ORGANIZATION_INFORMATION OI2
, HR_ORGANIZATION_INFORMATION OI3
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE ORG.ORGANIZATION_ID = OI2.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = OI3.ORGANIZATION_ID
AND OI2.ORG_INFORMATION_CONTEXT = 'OPERATING UNIT INFORMATION'
AND OI3.ORG_INFORMATION_CONTEXT = 'CLASS'
AND OI3.ORG_INFORMATION1 = 'OPERATING_UNIT'
AND OI3.ORG_INFORMATION2 = 'Y'
AND ORG.LOCATION_ID = LOCT.LOCATION_ID (+)
AND LOCT.LANGUAGE (+) = USERENV('LANG')
AND ORG.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ORG.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND ORG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ORG.BUSINESS_GROUP_ID) WITH READ ONLY