DBA Data[Home] [Help]

APPS.EDW_ORGANIZATION_M_SIZING dependencies on HR_ORGANIZATION_INFORMATION

Line 19: ,hr_organization_information oi1

15: SELECT COUNT(*) total
16: FROM
17: hr_all_organization_units org
18: ,per_business_groups bgr
19: ,hr_organization_information oi1
20: ,hr_all_organization_units ou
21: ,mtl_parameters mp
22: ,hr_organization_information oi2
23: ,hri_primary_hrchys tree

Line 22: ,hr_organization_information oi2

18: ,per_business_groups bgr
19: ,hr_organization_information oi1
20: ,hr_all_organization_units ou
21: ,mtl_parameters mp
22: ,hr_organization_information oi2
23: ,hri_primary_hrchys tree
24: WHERE org.business_group_id = bgr.business_group_id
25: AND org.organization_id = oi1.organization_id (+)
26: AND oi1.org_information_context (+) = 'Accounting Information'