MATERIALIZED VIEW: APPS.DDR_R_BSNS_WK_DN_MV

Source

SELECT "A6".ROWID "BWK_ROWID","A5".ROWID "BMNTH_ROWID","A4".ROWID "BQTR_ROWID","A3".ROWID "BYR_ROWID","A2".ROWID "CAL_ROWID","A1".ROWID "WK_TRANS_ROWID","A3"."MFG_ORG_CD" "MFG_ORG_CD","A3"."CLNDR_CD" "CLNDR_CD","A2"."ORG_CD" "ORG_CD","A2"."CLNDR_DESC" "CLNDR_DESC","A6"."BSNS_WK_ID" "BSNS_WK_ID","A6"."WK_DESC" "WK_DESC","A6"."WK_NBR" "WK_NBR","A6"."WK_CD" "WK_CD","A6"."WK_STRT_DT" "WK_STRT_DT","A6"."WK_END_DT" "WK_END_DT","A6"."WK_TIMESPN" "WK_TIMESPN","A1"."LAST_YR_THIS_WK_ID" "LAST_YR_THIS_WK_ID","A1"."LAST_WK_THIS_YR_ID" "LAST_WK_THIS_YR_ID","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_NBR" "QTR_NBR","A4"."QTR_CD" "QTR_CD","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_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_WK_TRANS" "A1" WHERE "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 "A6"."BSNS_WK_ID"="A1"."WK_ID" AND "A6"."CLNDR_CD"="A1"."CLNDR_CD"