VIEW: DDR.DDR_R_WK_TRANS#

Source

View Text - Preformatted

select MFG_ORG_CD MFG_ORG_CD, WK_TRANS_ID WK_TRANS_ID, WK_ID WK_ID, WK_CD WK_CD, CLNDR_CD CLNDR_CD, CLNDR_TYP CLNDR_TYP, LAST_WK_THIS_YR_ID LAST_WK_THIS_YR_ID, LAST_WK_THIS_YR_CD LAST_WK_THIS_YR_CD, LAST_MNTH_THIS_WK_ID LAST_MNTH_THIS_WK_ID, LAST_MNTH_THIS_WK_CD LAST_MNTH_THIS_WK_CD, LAST_PRD_THIS_WK_ID LAST_PRD_THIS_WK_ID, LAST_PRD_THIS_WK_CD LAST_PRD_THIS_WK_CD, LAST_QTR_THIS_WK_ID LAST_QTR_THIS_WK_ID, LAST_QTR_THIS_WK_CD LAST_QTR_THIS_WK_CD, LAST_YR_THIS_WK_ID LAST_YR_THIS_WK_ID, LAST_YR_THIS_WK_CD LAST_YR_THIS_WK_CD, NXT_WK_THIS_YR_WK_ID NXT_WK_THIS_YR_WK_ID, NXT_WK_THIS_YR_WK_CD NXT_WK_THIS_YR_WK_CD, NXT_MNTH_THIS_WK_ID NXT_MNTH_THIS_WK_ID, NXT_MNTH_THIS_WK_CD NXT_MNTH_THIS_WK_CD, NXT_PRD_THIS_WK_ID NXT_PRD_THIS_WK_ID, NXT_PRD_THIS_WK_CD NXT_PRD_THIS_WK_CD, NXT_QTR_THIS_WK_ID NXT_QTR_THIS_WK_ID, NXT_QTR_THIS_WK_CD NXT_QTR_THIS_WK_CD, NXT_YR_THIS_WK_ID NXT_YR_THIS_WK_ID, NXT_YR_THIS_WK_CD NXT_YR_THIS_WK_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_WK_TRANS"

View Text - HTML Formatted

SELECT MFG_ORG_CD MFG_ORG_CD
, WK_TRANS_ID WK_TRANS_ID
, WK_ID WK_ID
, WK_CD WK_CD
, CLNDR_CD CLNDR_CD
, CLNDR_TYP CLNDR_TYP
, LAST_WK_THIS_YR_ID LAST_WK_THIS_YR_ID
, LAST_WK_THIS_YR_CD LAST_WK_THIS_YR_CD
, LAST_MNTH_THIS_WK_ID LAST_MNTH_THIS_WK_ID
, LAST_MNTH_THIS_WK_CD LAST_MNTH_THIS_WK_CD
, LAST_PRD_THIS_WK_ID LAST_PRD_THIS_WK_ID
, LAST_PRD_THIS_WK_CD LAST_PRD_THIS_WK_CD
, LAST_QTR_THIS_WK_ID LAST_QTR_THIS_WK_ID
, LAST_QTR_THIS_WK_CD LAST_QTR_THIS_WK_CD
, LAST_YR_THIS_WK_ID LAST_YR_THIS_WK_ID
, LAST_YR_THIS_WK_CD LAST_YR_THIS_WK_CD
, NXT_WK_THIS_YR_WK_ID NXT_WK_THIS_YR_WK_ID
, NXT_WK_THIS_YR_WK_CD NXT_WK_THIS_YR_WK_CD
, NXT_MNTH_THIS_WK_ID NXT_MNTH_THIS_WK_ID
, NXT_MNTH_THIS_WK_CD NXT_MNTH_THIS_WK_CD
, NXT_PRD_THIS_WK_ID NXT_PRD_THIS_WK_ID
, NXT_PRD_THIS_WK_CD NXT_PRD_THIS_WK_CD
, NXT_QTR_THIS_WK_ID NXT_QTR_THIS_WK_ID
, NXT_QTR_THIS_WK_CD NXT_QTR_THIS_WK_CD
, NXT_YR_THIS_WK_ID NXT_YR_THIS_WK_ID
, NXT_YR_THIS_WK_CD NXT_YR_THIS_WK_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_WK_TRANS"