[Home] [Help]
APPS.OPI_EDW_COGS_FOPM_SZ dependencies on EDW_LOCAL_INSTANCE
Line 69: FROM EDW_LOCAL_INSTANCE ;
65:
66: CURSOR c_instance IS
67: SELECT
68: avg(nvl(vsize(instance_code), 0))
69: FROM EDW_LOCAL_INSTANCE ;
70:
71: CURSOR c_other_dtl IS
72: SELECT AVG(Nvl(Vsize(EDW_TIME_PKG.CAL_DAY_FK(Sysdate, SOB_ID) ),0)) date_fk,
73: AVG(NVL(VSIZE(SOB_ID),0)) SOB_ID,