DBA Data[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,