APPS.EDW_MTL_INVENTORY_LOC_M_SZ dependencies on MTL_ITEM_LOCATIONS_KFV

Line 13: FROM mtl_item_locations_kfv locf,

9: FROM
10: (
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

Line 152: mtl_item_locations_kfv locf;

148: avg(nvl(vsize(locf.inventory_location_id), 0)),
149: -- Organization_ID
150: avg(nvl(vsize(locf.organization_id), 0))
151: From
152: mtl_item_locations_kfv locf;
153:
154:
155: CURSOR c_2 IS -- Organization_Code used in all levels: Locator, Stock_Room, Plant
156: -- and Plant's Creation and Last_Update_Date