428: avg(nvl(vsize(NULL), 0)) +
429: avg(nvl(vsize(TO_DATE(NULL)), 0)) +
430: 16
431: FROM
432: AS_INTEREST_CODES_V CD ,
433: AS_INTEREST_TYPES_V INTYP ,
434: EDW_LOCAL_INSTANCE INST
435: WHERE
436: CD.INTEREST_TYPE_ID = INTYP.INTEREST_TYPE_ID
463: avg(nvl(vsize(NULL), 0)) +
464: avg(nvl(vsize(TO_DATE(NULL)), 0)) +
465: 16
466: FROM
467: AS_INTEREST_CODES_V SCD ,
468: AS_INTEREST_CODES_V PCD ,
469: AS_INTEREST_TYPES_V INTYP ,
470: EDW_LOCAL_INSTANCE INST
471: WHERE
464: avg(nvl(vsize(TO_DATE(NULL)), 0)) +
465: 16
466: FROM
467: AS_INTEREST_CODES_V SCD ,
468: AS_INTEREST_CODES_V PCD ,
469: AS_INTEREST_TYPES_V INTYP ,
470: EDW_LOCAL_INSTANCE INST
471: WHERE
472: SCD.PARENT_INTEREST_CODE_ID = PCD.INTEREST_CODE_ID