APPS.OPI_EDW_OPI_PRDL_M_SZ dependencies on MTL_PARAMETERS

Line 10: MTL_PARAMETERS MP

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:
14: BEGIN

Line 41: FROM mtl_parameters;

37:
38: CURSOR c_org IS
39: SELECT avg(nvl(Vsize(organization_id), 0)) org_id,
40: avg(nvl(Vsize(organization_code), 0)) org_code
41: FROM mtl_parameters;
42:
43: CURSOR c_instance IS
44: SELECT
45: avg(nvl(vsize(instance_code), 0))