VIEW: DDR.DDR_E_MFG_ITEM_HCHY#

Source

View Text - Preformatted

select REC_ID REC_ID, ORG_CD ORG_CD, MFG_CMPNY_CD MFG_CMPNY_CD, MFG_DIV_CD MFG_DIV_CD, MFG_DIV_NAME MFG_DIV_NAME, MFG_GRP_CD MFG_GRP_CD, MFG_GRP_NAME MFG_GRP_NAME, MFG_CLASS_CD MFG_CLASS_CD, MFG_CLASS_NAME MFG_CLASS_NAME, MFG_SBC_CD MFG_SBC_CD, MFG_SBC_NAME MFG_SBC_NAME, MFG_ITEM_NBR MFG_ITEM_NBR, MFG_ITEM_NAME MFG_ITEM_NAME, MFG_ITEM_DESC MFG_ITEM_DESC, MFG_BRND_CD MFG_BRND_CD, MFG_SKU_ITEM_NBR MFG_SKU_ITEM_NBR, GLBL_ITEM_ID GLBL_ITEM_ID, GLBL_ITEM_ID_TYP GLBL_ITEM_ID_TYP, MFG_SKU_ITEM_NAME MFG_SKU_ITEM_NAME, MFG_SKU_ITEM_DESC MFG_SKU_ITEM_DESC, SRC_SYS_IDNT SRC_SYS_IDNT, SRC_SYS_DT SRC_SYS_DT, ERR_REASON ERR_REASON, ACTION_FLAG ACTION_FLAG, LOAD_ID LOAD_ID from "DDR"."DDR_E_MFG_ITEM_HCHY"

View Text - HTML Formatted

SELECT REC_ID REC_ID
, ORG_CD ORG_CD
, MFG_CMPNY_CD MFG_CMPNY_CD
, MFG_DIV_CD MFG_DIV_CD
, MFG_DIV_NAME MFG_DIV_NAME
, MFG_GRP_CD MFG_GRP_CD
, MFG_GRP_NAME MFG_GRP_NAME
, MFG_CLASS_CD MFG_CLASS_CD
, MFG_CLASS_NAME MFG_CLASS_NAME
, MFG_SBC_CD MFG_SBC_CD
, MFG_SBC_NAME MFG_SBC_NAME
, MFG_ITEM_NBR MFG_ITEM_NBR
, MFG_ITEM_NAME MFG_ITEM_NAME
, MFG_ITEM_DESC MFG_ITEM_DESC
, MFG_BRND_CD MFG_BRND_CD
, MFG_SKU_ITEM_NBR MFG_SKU_ITEM_NBR
, GLBL_ITEM_ID GLBL_ITEM_ID
, GLBL_ITEM_ID_TYP GLBL_ITEM_ID_TYP
, MFG_SKU_ITEM_NAME MFG_SKU_ITEM_NAME
, MFG_SKU_ITEM_DESC MFG_SKU_ITEM_DESC
, SRC_SYS_IDNT SRC_SYS_IDNT
, SRC_SYS_DT SRC_SYS_DT
, ERR_REASON ERR_REASON
, ACTION_FLAG ACTION_FLAG
, LOAD_ID LOAD_ID
FROM "DDR"."DDR_E_MFG_ITEM_HCHY"