VIEW: DDR.DDR_R_DAY_TRANS#

Source

View Text - Preformatted

select MFG_ORG_CD MFG_ORG_CD, DAY_TRANS_ID DAY_TRANS_ID, DAY_CD DAY_CD, CLNDR_CD CLNDR_CD, CLNDR_TYP CLNDR_TYP, LAST_DAY_THIS_YR_CD LAST_DAY_THIS_YR_CD, LAST_WK_THIS_DAY_CD LAST_WK_THIS_DAY_CD, LAST_MNTH_THIS_DAY_CD LAST_MNTH_THIS_DAY_CD, LAST_PRD_THIS_DAY_CD LAST_PRD_THIS_DAY_CD, LAST_QTR_THIS_DAY_CD LAST_QTR_THIS_DAY_CD, LAST_YR_THIS_DAY_CD LAST_YR_THIS_DAY_CD, NXT_DAY_THIS_YR_CD NXT_DAY_THIS_YR_CD, NXT_WK_THIS_DAY_CD NXT_WK_THIS_DAY_CD, NXT_MNTH_THIS_DAY_CD NXT_MNTH_THIS_DAY_CD, NXT_PRD_THIS_DAY_CD NXT_PRD_THIS_DAY_CD, NXT_QTR_THIS_DAY_CD NXT_QTR_THIS_DAY_CD, NXT_YR_THIS_DAY_CD NXT_YR_THIS_DAY_CD, SRC_SYS_IDNT SRC_SYS_IDNT, SRC_SYS_DT SRC_SYS_DT, CRTD_BY_DSR CRTD_BY_DSR, LAST_UPDT_BY_DSR LAST_UPDT_BY_DSR, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "DDR"."DDR_R_DAY_TRANS"

View Text - HTML Formatted

SELECT MFG_ORG_CD MFG_ORG_CD
, DAY_TRANS_ID DAY_TRANS_ID
, DAY_CD DAY_CD
, CLNDR_CD CLNDR_CD
, CLNDR_TYP CLNDR_TYP
, LAST_DAY_THIS_YR_CD LAST_DAY_THIS_YR_CD
, LAST_WK_THIS_DAY_CD LAST_WK_THIS_DAY_CD
, LAST_MNTH_THIS_DAY_CD LAST_MNTH_THIS_DAY_CD
, LAST_PRD_THIS_DAY_CD LAST_PRD_THIS_DAY_CD
, LAST_QTR_THIS_DAY_CD LAST_QTR_THIS_DAY_CD
, LAST_YR_THIS_DAY_CD LAST_YR_THIS_DAY_CD
, NXT_DAY_THIS_YR_CD NXT_DAY_THIS_YR_CD
, NXT_WK_THIS_DAY_CD NXT_WK_THIS_DAY_CD
, NXT_MNTH_THIS_DAY_CD NXT_MNTH_THIS_DAY_CD
, NXT_PRD_THIS_DAY_CD NXT_PRD_THIS_DAY_CD
, NXT_QTR_THIS_DAY_CD NXT_QTR_THIS_DAY_CD
, NXT_YR_THIS_DAY_CD NXT_YR_THIS_DAY_CD
, SRC_SYS_IDNT SRC_SYS_IDNT
, SRC_SYS_DT SRC_SYS_DT
, CRTD_BY_DSR CRTD_BY_DSR
, LAST_UPDT_BY_DSR LAST_UPDT_BY_DSR
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "DDR"."DDR_R_DAY_TRANS"