APPS.EDW_MTL_INVENTORY_LOC_M_SZ dependencies on HR_ALL_ORGANIZATION_UNITS

Line 26: hr_all_organization_units bg,

22: union all
23: -- Sub Inventory Level
24: select count(*) cnt
25: FROM mtl_secondary_inventories msi,
26: hr_all_organization_units bg,
27: hr_all_organization_units org,
28: mtl_parameters mp
29: WHERE msi.organization_id = mp.organization_id + 0
30: AND bg.organization_id = org.business_group_id

Line 27: hr_all_organization_units org,

23: -- Sub Inventory Level
24: select count(*) cnt
25: FROM mtl_secondary_inventories msi,
26: hr_all_organization_units bg,
27: hr_all_organization_units org,
28: mtl_parameters mp
29: WHERE msi.organization_id = mp.organization_id + 0
30: AND bg.organization_id = org.business_group_id
31: AND org.organization_id = mp.organization_id

Line 37: hr_all_organization_units bg,

33: union all
34: -- Inventory Organization Level
35: select count(*) cnt
36: FROM
37: hr_all_organization_units bg,
38: hr_all_organization_units org,
39: HR_ORGANIZATION_INFORMATION HOI,
40: mtl_parameters mp
41: WHERE bg.organization_id = org.business_group_id

Line 38: hr_all_organization_units org,

34: -- Inventory Organization Level
35: select count(*) cnt
36: FROM
37: hr_all_organization_units bg,
38: hr_all_organization_units org,
39: HR_ORGANIZATION_INFORMATION HOI,
40: mtl_parameters mp
41: WHERE bg.organization_id = org.business_group_id
42: AND org.organization_id = mp.organization_id

Line 212: hr_all_organization_units bg;

208: length('PLANT'),
209: -- NAME and Org_Name
210: 3*avg(nvl(vsize(bg.name), 0))
211: From
212: hr_all_organization_units bg;
213:
214: CURSOR c_7 IS -- Plant_Level (Inv Org)
215: Select
216: -- OPERATING_UNIT_FK needs to add instance_code