MATERIALIZED VIEW: APPS.DDR_R_BASE_DAY_DN_MV

Source

SELECT "A8".ROWID "DAY_ROWID","A7".ROWID "BDAY_ROWID","A6".ROWID "BWK_ROWID","A5".ROWID "BMNTH_ROWID","A4".ROWID "BQTR_ROWID","A3".ROWID "BYR_ROWID","A2".ROWID "CAL_ROWID","A1".ROWID "DAY_TRANS_ROWID","A3"."MFG_ORG_CD" "MFG_ORG_CD","A3"."CLNDR_CD" "CLNDR_CD","A2"."ORG_CD" "ORG_CD","A2"."CLNDR_DESC" "CLNDR_DESC","A7"."DAY_CD" "DAY_CD","A7"."BASE_DAY_ID" "BASE_DAY_ID","A8"."CLNDR_DT" "CLNDR_DT","A8"."CLNDR_DT_DESC" "CLNDR_DT_DESC","A7"."DAY_OF_YR" "DAY_OF_YR","A7"."WKEND_IND" "WKEND_IND","A1"."LAST_YR_THIS_DAY_CD" "LAST_YR_THIS_DAY_CD","A1"."LAST_DAY_THIS_YR_CD" "LAST_DAY_THIS_YR_CD","A6"."BSNS_WK_ID" "BSNS_WK_ID","A6"."WK_DESC" "WK_DESC","A6"."WK_CD" "WK_CD","A6"."WK_NBR" "WK_NBR","A6"."WK_STRT_DT" "WK_STRT_DT","A6"."WK_END_DT" "WK_END_DT","A6"."WK_TIMESPN" "WK_TIMESPN","A5"."BSNS_MNTH_ID" "BSNS_MNTH_ID","A5"."MNTH_DESC" "MNTH_DESC","A5"."MNTH_CD" "MNTH_CD","A5"."MNTH_STRT_DT" "MNTH_STRT_DT","A5"."MNTH_END_DT" "MNTH_END_DT","A5"."MNTH_NBR" "MNTH_NBR","A5"."MNTH_TIMESPN" "MNTH_TIMESPN","A4"."BSNS_QTR_ID" "BSNS_QTR_ID","A4"."QTR_DESC" "QTR_DESC","A4"."QTR_CD" "QTR_CD","A4"."QTR_NBR" "QTR_NBR","A4"."QTR_STRT_DT" "QTR_STRT_DT","A4"."QTR_END_DT" "QTR_END_DT","A4"."QTR_TIMESPN" "QTR_TIMESPN","A3"."BSNS_YR_ID" "BSNS_YR_ID","A3"."YR_DESC" "YR_DESC","A3"."YR_NBR" "YR_NBR","A3"."YR_CD" "YR_CD","A3"."YR_STRT_DT" "YR_STRT_DT","A3"."YR_END_DT" "YR_END_DT","A3"."YR_TIMESPN" "YR_TIMESPN" FROM "DDR"."DDR_R_DAY" "A8","DDR"."DDR_R_BASE_DAY" "A7","DDR"."DDR_R_BSNS_WK" "A6","DDR"."DDR_R_BSNS_MNTH" "A5","DDR"."DDR_R_BSNS_QTR" "A4","DDR"."DDR_R_BSNS_YR" "A3","DDR"."DDR_R_CLNDR" "A2","DDR"."DDR_R_DAY_TRANS" "A1" WHERE "A7"."DAY_CD"="A8"."DAY_CD" AND "A7"."WK_ID"="A6"."BSNS_WK_ID" AND "A7"."CLNDR_TYP"='BSNS' AND "A6"."BSNS_MNTH_ID"="A5"."BSNS_MNTH_ID" AND "A5"."BSNS_QTR_ID"="A4"."BSNS_QTR_ID" AND "A4"."BSNS_YR_ID"="A3"."BSNS_YR_ID" AND "A2"."MFG_ORG_CD"="A3"."MFG_ORG_CD" AND "A2"."CLNDR_CD"="A3"."CLNDR_CD" AND "A7"."DAY_CD"="A1"."DAY_CD" AND "A7"."CLNDR_CD"="A1"."CLNDR_CD"