eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: DDR.DDR_E_TRD_AREA#

Source

View Text - Preformatted


select REC_ID REC_ID, ORG_CD ORG_CD, 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, 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_TRD_AREA"

View Text - HTML Formatted

SELECT REC_ID REC_ID
, ORG_CD ORG_CD
, 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
, 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_TRD_AREA"