VIEW: DDR.DDR_S_MFG_SHIP_ITEM#

Source

View Text - Preformatted

select REC_ID REC_ID, BSNS_UNIT_ID BSNS_UNIT_ID, BSNS_UNIT_CD BSNS_UNIT_CD, SHIP_TO_ORG_CD SHIP_TO_ORG_CD, SHIP_TO_BSNS_UNIT_ID SHIP_TO_BSNS_UNIT_ID, SHIP_TO_BSNS_UNIT_CD SHIP_TO_BSNS_UNIT_CD, 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, TRANS_DT TRANS_DT, LOAD_ID LOAD_ID, SRC_SYS_IDNT SRC_SYS_IDNT, SRC_SYS_DT SRC_SYS_DT from "DDR"."DDR_S_MFG_SHIP_ITEM"

View Text - HTML Formatted

SELECT REC_ID REC_ID
, BSNS_UNIT_ID BSNS_UNIT_ID
, BSNS_UNIT_CD BSNS_UNIT_CD
, SHIP_TO_ORG_CD SHIP_TO_ORG_CD
, SHIP_TO_BSNS_UNIT_ID SHIP_TO_BSNS_UNIT_ID
, SHIP_TO_BSNS_UNIT_CD SHIP_TO_BSNS_UNIT_CD
, 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
, TRANS_DT TRANS_DT
, LOAD_ID LOAD_ID
, SRC_SYS_IDNT SRC_SYS_IDNT
, SRC_SYS_DT SRC_SYS_DT
FROM "DDR"."DDR_S_MFG_SHIP_ITEM"