VIEW: DDR.DDR_R_ADDR_LOC#

Source

View Text - Preformatted

select MFG_ORG_CD MFG_ORG_CD, ADDR_LOC_ID ADDR_LOC_ID, ADDR_LOC_CD ADDR_LOC_CD, ADDR_LINE_1 ADDR_LINE_1, ADDR_LINE_2 ADDR_LINE_2, ADDR_LINE_3 ADDR_LINE_3, ADDR_DESC ADDR_DESC, ADDR_LINE_PHNTC ADDR_LINE_PHNTC, TIME_ZN_CD TIME_ZN_CD, LAT LAT, LON LON, ELVTN ELVTN, ELVTN_UOM_CD ELVTN_UOM_CD, ADDR_TYP_CD ADDR_TYP_CD, CNTRY_CD CNTRY_CD, CNTRY_NAME CNTRY_NAME, GEO_RGN_ID GEO_RGN_ID, RGN_CD RGN_CD, RGN_NAME RGN_NAME, GEO_SUB_RGN_ID GEO_SUB_RGN_ID, SUB_RGN_CD SUB_RGN_CD, SUB_RGN_NAME SUB_RGN_NAME, STATE_CD STATE_CD, STATE_NAME STATE_NAME, CITY_CD CITY_CD, CITY_NAME CITY_NAME, POST_CD POST_CD, POST_OFFC_BOX POST_OFFC_BOX, GEO_CD GEO_CD, GEO_DEMOG_ID GEO_DEMOG_ID, ALT_GEO_DEMOG_ID ALT_GEO_DEMOG_ID, ALT_GEO_CD ALT_GEO_CD, PRMRY_ADDR_PHONE PRMRY_ADDR_PHONE, PRMRY_EMAIL_ADDR PRMRY_EMAIL_ADDR, 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_ADDR_LOC"

View Text - HTML Formatted

SELECT MFG_ORG_CD MFG_ORG_CD
, ADDR_LOC_ID ADDR_LOC_ID
, ADDR_LOC_CD ADDR_LOC_CD
, ADDR_LINE_1 ADDR_LINE_1
, ADDR_LINE_2 ADDR_LINE_2
, ADDR_LINE_3 ADDR_LINE_3
, ADDR_DESC ADDR_DESC
, ADDR_LINE_PHNTC ADDR_LINE_PHNTC
, TIME_ZN_CD TIME_ZN_CD
, LAT LAT
, LON LON
, ELVTN ELVTN
, ELVTN_UOM_CD ELVTN_UOM_CD
, ADDR_TYP_CD ADDR_TYP_CD
, CNTRY_CD CNTRY_CD
, CNTRY_NAME CNTRY_NAME
, GEO_RGN_ID GEO_RGN_ID
, RGN_CD RGN_CD
, RGN_NAME RGN_NAME
, GEO_SUB_RGN_ID GEO_SUB_RGN_ID
, SUB_RGN_CD SUB_RGN_CD
, SUB_RGN_NAME SUB_RGN_NAME
, STATE_CD STATE_CD
, STATE_NAME STATE_NAME
, CITY_CD CITY_CD
, CITY_NAME CITY_NAME
, POST_CD POST_CD
, POST_OFFC_BOX POST_OFFC_BOX
, GEO_CD GEO_CD
, GEO_DEMOG_ID GEO_DEMOG_ID
, ALT_GEO_DEMOG_ID ALT_GEO_DEMOG_ID
, ALT_GEO_CD ALT_GEO_CD
, PRMRY_ADDR_PHONE PRMRY_ADDR_PHONE
, PRMRY_EMAIL_ADDR PRMRY_EMAIL_ADDR
, 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_ADDR_LOC"