VIEW: DDR.DDR_R_ORG_BSNS_UNIT#

Source

View Text - Preformatted

select MFG_ORG_CD MFG_ORG_CD, ORG_BSNS_UNIT_ID ORG_BSNS_UNIT_ID, ORG_CD ORG_CD, BSNS_UNIT_CD BSNS_UNIT_CD, GLBL_LOC_ID GLBL_LOC_ID, GLBL_LOC_ID_TYP GLBL_LOC_ID_TYP, BSNS_UNIT_NAME BSNS_UNIT_NAME, ADDR_LOC_ID ADDR_LOC_ID, ADDR_LOC_CD ADDR_LOC_CD, GEO_SUB_RGN_ID GEO_SUB_RGN_ID, SUB_RGN_CD SUB_RGN_CD, RGN_CD RGN_CD, ADDR_TYP_CD ADDR_TYP_CD, CHNL_TYP_CD CHNL_TYP_CD, TIME_ZN TIME_ZN, LONG_DESC LONG_DESC, SCNDRY_DESC SCNDRY_DESC, ADDR_LINE ADDR_LINE, ADDR_USG ADDR_USG, CITY CITY, STATE STATE, CNTRY CNTRY, POST_CD POST_CD, GEO_CD GEO_CD, ADDR_PHONE ADDR_PHONE, EMAIL_ADDR EMAIL_ADDR, CNSTRCTN_STATUS CNSTRCTN_STATUS, EXTRNL_NAME EXTRNL_NAME, CNTCT_NBR CNTCT_NBR, CNTCT_TYP CNTCT_TYP, LOC_TYP_CD LOC_TYP_CD, PRMRY_TRD_AREA_CD PRMRY_TRD_AREA_CD, PRMRY_MKT_AREA_CD PRMRY_MKT_AREA_CD, SHPNG_CNTR_TYP SHPNG_CNTR_TYP, BSNS_UNIT_CNCPT BSNS_UNIT_CNCPT, TOT_LNR_DSTNC TOT_LNR_DSTNC, VAT_RGN VAT_RGN, VAT_INCLD_IND VAT_INCLD_IND, ORG_DSTRCT_ID ORG_DSTRCT_ID, DSTRCT_CD DSTRCT_CD, DSTRCT_NAME DSTRCT_NAME, PRMRY_CRNCY_CD PRMRY_CRNCY_CD, PRMRY_CLNDR_CD PRMRY_CLNDR_CD, STORE_MGR STORE_MGR, STORE_TYP STORE_TYP, STORE_OPEN_DT STORE_OPEN_DT, STORE_CLOSE_DT STORE_CLOSE_DT, FRMT_CD FRMT_CD, USABLE_AREA USABLE_AREA, FRMT_DESC FRMT_DESC, DSGN_CNCPT DSGN_CNCPT, USG_TYP_CD USG_TYP_CD, INV_AREA INV_AREA, SLNG_AREA SLNG_AREA, SZ_UNIT SZ_UNIT, NBR_OF_LOAD_DCKS NBR_OF_LOAD_DCKS, NBR_OF_UNLD_DCKS NBR_OF_UNLD_DCKS, NEW_STORE_IND NEW_STORE_IND, REMDL_DT REMDL_DT, STORE_PRICE_INDX STORE_PRICE_INDX, NBR_OF_LVLS NBR_OF_LVLS, NBR_OF_WNDW_DISP NBR_OF_WNDW_DISP, AREA_OF_WNDW_DISP AREA_OF_WNDW_DISP, FTNG_RMS_AVLBL FTNG_RMS_AVLBL, NBR_OF_EXTRNL_SIGN NBR_OF_EXTRNL_SIGN, RSTRMS_AVLBL_IND RSTRMS_AVLBL_IND, PRKNG_AVLBL_IND PRKNG_AVLBL_IND, TYP_OF_PRKNG TYP_OF_PRKNG, DSTNC_TO_NEARST_CROSS_STREET DSTNC_TO_NEARST_CROSS_STREET, NAME_OF_NEARST_CROSS_STREET NAME_OF_NEARST_CROSS_STREET, STCKHLD_IND STCKHLD_IND, TRNSFR_ZN_CD TRNSFR_ZN_CD, TRNSFR_ZN_DESC TRNSFR_ZN_DESC, PRMTN_ZN PRMTN_ZN, TOT_BLT_UP_AREA TOT_BLT_UP_AREA, TOT_SPR_BLT_UP_AREA TOT_SPR_BLT_UP_AREA, TERRAIN TERRAIN, STATE_FIPS_CD STATE_FIPS_CD, STORE_VOL STORE_VOL, WEEKLY_VOL WEEKLY_VOL, FULL_TIME_EMP_EQVLNTS FULL_TIME_EMP_EQVLNTS, NBR_OF_CHECKOUTS NBR_OF_CHECKOUTS, WRHS_SPCLTY WRHS_SPCLTY, BRK_PAC_IND BRK_PAC_IND, HDR_CD HDR_CD, BNR_CD BNR_CD, HDR_NAME HDR_NAME, NBR_OF_PGS NBR_OF_PGS, PUBLSH_DT PUBLSH_DT, VALID_TILL_DT VALID_TILL_DT, WEB_SITE_URL WEB_SITE_URL, WEB_SITE_VRSN WEB_SITE_VRSN, REF_URL REF_URL, REF_NAME REF_NAME, 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, BSNS_UNIT_TYP BSNS_UNIT_TYP, DFLT_WHSE DFLT_WHSE, MKT_AREA_ID_1 MKT_AREA_ID_1, MKT_AREA_TYP_1 MKT_AREA_TYP_1, MKT_AREA_CD_1 MKT_AREA_CD_1, MKT_AREA_ID_2 MKT_AREA_ID_2, MKT_AREA_TYP_2 MKT_AREA_TYP_2, MKT_AREA_CD_2 MKT_AREA_CD_2, MKT_AREA_ID_3 MKT_AREA_ID_3, MKT_AREA_TYP_3 MKT_AREA_TYP_3, MKT_AREA_CD_3 MKT_AREA_CD_3, CNTY_FIPS_CD CNTY_FIPS_CD, TDLINX_STR_CD TDLINX_STR_CD, STR_STATUS STR_STATUS, SUB_CHNL_CD SUB_CHNL_CD, CMPNY_SIZE CMPNY_SIZE, LAT LAT, LON LON, STR_ACV_RANGE STR_ACV_RANGE, FAMILY_CD FAMILY_CD, OWNER_OPER_NAME OWNER_OPER_NAME, MKTG_GRP_NAME MKTG_GRP_NAME, NON_CORP_OWNED NON_CORP_OWNED, GAS_SOLD_IND GAS_SOLD_IND, HIGH_VOL_CGRETTES_IND HIGH_VOL_CGRETTES_IND, PHARM_IN_STR_IND PHARM_IN_STR_IND, LIQ_IN_STR_IND LIQ_IN_STR_IND, WINE_IN_STR_IND WINE_IN_STR_IND, BEER_IN_STR_IND BEER_IN_STR_IND, SERVE_ALCOHOL_IND SERVE_ALCOHOL_IND, 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, CUR_REC_FLAG CUR_REC_FLAG from "DDR"."DDR_R_ORG_BSNS_UNIT"

