VIEW: DDR.DDR_E_ORG#

Source

View Text - Preformatted

select REC_ID REC_ID, MFG_ORG_CD MFG_ORG_CD, ORG_CD ORG_CD, ORG_TYP ORG_TYP, GLBL_LOC_ID GLBL_LOC_ID, GLBL_LOC_ID_TYP GLBL_LOC_ID_TYP, ORG_NAME ORG_NAME, SIC_CD SIC_CD, SHORT_DESC SHORT_DESC, LONG_DESC LONG_DESC, SCNDRY_DESC SCNDRY_DESC, WEB_SITE_URL WEB_SITE_URL, PRMRY_CRNCY_CD PRMRY_CRNCY_CD, PRMRY_LANG PRMRY_LANG, ESTBD_DT ESTBD_DT, CNTCT_NBR CNTCT_NBR, CNTCT_TYP CNTCT_TYP, CNTCT_NAME CNTCT_NAME, CNTCT_EMAIL CNTCT_EMAIL, CNTCT_PHONE CNTCT_PHONE, FRNCHSE_CD FRNCHSE_CD, INDSTRY_SPFC_CD INDSTRY_SPFC_CD, DUNS_NBR DUNS_NBR, CR_RTNG_CD CR_RTNG_CD, INDVL_FIRM_CD INDVL_FIRM_CD, FIRST_APPEAR_YR FIRST_APPEAR_YR, DB_ADD_DT DB_ADD_DT, SLS_VOL_CD SLS_VOL_CD, PUB_IND PUB_IND, STCK_EXCHNG_CD STCK_EXCHNG_CD, STCK_TCKR_SYMBL STCK_TCKR_SYMBL, FICO_SCR FICO_SCR, TOT_EMP_SZ TOT_EMP_SZ, FULL_TIME_EMP_EQVLNTS FULL_TIME_EMP_EQVLNTS, NBR_OF_STORES NBR_OF_STORES, SRC_SYS_IDNT SRC_SYS_IDNT, SRC_SYS_DT SRC_SYS_DT, ERR_REASON ERR_REASON, ACTION_FLAG ACTION_FLAG, LOAD_ID LOAD_ID, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20 from "DDR"."DDR_E_ORG"

View Text - HTML Formatted

SELECT REC_ID REC_ID
, MFG_ORG_CD MFG_ORG_CD
, ORG_CD ORG_CD
, ORG_TYP ORG_TYP
, GLBL_LOC_ID GLBL_LOC_ID
, GLBL_LOC_ID_TYP GLBL_LOC_ID_TYP
, ORG_NAME ORG_NAME
, SIC_CD SIC_CD
, SHORT_DESC SHORT_DESC
, LONG_DESC LONG_DESC
, SCNDRY_DESC SCNDRY_DESC
, WEB_SITE_URL WEB_SITE_URL
, PRMRY_CRNCY_CD PRMRY_CRNCY_CD
, PRMRY_LANG PRMRY_LANG
, ESTBD_DT ESTBD_DT
, CNTCT_NBR CNTCT_NBR
, CNTCT_TYP CNTCT_TYP
, CNTCT_NAME CNTCT_NAME
, CNTCT_EMAIL CNTCT_EMAIL
, CNTCT_PHONE CNTCT_PHONE
, FRNCHSE_CD FRNCHSE_CD
, INDSTRY_SPFC_CD INDSTRY_SPFC_CD
, DUNS_NBR DUNS_NBR
, CR_RTNG_CD CR_RTNG_CD
, INDVL_FIRM_CD INDVL_FIRM_CD
, FIRST_APPEAR_YR FIRST_APPEAR_YR
, DB_ADD_DT DB_ADD_DT
, SLS_VOL_CD SLS_VOL_CD
, PUB_IND PUB_IND
, STCK_EXCHNG_CD STCK_EXCHNG_CD
, STCK_TCKR_SYMBL STCK_TCKR_SYMBL
, FICO_SCR FICO_SCR
, TOT_EMP_SZ TOT_EMP_SZ
, FULL_TIME_EMP_EQVLNTS FULL_TIME_EMP_EQVLNTS
, NBR_OF_STORES NBR_OF_STORES
, SRC_SYS_IDNT SRC_SYS_IDNT
, SRC_SYS_DT SRC_SYS_DT
, ERR_REASON ERR_REASON
, ACTION_FLAG ACTION_FLAG
, LOAD_ID LOAD_ID
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
FROM "DDR"."DDR_E_ORG"