VIEW: APPS.DDR_R_CLNDR_DAY_DN_MV#

Source

View Text - Preformatted

SELECT "A6".ROWID "DAY_ROWID",
    "A5".ROWID "GWK_ROWID",
    "A4".ROWID "GMNTH_ROWID",
    "A3".ROWID "GQTR_ROWID",
    "A2".ROWID "GYR_ROWID",
    "A1".ROWID "DAY_TRANS_ROWID",
    "A1"."MFG_ORG_CD"
    ||'-'
    ||'CLNDR' "CLNDR_DESC",
    "A1"."CLNDR_CD" "CLNDR_CD",
    "A1"."CLNDR_TYP" "CLNDR_TYPE",
    "A6"."DAY_CD" "DAY_CD",
    "A6"."DAY_OF_YR" ,
    "A6"."WK_DAY" ,
    "A6"."CLNDR_DT" "CLNDR_DT",
    "A6"."CLNDR_DT_DESC" "CLNDR_DT_DESC",
    "A1"."LAST_YR_THIS_DAY_CD" "LAST_YR_THIS_DAY_CD",
    "A1"."LAST_DAY_THIS_YR_CD" "LAST_DAY_THIS_YR_CD",
    "A5"."CLNDR_WK_ID" "CLNDR_WK_ID",
    "A5"."WK_DESC" "WK_DESC",
    "A5"."WK_CD" "WK_CD",
    "A5"."WK_NBR" "WK_NBR",
    "A5"."WK_STRT_DT" "WK_STRT_DT",
    "A5"."WK_END_DT" "WK_END_DT",
    "A5"."WK_TIMESPN" "WK_TIMESPN",
    "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",
    "A3"."CLNDR_QTR_ID" "CLNDR_QTR_ID",
    "A3"."QTR_DESC" "QTR_DESC",
    "A3"."QTR_CD" "QTR_CD",
    "A3"."QTR_NBR" "QTR_NBR",
    "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_R_DAY" "A6",
    "DDR_R_CLNDR_WK" "A5",
    "DDR_R_CLNDR_MNTH" "A4",
    "DDR_R_CLNDR_QTR" "A3",
    "DDR_R_CLNDR_YR" "A2",
    "DDR_R_DAY_TRANS" "A1"
  WHERE "A6"."CLNDR_WK_ID"="A5"."CLNDR_WK_ID"
  AND "A6"."CLNDR_MNTH_ID"="A4"."CLNDR_MNTH_ID"
  AND "A4"."CLNDR_QTR_ID" ="A3"."CLNDR_QTR_ID"
  AND "A3"."CLNDR_YR_ID"  ="A2"."CLNDR_YR_ID"
  AND "A6"."DAY_CD"       ="A1"."DAY_CD"
  AND "A1"."CLNDR_CD"     ='CLNDR'

View Text - HTML Formatted

SELECT "A6".ROWID "DAY_ROWID"
, "A5".ROWID "GWK_ROWID"
, "A4".ROWID "GMNTH_ROWID"
, "A3".ROWID "GQTR_ROWID"
, "A2".ROWID "GYR_ROWID"
, "A1".ROWID "DAY_TRANS_ROWID"
, "A1"."MFG_ORG_CD" ||'-' ||'CLNDR' "CLNDR_DESC"
, "A1"."CLNDR_CD" "CLNDR_CD"
, "A1"."CLNDR_TYP" "CLNDR_TYPE"
, "A6"."DAY_CD" "DAY_CD"
, "A6"."DAY_OF_YR"
, "A6"."WK_DAY"
, "A6"."CLNDR_DT" "CLNDR_DT"
, "A6"."CLNDR_DT_DESC" "CLNDR_DT_DESC"
, "A1"."LAST_YR_THIS_DAY_CD" "LAST_YR_THIS_DAY_CD"
, "A1"."LAST_DAY_THIS_YR_CD" "LAST_DAY_THIS_YR_CD"
, "A5"."CLNDR_WK_ID" "CLNDR_WK_ID"
, "A5"."WK_DESC" "WK_DESC"
, "A5"."WK_CD" "WK_CD"
, "A5"."WK_NBR" "WK_NBR"
, "A5"."WK_STRT_DT" "WK_STRT_DT"
, "A5"."WK_END_DT" "WK_END_DT"
, "A5"."WK_TIMESPN" "WK_TIMESPN"
, "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"
, "A3"."CLNDR_QTR_ID" "CLNDR_QTR_ID"
, "A3"."QTR_DESC" "QTR_DESC"
, "A3"."QTR_CD" "QTR_CD"
, "A3"."QTR_NBR" "QTR_NBR"
, "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_R_DAY" "A6"
, "DDR_R_CLNDR_WK" "A5"
, "DDR_R_CLNDR_MNTH" "A4"
, "DDR_R_CLNDR_QTR" "A3"
, "DDR_R_CLNDR_YR" "A2"
, "DDR_R_DAY_TRANS" "A1"
WHERE "A6"."CLNDR_WK_ID"="A5"."CLNDR_WK_ID"
AND "A6"."CLNDR_MNTH_ID"="A4"."CLNDR_MNTH_ID"
AND "A4"."CLNDR_QTR_ID" ="A3"."CLNDR_QTR_ID"
AND "A3"."CLNDR_YR_ID" ="A2"."CLNDR_YR_ID"
AND "A6"."DAY_CD" ="A1"."DAY_CD"
AND "A1"."CLNDR_CD" ='CLNDR'