View Text - HTML Formatted

SELECT MFG_ORG_CD MFG_ORG_CD
, ORG_BSNS_UNIT_ID ORG_BSNS_UNIT_ID
, ORG_CD ORG_CD
, BSNS_UNIT_CD BSNS_UNIT_CD
, GLBL_LOC_ID GLBL_LOC_ID
, GLBL_LOC_ID_TYP GLBL_LOC_ID_TYP
, BSNS_UNIT_NAME BSNS_UNIT_NAME
, ADDR_LOC_ID ADDR_LOC_ID
, ADDR_LOC_CD ADDR_LOC_CD
, GEO_SUB_RGN_ID GEO_SUB_RGN_ID
, SUB_RGN_CD SUB_RGN_CD
, RGN_CD RGN_CD
, ADDR_TYP_CD ADDR_TYP_CD
, CHNL_TYP_CD CHNL_TYP_CD
, TIME_ZN TIME_ZN
, LONG_DESC LONG_DESC
, SCNDRY_DESC SCNDRY_DESC
, ADDR_LINE ADDR_LINE
, ADDR_USG ADDR_USG
, CITY CITY
, STATE STATE
, CNTRY CNTRY
, POST_CD POST_CD
, GEO_CD GEO_CD
, ADDR_PHONE ADDR_PHONE
, EMAIL_ADDR EMAIL_ADDR
, CNSTRCTN_STATUS CNSTRCTN_STATUS
, EXTRNL_NAME EXTRNL_NAME
, CNTCT_NBR CNTCT_NBR
, CNTCT_TYP CNTCT_TYP
, LOC_TYP_CD LOC_TYP_CD
, PRMRY_TRD_AREA_CD PRMRY_TRD_AREA_CD
, PRMRY_MKT_AREA_CD PRMRY_MKT_AREA_CD
, SHPNG_CNTR_TYP SHPNG_CNTR_TYP
, BSNS_UNIT_CNCPT BSNS_UNIT_CNCPT
, TOT_LNR_DSTNC TOT_LNR_DSTNC
, VAT_RGN VAT_RGN
, VAT_INCLD_IND VAT_INCLD_IND
, ORG_DSTRCT_ID ORG_DSTRCT_ID
, DSTRCT_CD DSTRCT_CD
, DSTRCT_NAME DSTRCT_NAME
, PRMRY_CRNCY_CD PRMRY_CRNCY_CD
, PRMRY_CLNDR_CD PRMRY_CLNDR_CD
, STORE_MGR STORE_MGR
, STORE_TYP STORE_TYP
, STORE_OPEN_DT STORE_OPEN_DT
, STORE_CLOSE_DT STORE_CLOSE_DT
, FRMT_CD FRMT_CD
, USABLE_AREA USABLE_AREA
, FRMT_DESC FRMT_DESC
, DSGN_CNCPT DSGN_CNCPT
, USG_TYP_CD USG_TYP_CD
, INV_AREA INV_AREA
, SLNG_AREA SLNG_AREA
, SZ_UNIT SZ_UNIT
, NBR_OF_LOAD_DCKS NBR_OF_LOAD_DCKS
, NBR_OF_UNLD_DCKS NBR_OF_UNLD_DCKS
, NEW_STORE_IND NEW_STORE_IND
, REMDL_DT REMDL_DT
, STORE_PRICE_INDX STORE_PRICE_INDX
, NBR_OF_LVLS NBR_OF_LVLS
, NBR_OF_WNDW_DISP NBR_OF_WNDW_DISP
, AREA_OF_WNDW_DISP AREA_OF_WNDW_DISP
, FTNG_RMS_AVLBL FTNG_RMS_AVLBL
, NBR_OF_EXTRNL_SIGN NBR_OF_EXTRNL_SIGN
, RSTRMS_AVLBL_IND RSTRMS_AVLBL_IND
, PRKNG_AVLBL_IND PRKNG_AVLBL_IND
, TYP_OF_PRKNG TYP_OF_PRKNG
, DSTNC_TO_NEARST_CROSS_STREET DSTNC_TO_NEARST_CROSS_STREET
, NAME_OF_NEARST_CROSS_STREET NAME_OF_NEARST_CROSS_STREET
, STCKHLD_IND STCKHLD_IND
, TRNSFR_ZN_CD TRNSFR_ZN_CD
, TRNSFR_ZN_DESC TRNSFR_ZN_DESC
, PRMTN_ZN PRMTN_ZN
, TOT_BLT_UP_AREA TOT_BLT_UP_AREA
, TOT_SPR_BLT_UP_AREA TOT_SPR_BLT_UP_AREA
, TERRAIN TERRAIN
, STATE_FIPS_CD STATE_FIPS_CD
, STORE_VOL STORE_VOL
, WEEKLY_VOL WEEKLY_VOL
, FULL_TIME_EMP_EQVLNTS FULL_TIME_EMP_EQVLNTS
, NBR_OF_CHECKOUTS NBR_OF_CHECKOUTS
, WRHS_SPCLTY WRHS_SPCLTY
, BRK_PAC_IND BRK_PAC_IND
, HDR_CD HDR_CD
, BNR_CD BNR_CD
, HDR_NAME HDR_NAME
, NBR_OF_PGS NBR_OF_PGS
, PUBLSH_DT PUBLSH_DT
, VALID_TILL_DT VALID_TILL_DT
, WEB_SITE_URL WEB_SITE_URL
, WEB_SITE_VRSN WEB_SITE_VRSN
, REF_URL REF_URL
, REF_NAME REF_NAME
, 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
, BSNS_UNIT_TYP BSNS_UNIT_TYP
, DFLT_WHSE DFLT_WHSE
, MKT_AREA_ID_1 MKT_AREA_ID_1
, MKT_AREA_TYP_1 MKT_AREA_TYP_1
, MKT_AREA_CD_1 MKT_AREA_CD_1
, MKT_AREA_ID_2 MKT_AREA_ID_2
, MKT_AREA_TYP_2 MKT_AREA_TYP_2
, MKT_AREA_CD_2 MKT_AREA_CD_2
, MKT_AREA_ID_3 MKT_AREA_ID_3
, MKT_AREA_TYP_3 MKT_AREA_TYP_3
, MKT_AREA_CD_3 MKT_AREA_CD_3
, CNTY_FIPS_CD CNTY_FIPS_CD
, TDLINX_STR_CD TDLINX_STR_CD
, STR_STATUS STR_STATUS
, SUB_CHNL_CD SUB_CHNL_CD
, CMPNY_SIZE CMPNY_SIZE
, LAT LAT
, LON LON
, STR_ACV_RANGE STR_ACV_RANGE
, FAMILY_CD FAMILY_CD
, OWNER_OPER_NAME OWNER_OPER_NAME
, MKTG_GRP_NAME MKTG_GRP_NAME
, NON_CORP_OWNED NON_CORP_OWNED
, GAS_SOLD_IND GAS_SOLD_IND
, HIGH_VOL_CGRETTES_IND HIGH_VOL_CGRETTES_IND
, PHARM_IN_STR_IND PHARM_IN_STR_IND
, LIQ_IN_STR_IND LIQ_IN_STR_IND
, WINE_IN_STR_IND WINE_IN_STR_IND
, BEER_IN_STR_IND BEER_IN_STR_IND
, SERVE_ALCOHOL_IND SERVE_ALCOHOL_IND
, 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
, CUR_REC_FLAG CUR_REC_FLAG
FROM "DDR"."DDR_R_ORG_BSNS_UNIT"