VIEW: DDR.DDR_B_MFG_SHIP_ITEM_DAY#

Source

View Text - Preformatted

select BSNS_UNIT_ID BSNS_UNIT_ID, SHIP_TO_ORG_CD SHIP_TO_ORG_CD, SHIP_TO_BSNS_UNIT_ID SHIP_TO_BSNS_UNIT_ID, DAY_CD DAY_CD, MFG_SKU_ITEM_ID MFG_SKU_ITEM_ID, MFG_SKU_ITEM_NBR MFG_SKU_ITEM_NBR, UOM_CD UOM_CD, UOM_CD_PRMRY UOM_CD_PRMRY, UOM_CD_ALT UOM_CD_ALT, CRNCY_CD CRNCY_CD, SHIP_QTY SHIP_QTY, SHIP_QTY_PRMRY SHIP_QTY_PRMRY, SHIP_QTY_ALT SHIP_QTY_ALT, SHIP_AMT SHIP_AMT, SHIP_AMT_LCL SHIP_AMT_LCL, SHIP_COST SHIP_COST, SHIP_COST_LCL SHIP_COST_LCL, 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_UPDATED_DATE LAST_UPDATED_DATE, LAST_UPDATED_LOGIN LAST_UPDATED_LOGIN from "DDR"."DDR_B_MFG_SHIP_ITEM_DAY"

View Text - HTML Formatted

SELECT BSNS_UNIT_ID BSNS_UNIT_ID
, SHIP_TO_ORG_CD SHIP_TO_ORG_CD
, SHIP_TO_BSNS_UNIT_ID SHIP_TO_BSNS_UNIT_ID
, DAY_CD DAY_CD
, MFG_SKU_ITEM_ID MFG_SKU_ITEM_ID
, MFG_SKU_ITEM_NBR MFG_SKU_ITEM_NBR
, UOM_CD UOM_CD
, UOM_CD_PRMRY UOM_CD_PRMRY
, UOM_CD_ALT UOM_CD_ALT
, CRNCY_CD CRNCY_CD
, SHIP_QTY SHIP_QTY
, SHIP_QTY_PRMRY SHIP_QTY_PRMRY
, SHIP_QTY_ALT SHIP_QTY_ALT
, SHIP_AMT SHIP_AMT
, SHIP_AMT_LCL SHIP_AMT_LCL
, SHIP_COST SHIP_COST
, SHIP_COST_LCL SHIP_COST_LCL
, 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_UPDATED_DATE LAST_UPDATED_DATE
, LAST_UPDATED_LOGIN LAST_UPDATED_LOGIN
FROM "DDR"."DDR_B_MFG_SHIP_ITEM_DAY"