Hi all
suggestion required.
iam getting this error. how to handle this or write this query.

SQL> CREATE MATERIALIZED VIEW MV_TMP_CALENDAR_DAYS AS
SELECT B.PORTFOLIO_GROUP_ID,
A.CAL_DAY_DT,
TRIM(A.CAL_MONTH_STR) REPORT_PERIOD,
TO_CHAR(CAL_DAY_DT, 'DD') -
(SELECT COUNT(*) FROM SOURCE_SYSTEM_HOLIDAYS B
WHERE TO_CHAR(A.CAL_DAY_DT, 'YYYYMM') = TO_CHAR(B.CAL_DATE, 'YYYYMM')
AND B.CAL_DATE <= A.CAL_DAY_DT) CURRENT_WORK_DAYS_NUM,
TO_CHAR(LAST_DAY(CAL_DAY_DT),'DD') -
(SELECT COUNT(*) FROM SOURCE_SYSTEM_HOLIDAYS B
WHERE TO_CHAR(A.CAL_DAY_DT, 'YYYYMM') = TO_CHAR(B.CAL_DATE, 'YYYYMM')) ALL_WORK_DAYS_NUM
FROM CCRT_CALENDAR_DIM A,
PORTFOLIO_GROUPS B;
(SELECT COUNT(*) FROM SOURCE_SYSTEM_HOLIDAYS B
*
ERROR at line 7:
ORA-22818: subquery expressions not allowed here

Thnx,