VIEW: DDR.DDR_R_MKT_ITEM#

Source

View Text - Preformatted

select MFG_ORG_CD MFG_ORG_CD, MKT_ITEM_ID MKT_ITEM_ID, GLBL_ITEM_ID GLBL_ITEM_ID, GLBL_ITEM_ID_TYP GLBL_ITEM_ID_TYP, MKT_ITEM_DESC MKT_ITEM_DESC, MKT_ITEM_DEPT_ID MKT_ITEM_DEPT_ID, MKT_DEPT_CD MKT_DEPT_CD, OWND_FLG_IND OWND_FLG_IND, BRND_NAME BRND_NAME, FLVR_SCNT FLVR_SCNT, MKT_ITEM_SZ MKT_ITEM_SZ, ITEM_TYP ITEM_TYP, PKG_TYP PKG_TYP, GNRTN_CD GNRTN_CD, EFF_FROM_DT EFF_FROM_DT, EFF_TO_DT EFF_TO_DT, 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_MKT_ITEM"

View Text - HTML Formatted

SELECT MFG_ORG_CD MFG_ORG_CD
, MKT_ITEM_ID MKT_ITEM_ID
, GLBL_ITEM_ID GLBL_ITEM_ID
, GLBL_ITEM_ID_TYP GLBL_ITEM_ID_TYP
, MKT_ITEM_DESC MKT_ITEM_DESC
, MKT_ITEM_DEPT_ID MKT_ITEM_DEPT_ID
, MKT_DEPT_CD MKT_DEPT_CD
, OWND_FLG_IND OWND_FLG_IND
, BRND_NAME BRND_NAME
, FLVR_SCNT FLVR_SCNT
, MKT_ITEM_SZ MKT_ITEM_SZ
, ITEM_TYP ITEM_TYP
, PKG_TYP PKG_TYP
, GNRTN_CD GNRTN_CD
, EFF_FROM_DT EFF_FROM_DT
, EFF_TO_DT EFF_TO_DT
, 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_MKT_ITEM"