VIEW: DDR.DDR_R_INV_LOC#

Source

View Text - Preformatted

select MFG_ORG_CD MFG_ORG_CD, INV_LOC_ID INV_LOC_ID, ORG_CD ORG_CD, ORG_BSNS_UNIT_ID ORG_BSNS_UNIT_ID, BSNS_UNIT_CD BSNS_UNIT_CD, INV_LOC_CD INV_LOC_CD, INV_LOC_TYP_CD INV_LOC_TYP_CD, INV_LOC_DESC INV_LOC_DESC, LAYOUT_SHAPE LAYOUT_SHAPE, LNR_SZ LNR_SZ, SQR_SZ SQR_SZ, CUBIC_SZ CUBIC_SZ, LOC_CORDNT_X LOC_CORDNT_X, LOC_CORDNT_Y LOC_CORDNT_Y, LOC_CORDNT_Z LOC_CORDNT_Z, UOM_CD UOM_CD, SLNG_LOC_TYP_CD SLNG_LOC_TYP_CD, NBR_OF_FCNGS NBR_OF_FCNGS, 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_INV_LOC"

View Text - HTML Formatted

SELECT MFG_ORG_CD MFG_ORG_CD
, INV_LOC_ID INV_LOC_ID
, ORG_CD ORG_CD
, ORG_BSNS_UNIT_ID ORG_BSNS_UNIT_ID
, BSNS_UNIT_CD BSNS_UNIT_CD
, INV_LOC_CD INV_LOC_CD
, INV_LOC_TYP_CD INV_LOC_TYP_CD
, INV_LOC_DESC INV_LOC_DESC
, LAYOUT_SHAPE LAYOUT_SHAPE
, LNR_SZ LNR_SZ
, SQR_SZ SQR_SZ
, CUBIC_SZ CUBIC_SZ
, LOC_CORDNT_X LOC_CORDNT_X
, LOC_CORDNT_Y LOC_CORDNT_Y
, LOC_CORDNT_Z LOC_CORDNT_Z
, UOM_CD UOM_CD
, SLNG_LOC_TYP_CD SLNG_LOC_TYP_CD
, NBR_OF_FCNGS NBR_OF_FCNGS
, 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_INV_LOC"