APPS.EDW_OPI_LOT_MOPM_SZ dependencies on EDW_LOCAL_INSTANCE

Line 40: from edw_local_instance;

36: x_last_update_date NUMBER := x_date;
37: x_creation_date NUMBER := x_date;
38: cursor CUR_INSTANCE_SIZE is
39: select avg(nvl(vsize(instance_code),0))
40: from edw_local_instance;
41:
42: CURSOR CUR_OPM_LOT_SIZES IS
43: SELECT avg(nvl(vsize(LT.LOT_NO),0)) LOT_NO,
44: avg(nvl(vsize(LT.SUBLOT_NO),0)) SUBLOT_NO,