View: HRFV_BUSINESS_GROUPS

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_BUSINESS_GROUPS

View Text

SELECT OT.NAME BUSINESS_GROUP_NAME
, O.DATE_FROM DATE_FROM
, O.DATE_TO DATE_TO
, O.INTERNAL_ADDRESS_LINE INTERNAL_ADDRESS_LINE
, O.COMMENTS COMMENTS
, O2.ORG_INFORMATION1 DEFAULT_START_TIME
, O2.ORG_INFORMATION2 DEFAULT_END_TIME
, O2.ORG_INFORMATION3 WORKING_HOURS_AMOUNT
, HR_BIS.BIS_DECODE_LOOKUP('FREQUENCY'
, O2.ORG_INFORMATION4) WORKING_HOURS_FREQUENCY
, O3.ORG_INFORMATION1 BUSINESS_GROUP_SHORT_NAME
, HR_BIS.BIS_DECODE_LOOKUP('EMP_NUM_GEN_METHOD'
, O3.ORG_INFORMATION2) EMP_NUMBER_GENERATION_METHOD
, HR_BIS.BIS_DECODE_LOOKUP('APL_NUM_GEN_METHOD'
, O3.ORG_INFORMATION3) APL_NUMBER_GENERATION_METHOD
, O3.ORG_INFORMATION10 DEFAULT_CURRENCY_CODE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, O4.ORG_INFORMATION2) ENABLED_FLAG
, O3.ORG_INFORMATION9 LEGISLATION_CODE
, F1.ID_FLEX_STRUCTURE_NAME GRADE_STRUCTURE
, F2.ID_FLEX_STRUCTURE_NAME PEOPLE_GROUP_STRUCTURE
, F3.ID_FLEX_STRUCTURE_NAME JOB_STRUCTURE
, F4.ID_FLEX_STRUCTURE_NAME COST_ALLOCATION_STRUCTURE
, F5.ID_FLEX_STRUCTURE_NAME POSITION_STRUCTURE
, F6.ID_FLEX_STRUCTURE_NAME COMPETENCE_STRUCTURE
, O.ORGANIZATION_ID BUSINESS_GROUP_ID
, O3.ORG_INFORMATION7 COSTING_KF_STRUCTURE_ID
, O3.ORG_INFORMATION4 GRADE_KF_STRUCTURE_ID
, O3.ORG_INFORMATION6 JOB_KF_STRUCTURE_ID
, O.LOCATION_ID LOCATION_ID
, O3.ORG_INFORMATION5 PEOPLE_GROUP_KF_STRUCTURE_ID
, O3.ORG_INFORMATION8 POSITION_KF_STRUCTURE_ID
, O3.ORG_INFORMATION15 COMPETENCE_KF_STRUCTURE_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL OT
, HR_ALL_ORGANIZATION_UNITS O
, FND_ID_FLEX_STRUCTURES_TL F1
, FND_ID_FLEX_STRUCTURES_TL F2
, FND_ID_FLEX_STRUCTURES_TL F3
, FND_ID_FLEX_STRUCTURES_TL F4
, FND_ID_FLEX_STRUCTURES_TL F5
, FND_ID_FLEX_STRUCTURES_TL F6
, HR_ORGANIZATION_INFORMATION O2
, HR_ORGANIZATION_INFORMATION O3
, 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 O.ORGANIZATION_ID = O4.ORGANIZATION_ID
AND O3.ORG_INFORMATION_CONTEXT = 'BUSINESS GROUP INFORMATION'
AND O2.ORG_INFORMATION_CONTEXT (+) = 'WORK DAY INFORMATION'
AND O4.ORG_INFORMATION_CONTEXT = 'CLASS'
AND O4.ORG_INFORMATION1 = 'HR_BG'
AND O4.ORG_INFORMATION2 = 'Y'
AND O3.ORG_INFORMATION4 = F1.ID_FLEX_NUM
AND F1.ID_FLEX_CODE = 'GRD'
AND F1.LANGUAGE = USERENV('LANG')
AND O3.ORG_INFORMATION5 = F2.ID_FLEX_NUM
AND F2.ID_FLEX_CODE = 'GRP'
AND F2.LANGUAGE = USERENV('LANG')
AND O3.ORG_INFORMATION6 = F3.ID_FLEX_NUM
AND F3.ID_FLEX_CODE = 'JOB'
AND F3.LANGUAGE = USERENV('LANG')
AND O3.ORG_INFORMATION7 = F4.ID_FLEX_NUM
AND F4.ID_FLEX_CODE = 'COST'
AND F4.LANGUAGE = USERENV('LANG')
AND O3.ORG_INFORMATION8 = F5.ID_FLEX_NUM
AND F5.ID_FLEX_CODE = 'POS'
AND F5.LANGUAGE = USERENV('LANG')
AND O3.ORG_INFORMATION15 = F6.ID_FLEX_NUM
AND F6.ID_FLEX_CODE = 'CMP'
AND F6.LANGUAGE = USERENV('LANG') WITH READ ONLY

Columns