VIEW: DDR.DDR_R_TRD_AREA#

Source

View Text - Preformatted

select MFG_ORG_CD MFG_ORG_CD, TRD_AREA_ID TRD_AREA_ID, ORG_CD ORG_CD, ORG_BSNS_UNIT_ID ORG_BSNS_UNIT_ID, BSNS_UNIT_CD BSNS_UNIT_CD, TRD_AREA_CD TRD_AREA_CD, TRD_AREA_NAME TRD_AREA_NAME, TRD_AREA_DESC TRD_AREA_DESC, DEFN_TYP DEFN_TYP, DEFN_SRC DEFN_SRC, PRMRY_ZIP_CD PRMRY_ZIP_CD, SCNDRY_ZIP_CD SCNDRY_ZIP_CD, LON LON, LAT LAT, AREA_SHAPE AREA_SHAPE, AREA_TYP AREA_TYP, CITY CITY, STATE STATE, CNTRY CNTRY, PULL_FCTR PULL_FCTR, TRD_AREA_CPTR TRD_AREA_CPTR, TOT_POPLTN TOT_POPLTN, STATE_POPLTN STATE_POPLTN, STATE_SLS STATE_SLS, 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_TRD_AREA"

View Text - HTML Formatted

SELECT MFG_ORG_CD MFG_ORG_CD
, TRD_AREA_ID TRD_AREA_ID
, ORG_CD ORG_CD
, ORG_BSNS_UNIT_ID ORG_BSNS_UNIT_ID
, BSNS_UNIT_CD BSNS_UNIT_CD
, TRD_AREA_CD TRD_AREA_CD
, TRD_AREA_NAME TRD_AREA_NAME
, TRD_AREA_DESC TRD_AREA_DESC
, DEFN_TYP DEFN_TYP
, DEFN_SRC DEFN_SRC
, PRMRY_ZIP_CD PRMRY_ZIP_CD
, SCNDRY_ZIP_CD SCNDRY_ZIP_CD
, LON LON
, LAT LAT
, AREA_SHAPE AREA_SHAPE
, AREA_TYP AREA_TYP
, CITY CITY
, STATE STATE
, CNTRY CNTRY
, PULL_FCTR PULL_FCTR
, TRD_AREA_CPTR TRD_AREA_CPTR
, TOT_POPLTN TOT_POPLTN
, STATE_POPLTN STATE_POPLTN
, STATE_SLS STATE_SLS
, 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_TRD_AREA"