21: locf.physical_location_id IS NULL)
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
197: avg(nvl(vsize(msi.creation_date), 0)),
198: -- LAST_UPDATE_DATE
199: avg(nvl(vsize(msi.last_update_date), 0))
200: From
201: mtl_secondary_inventories msi;
202:
203: CURSOR c_6 IS -- Plant Level (Inv Org)
204: Select
205: -- PLANT_PK, it's org_code and instance_code