VIEW: APPS.HRFV_HR_ORGANIZATIONS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,oT.name organization_name ,o.date_from date_from ,o.date_to date_to ,o.internal_address_line internal_address ,o.comments comments ,o2.org_information1 default_start_time ,o2.org_information2 default_end_time ,TO_NUMBER(o2.org_information3) working_hours_amount ,o2.org_information4 working_hours_frequency ,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 ,lT.location_code location_name ,'_DF:PER:PER_ORGANIZATION_UNITS:o' ,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 ,o4.org_information1 operating_unit_id ,ot1.name operating_unit_name FROM hr_locations_all_tl lT ,hr_all_organization_units o ,hr_all_organization_units_tl oT ,hr_organization_information o2 ,hr_organization_information o3 ,hr_all_organization_units_tl bgrT ,hr_all_organization_units_tl ot1 ,hr_organization_information o4 WHERE o.organization_id = oT.organization_id AND oT.language = userenv('LANG') AND o.organization_id = o2.organization_id (+) AND o.organization_id = o3.organization_id AND o2.org_information_context (+) = 'Work Day Information' AND o3.org_information_context = 'CLASS' AND o3.org_information1 = 'HR_ORG' AND o3.org_information2 = 'Y' AND o.location_id = lT.location_id(+) AND lT.language (+) = userenv('LANG') AND o.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND o.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, o.business_group_id) AND o.organization_id = o4.organization_id (+) AND o4.org_information_context (+) = 'Exp Organization Defaults' AND o4.org_information1 = ot1.organization_id (+) AND ot1.language (+) = userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, OT.NAME ORGANIZATION_NAME
, O.DATE_FROM DATE_FROM
, O.DATE_TO DATE_TO
, O.INTERNAL_ADDRESS_LINE INTERNAL_ADDRESS
, O.COMMENTS COMMENTS
, O2.ORG_INFORMATION1 DEFAULT_START_TIME
, O2.ORG_INFORMATION2 DEFAULT_END_TIME
, TO_NUMBER(O2.ORG_INFORMATION3) WORKING_HOURS_AMOUNT
, O2.ORG_INFORMATION4 WORKING_HOURS_FREQUENCY
, 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
, LT.LOCATION_CODE LOCATION_NAME
, '_DF:PER:PER_ORGANIZATION_UNITS:O'
, 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
, O4.ORG_INFORMATION1 OPERATING_UNIT_ID
, OT1.NAME OPERATING_UNIT_NAME
FROM HR_LOCATIONS_ALL_TL LT
, HR_ALL_ORGANIZATION_UNITS O
, HR_ALL_ORGANIZATION_UNITS_TL OT
, HR_ORGANIZATION_INFORMATION O2
, HR_ORGANIZATION_INFORMATION O3
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_ORGANIZATION_UNITS_TL OT1
, HR_ORGANIZATION_INFORMATION O4
WHERE O.ORGANIZATION_ID = OT.ORGANIZATION_ID
AND OT.LANGUAGE = USERENV('LANG')
AND O.ORGANIZATION_ID = O2.ORGANIZATION_ID (+)
AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID
AND O2.ORG_INFORMATION_CONTEXT (+) = 'WORK DAY INFORMATION'
AND O3.ORG_INFORMATION_CONTEXT = 'CLASS'
AND O3.ORG_INFORMATION1 = 'HR_ORG'
AND O3.ORG_INFORMATION2 = 'Y'
AND O.LOCATION_ID = LT.LOCATION_ID(+)
AND LT.LANGUAGE (+) = USERENV('LANG')
AND O.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND O.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, O.BUSINESS_GROUP_ID)
AND O.ORGANIZATION_ID = O4.ORGANIZATION_ID (+)
AND O4.ORG_INFORMATION_CONTEXT (+) = 'EXP ORGANIZATION DEFAULTS'
AND O4.ORG_INFORMATION1 = OT1.ORGANIZATION_ID (+)
AND OT1.LANGUAGE (+) = USERENV('LANG') WITH READ ONLY