VIEW: APPS.HRFV_BUSINESS_GROUPS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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