VIEW: APPS.DDR_R_CLNDR_PRD_DRTN_DN_MV#

Source

View Text - Preformatted

(SELECT "A13"."DAY_CD" "PRD_CD",
    TO_NUMBER("A13"."DAY_CD") "PRD_ID",
    1 "PRD_TYP",
    1 "PRD_DRTN",
    "A13"."DAY_OF_YR" "PRD_DRTN_YTD",
    0 "CNT_PRD_DRTN_YTD",
    0 "CNT_TOTAL",
    "A13".ROWID "PRD_ROWID"
  FROM "DDR_R_DAY" "A13"
  )
UNION ALL
  (SELECT "A12"."WK_CD" "PRD_CD",
    "A12"."CLNDR_WK_ID" "PRD_ID",
    2 "PRD_TYP",
    "A12"."WK_TIMESPN" "PRD_DRTN",
    SUM("A11"."WK_TIMESPN") "PRD_DRTN_YTD",
    COUNT("A11"."WK_TIMESPN") "CNT_PRD_DRTN_YTD",
    COUNT(*) "CNT_TOTAL",
    "A12".ROWID "PRD_ROWID"
  FROM "DDR_R_CLNDR_WK" "A12",
    "DDR_R_CLNDR_WK" "A11",
    "DDR_R_WK_TODATE_TRANS" "A10"
  WHERE "A12"."CLNDR_WK_ID"="A10"."WK_ID"
  AND "A10"."YR_WK_ID"     ="A11"."CLNDR_WK_ID"
  AND "A10"."CLNDR_CD"     ='CLNDR'
  GROUP BY "A12"."WK_CD",
    "A12"."CLNDR_WK_ID",
    "A12"."WK_TIMESPN",
    "A12".ROWID
  )
UNION ALL
  (SELECT "A9"."MNTH_CD" "PRD_CD",
    "A9"."CLNDR_MNTH_ID" "PRD_ID",
    3 "PRD_TYP",
    "A9"."MNTH_TIMESPN" "PRD_DRTN",
    SUM("A8"."MNTH_TIMESPN") "PRD_DRTN_YTD",
    COUNT("A8"."MNTH_TIMESPN") "CNT_PRD_DRTN_YTD",
    COUNT(*) "CNT_TOTAL",
    "A9".ROWID "PRD_ROWID"
  FROM "DDR_R_CLNDR_MNTH" "A9",
    "DDR_R_CLNDR_MNTH" "A8",
    "DDR_R_MNTH_TODATE_TRANS" "A7"
  WHERE "A9"."CLNDR_MNTH_ID"="A7"."MNTH_ID"
  AND "A7"."YR_MNTH_ID"     ="A8"."CLNDR_MNTH_ID"
  AND "A7"."CLNDR_CD"       ='CLNDR'
  GROUP BY "A9"."MNTH_CD",
    "A9"."CLNDR_MNTH_ID",
    "A9"."MNTH_TIMESPN",
    "A9".ROWID
  )
UNION ALL
  (SELECT "A6"."QTR_CD" "PRD_CD",
    "A6"."CLNDR_QTR_ID" "PRD_ID",
    4 "PRD_TYP",
    "A6"."QTR_TIMESPN" "PRD_DRTN",
    SUM("A5"."QTR_TIMESPN") "PRD_DRTN_YTD",
    COUNT("A5"."QTR_TIMESPN") "CNT_PRD_DRTN_YTD",
    COUNT(*) "CNT_TOTAL",
    "A6".ROWID "PRD_ROWID"
  FROM "DDR_R_CLNDR_QTR" "A6",
    "DDR_R_CLNDR_QTR" "A5",
    "DDR_R_QTR_TODATE_TRANS" "A4"
  WHERE "A6"."CLNDR_QTR_ID"="A4"."QTR_ID"
  AND "A4"."YR_QTR_ID"     ="A5"."CLNDR_QTR_ID"
  AND "A4"."CLNDR_CD"      ='CLNDR'
  GROUP BY "A6"."QTR_CD",
    "A6"."CLNDR_QTR_ID",
    "A6"."QTR_TIMESPN",
    "A6".ROWID
  )
UNION ALL
  (SELECT "A3"."YR_CD" "PRD_CD",
    "A3"."CLNDR_YR_ID" "PRD_ID",
    5 "PRD_TYP",
    "A3"."YR_TIMESPN" "PRD_DRTN",
    "A3"."YR_TIMESPN" "PRD_DRTN_YTD",
    0 "CNT_PRD_DRTN_YTD",
    0 "CNT_TOTAL",
    "A3".ROWID "PRD_ROWID"
  FROM "DDR_R_CLNDR_YR" "A3"
  )

