MATERIALIZED VIEW: APPS.DDR_R_CLNDR_MNTH_DN_MV

Source

SELECT "A4".ROWID "GMNTH_ROWID","A3".ROWID "GQTR_ROWID","A2".ROWID "GYR_ROWID","A1".ROWID "MNTH_TRANS_ROWID","A1"."MFG_ORG_CD"||'-'||'CLNDR' "CLNDR_DESC","A1"."CLNDR_CD" "CLNDR_CD","A1"."CLNDR_TYP" "CLNDR_TYPE","A4"."CLNDR_MNTH_ID" "CLNDR_MNTH_ID","A4"."MNTH_DESC" "MNTH_DESC","A4"."MNTH_CD" "MNTH_CD","A4"."MNTH_STRT_DT" "MNTH_STRT_DT","A4"."MNTH_END_DT" "MNTH_END_DT","A4"."MNTH_NBR" "MNTH_NBR","A4"."MNTH_TIMESPN" "MNTH_TIMESPN","A1"."LAST_YR_THIS_MNTH_ID" "LAST_YR_THIS_MNTH_ID","A1"."LAST_MNTH_THIS_YR_ID" "LAST_MNTH_THIS_YR_ID","A3"."CLNDR_QTR_ID" "CLNDR_QTR_ID","A3"."QTR_DESC" "QTR_DESC","A3"."QTR_NBR" "QTR_NBR","A3"."QTR_CD" "QTR_CD","A3"."QTR_STRT_DT" "QTR_STRT_DT","A3"."QTR_END_DT" "QTR_END_DT","A3"."QTR_TIMESPN" "QTR_TIMESPN","A2"."CLNDR_YR_ID" "CLNDR_YR_ID","A2"."YR_DESC" "YR_DESC","A2"."YR_NBR" "YR_NBR","A2"."YR_CD" "YR_CD","A2"."YR_STRT_DT" "YR_STRT_DT","A2"."YR_END_DT" "YR_END_DT","A2"."YR_TIMESPN" "YR_TIMESPN" FROM "DDR"."DDR_R_CLNDR_MNTH" "A4","DDR"."DDR_R_CLNDR_QTR" "A3","DDR"."DDR_R_CLNDR_YR" "A2","DDR"."DDR_R_MNTH_TRANS" "A1" WHERE "A4"."CLNDR_QTR_ID"="A3"."CLNDR_QTR_ID" AND "A3"."CLNDR_YR_ID"="A2"."CLNDR_YR_ID" AND "A4"."CLNDR_MNTH_ID"="A1"."MNTH_ID" AND "A1"."CLNDR_CD"='CLNDR'