5: p_to_date DATE,
6: p_num_rows OUT NOCOPY NUMBER) IS
7: CURSOR c_cnt_rows IS
8: select count(*) cnt
9: FROM WIP_LINES WL,
10: MTL_PARAMETERS MP
11: where WL.ORGANIZATION_ID = MP.ORGANIZATION_ID
12: and wl.last_update_date between p_from_date and p_to_date;
13:
31: cursor c_wl is
32: select avg(nvl(vsize(wl.line_id),0)) line_id,
33: avg(nvl(vsize(wl.line_code),0)) code,
34: avg(nvl(vsize(wl.description),0)) des
35: from wip_lines wl
36: where wl.last_update_date between p_from_date and p_to_date;
37:
38: CURSOR c_org IS
39: SELECT avg(nvl(Vsize(organization_id), 0)) org_id,