View Text - HTML Formatted

(SELECT "A13"."DAY_CD" "PRD_CD"
, TO_NUMBER("A13"."DAY_CD") "PRD_ID"
, 1 "PRD_TYP"
, 1 "PRD_DRTN"
, "A13"."DAY_OF_YR" "PRD_DRTN_YTD"
, 0 "CNT_PRD_DRTN_YTD"
, 0 "CNT_TOTAL"
, "A13".ROWID "PRD_ROWID"
FROM "DDR_R_DAY" "A13" ) UNION ALL (SELECT "A12"."WK_CD" "PRD_CD"
, "A12"."CLNDR_WK_ID" "PRD_ID"
, 2 "PRD_TYP"
, "A12"."WK_TIMESPN" "PRD_DRTN"
, SUM("A11"."WK_TIMESPN") "PRD_DRTN_YTD"
, COUNT("A11"."WK_TIMESPN") "CNT_PRD_DRTN_YTD"
, COUNT(*) "CNT_TOTAL"
, "A12".ROWID "PRD_ROWID"
FROM "DDR_R_CLNDR_WK" "A12"
, "DDR_R_CLNDR_WK" "A11"
, "DDR_R_WK_TODATE_TRANS" "A10"
WHERE "A12"."CLNDR_WK_ID"="A10"."WK_ID"
AND "A10"."YR_WK_ID" ="A11"."CLNDR_WK_ID"
AND "A10"."CLNDR_CD" ='CLNDR' GROUP BY "A12"."WK_CD"
, "A12"."CLNDR_WK_ID"
, "A12"."WK_TIMESPN"
, "A12".ROWID ) UNION ALL (SELECT "A9"."MNTH_CD" "PRD_CD"
, "A9"."CLNDR_MNTH_ID" "PRD_ID"
, 3 "PRD_TYP"
, "A9"."MNTH_TIMESPN" "PRD_DRTN"
, SUM("A8"."MNTH_TIMESPN") "PRD_DRTN_YTD"
, COUNT("A8"."MNTH_TIMESPN") "CNT_PRD_DRTN_YTD"
, COUNT(*) "CNT_TOTAL"
, "A9".ROWID "PRD_ROWID"
FROM "DDR_R_CLNDR_MNTH" "A9"
, "DDR_R_CLNDR_MNTH" "A8"
, "DDR_R_MNTH_TODATE_TRANS" "A7"
WHERE "A9"."CLNDR_MNTH_ID"="A7"."MNTH_ID"
AND "A7"."YR_MNTH_ID" ="A8"."CLNDR_MNTH_ID"
AND "A7"."CLNDR_CD" ='CLNDR' GROUP BY "A9"."MNTH_CD"
, "A9"."CLNDR_MNTH_ID"
, "A9"."MNTH_TIMESPN"
, "A9".ROWID ) UNION ALL (SELECT "A6"."QTR_CD" "PRD_CD"
, "A6"."CLNDR_QTR_ID" "PRD_ID"
, 4 "PRD_TYP"
, "A6"."QTR_TIMESPN" "PRD_DRTN"
, SUM("A5"."QTR_TIMESPN") "PRD_DRTN_YTD"
, COUNT("A5"."QTR_TIMESPN") "CNT_PRD_DRTN_YTD"
, COUNT(*) "CNT_TOTAL"
, "A6".ROWID "PRD_ROWID"
FROM "DDR_R_CLNDR_QTR" "A6"
, "DDR_R_CLNDR_QTR" "A5"
, "DDR_R_QTR_TODATE_TRANS" "A4"
WHERE "A6"."CLNDR_QTR_ID"="A4"."QTR_ID"
AND "A4"."YR_QTR_ID" ="A5"."CLNDR_QTR_ID"
AND "A4"."CLNDR_CD" ='CLNDR' GROUP BY "A6"."QTR_CD"
, "A6"."CLNDR_QTR_ID"
, "A6"."QTR_TIMESPN"
, "A6".ROWID ) UNION ALL (SELECT "A3"."YR_CD" "PRD_CD"
, "A3"."CLNDR_YR_ID" "PRD_ID"
, 5 "PRD_TYP"
, "A3"."YR_TIMESPN" "PRD_DRTN"
, "A3"."YR_TIMESPN" "PRD_DRTN_YTD"
, 0 "CNT_PRD_DRTN_YTD"
, 0 "CNT_TOTAL"
, "A3".ROWID "PRD_ROWID"
FROM "DDR_R_CLNDR_YR" "A3" )