APPS.EDW_MTL_INVENTORY_LOC_M_SZ dependencies on HR_ORGANIZATION_UNITS

Line 15: hr_organization_units hou

11: -- Locator Level
12: select count(*) cnt
13: FROM mtl_item_locations_kfv locf,
14: mtl_parameters mp,
15: hr_organization_units hou
16: where
17: locf.last_update_date between p_from_date and p_to_date AND
18: locf.organization_id = mp.organization_id AND
19: hou.organization_id=mp.organization_id AND

Line 173: hr_organization_units hou;

169: Select
170: -- Org_Name
171: avg(nvl(vsize(hou.name), 0))
172: From
173: hr_organization_units hou;
174:
175:
176: CURSOR c_4 IS -- Instance_Code used in all Levels: Locator, Stock_Room, Plant
177: SELECT