DBA Data[Home] [Help] [Dependency Information]

TABLE: DDR.DDR_R_ORG_BSNS_UNIT

Object Details
Object Name: DDR_R_ORG_BSNS_UNIT
Object Type: TABLE
Owner: DDR
Subobject Name:
Status: VALID


An organization business unit is a place from where organization conducts its business. This could be a store, distribution center, warehouse, web-store or catalogue


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DDR_R_ORG_BSNS_UNIT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORG_BSNS_UNIT_ID
Columns
Name Datatype Length Mandatory Comments
MFG_ORG_CD VARCHAR2 (30) Yes Manufacturer Organization Code
ORG_BSNS_UNIT_ID NUMBER
Yes Business Unit ID
ORG_CD VARCHAR2 (30) Yes Organization Code
BSNS_UNIT_CD VARCHAR2 (30) Yes Business Unit Code
GLBL_LOC_ID VARCHAR2 (30) Yes Universally Unique Global Location ID for a particular level of organization.
GLBL_LOC_ID_TYP VARCHAR2 (30) Yes An indicator of the identification scheme used to assign the global Location ID.
BSNS_UNIT_NAME VARCHAR2 (40)
Business Unit Name
ADDR_LOC_ID NUMBER

Address Location ID
ADDR_LOC_CD VARCHAR2 (30)
Address Location Code
GEO_SUB_RGN_ID NUMBER

Geographic Sub Region ID
SUB_RGN_CD VARCHAR2 (30)
Sub Region Code
RGN_CD VARCHAR2 (30)
Region Code
ADDR_TYP_CD VARCHAR2 (30)
Address Type Code
CHNL_TYP_CD VARCHAR2 (30)
Channel Type Code
TIME_ZN VARCHAR2 (30)
Time Zone
LONG_DESC VARCHAR2 (240)
Long Description
SCNDRY_DESC VARCHAR2 (240)
Secondary Description
ADDR_LINE VARCHAR2 (240)
Address
ADDR_USG VARCHAR2 (240)
Describes how the address is used
CITY VARCHAR2 (40)
City
STATE VARCHAR2 (30)
State
CNTRY VARCHAR2 (30)
Country
POST_CD VARCHAR2 (30)
Postal Code (Zip Code)
GEO_CD VARCHAR2 (30)
Geographic Code
ADDR_PHONE VARCHAR2 (240)
Address Phone
EMAIL_ADDR VARCHAR2 (240)
Email Address
CNSTRCTN_STATUS VARCHAR2 (30)
Construction Status
EXTRNL_NAME VARCHAR2 (40)
Name/Number assigned to site for electronic communication, e.g. EDI transactions; e.g. 2260 (Albertson's has 2400 stores)
CNTCT_NBR VARCHAR2 (30)
Contact Number
CNTCT_TYP VARCHAR2 (30)
Contact Type
LOC_TYP_CD VARCHAR2 (30)
Location Type Code
PRMRY_TRD_AREA_CD VARCHAR2 (30)
Primary Trade Area Code
PRMRY_MKT_AREA_CD VARCHAR2 (30)
Primary Market Area Code
SHPNG_CNTR_TYP VARCHAR2 (30)
Shopping Center Type
BSNS_UNIT_CNCPT VARCHAR2 (240)
Business Unit Concept
TOT_LNR_DSTNC NUMBER

The total linear selling space of the location.
VAT_RGN VARCHAR2 (30)
The number of the Value Added Tax region
VAT_INCLD_IND VARCHAR2 (1)
Indicates whether or not Value Added Tax will be included in the retail prices for the store.
ORG_DSTRCT_ID NUMBER

Organization District ID
DSTRCT_CD VARCHAR2 (30)
District Code
DSTRCT_NAME VARCHAR2 (40)
District Name
PRMRY_CRNCY_CD VARCHAR2 (30)
Primary Currency Code
PRMRY_CLNDR_CD VARCHAR2 (30)
Primary Calendar Code
STORE_MGR VARCHAR2 (40)
Store Manager
STORE_TYP VARCHAR2 (30)
Store Type
STORE_OPEN_DT DATE

Store Open Date
STORE_CLOSE_DT DATE

Store Close Date
FRMT_CD VARCHAR2 (30)
Format Code
USABLE_AREA VARCHAR2 (40)
Useable Area
FRMT_DESC VARCHAR2 (240)
Format Description
DSGN_CNCPT VARCHAR2 (240)
Design Concept
USG_TYP_CD VARCHAR2 (30)
Usage Type Code
INV_AREA VARCHAR2 (40)
Inventory Area
SLNG_AREA VARCHAR2 (40)
Selling Area
SZ_UNIT VARCHAR2 (30)
Unit of measure used for area or size values
NBR_OF_LOAD_DCKS NUMBER

Number of Loading Docks
NBR_OF_UNLD_DCKS NUMBER

Number of Unloading Docks
NEW_STORE_IND VARCHAR2 (1)
Indicates if this is a new store
REMDL_DT DATE

Remodel Date
STORE_PRICE_INDX NUMBER

Store Price Index
NBR_OF_LVLS NUMBER

Number of Levels
NBR_OF_WNDW_DISP NUMBER

Number of Window Displays
AREA_OF_WNDW_DISP NUMBER

Area of Window Display
FTNG_RMS_AVLBL VARCHAR2 (40)
Fitting Rooms Available
NBR_OF_EXTRNL_SIGN NUMBER

Number of External Signs
RSTRMS_AVLBL_IND VARCHAR2 (1)
Identifies if restrooms are available
PRKNG_AVLBL_IND VARCHAR2 (1)
Parking Available Indicator
TYP_OF_PRKNG VARCHAR2 (30)
Type of Parking
DSTNC_TO_NEARST_CROSS_STREET VARCHAR2 (40)
Distance to Nearest Cross Street
NAME_OF_NEARST_CROSS_STREET VARCHAR2 (40)
Name of Nearest Cross Street
STCKHLD_IND VARCHAR2 (1)
Indicates whether the location can hold stock
TRNSFR_ZN_CD VARCHAR2 (30)
The code that indicates the transfer zone for which this location is a member.
TRNSFR_ZN_DESC VARCHAR2 (240)
The description or name of the transfer zone code of this location.
PRMTN_ZN VARCHAR2 (240)
To signify the pricing promotion policy for a specific geographic zone.
TOT_BLT_UP_AREA NUMBER

The part of the total area on which constructed structures exits (including the walls and the carpet area)
TOT_SPR_BLT_UP_AREA NUMBER

Total area as inclusive of carpet and built-up area and all the area under common spaces like the lobby, staircase, elevators, escalators, security room, etc.
TERRAIN VARCHAR2 (240)
Terrain, Possible values can be, Mountain, Inland, Rolling Hills, Plains, Coastal, Island, Desert.
STATE_FIPS_CD VARCHAR2 (30)
Federal Information Processing Standards (FIPS) codes issued by the National Institute of Standards and Technology (NIST) that identify each area
STORE_VOL VARCHAR2 (40)
Store Volume
WEEKLY_VOL VARCHAR2 (40)
Weekly Volume
FULL_TIME_EMP_EQVLNTS NUMBER

Full Time Employee Equivalents
NBR_OF_CHECKOUTS NUMBER

Number of Checkouts
WRHS_SPCLTY VARCHAR2 (240)
Specialty of the Warehouse
BRK_PAC_IND VARCHAR2 (1)
Indicates whether or not the warehouse is capable of distributing less than the supplier
HDR_CD VARCHAR2 (30)
Header code
BNR_CD VARCHAR2 (30)
The unique identifier of a banner.
HDR_NAME VARCHAR2 (40)
Header Name
NBR_OF_PGS NUMBER

Number of Pages
PUBLSH_DT DATE

Published Date
VALID_TILL_DT DATE

Valid Until Date
WEB_SITE_URL VARCHAR2 (240)
Web Site URL
WEB_SITE_VRSN NUMBER

Web Site Version
REF_URL VARCHAR2 (240)
Reference URL
REF_NAME VARCHAR2 (40)
Reference Name
EFF_FROM_DT DATE
Yes Effective From Date
EFF_TO_DT DATE

Effective To Date
SRC_SYS_IDNT VARCHAR2 (40) Yes Source file name or system that provided the data. It can be used to cross-reference the data with the source system, mainly for auditing purpose
SRC_SYS_DT DATE
Yes The date that the data was created. It can be used to cross-reference the data with the source system, mainly for auditing purpose
CRTD_BY_DSR VARCHAR2 (30) Yes User Information of who loaded the data, for auditing purpose
LAST_UPDT_BY_DSR VARCHAR2 (30) Yes User Information of last updated by, for auditing purpose
CREATED_BY NUMBER (15) Yes Number code of who last loaded the data, for auditing purpose
CREATION_DATE DATE
Yes Date on which the data was loaded in target table, for auditing purpose
LAST_UPDATED_BY NUMBER (15) Yes Number code of who last updated the data in target table, for auditing purpose
LAST_UPDATE_DATE DATE
Yes Date on which the data was last updated in target table, for auditing purpose
LAST_UPDATE_LOGIN NUMBER (15) Yes Login ID of the User who last updated the data in target table, for auditing purpose
BSNS_UNIT_TYP VARCHAR2 (30)
Business Unit Type
DFLT_WHSE VARCHAR2 (30)
Default Warehouse
MKT_AREA_ID_1 NUMBER

Market Area ID 1
MKT_AREA_TYP_1 VARCHAR2 (30)
Market Area Type 1
MKT_AREA_CD_1 VARCHAR2 (30)
Market Area Code 1
MKT_AREA_ID_2 NUMBER

Market Area ID 2
MKT_AREA_TYP_2 VARCHAR2 (30)
Market Area Type 2
MKT_AREA_CD_2 VARCHAR2 (30)
Market Area Code 2
MKT_AREA_ID_3 NUMBER

Market Area ID 3
MKT_AREA_TYP_3 VARCHAR2 (30)
Market Area Type 3
MKT_AREA_CD_3 VARCHAR2 (30)
Market Area Code 3
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MFG_ORG_CD
,      ORG_BSNS_UNIT_ID
,      ORG_CD
,      BSNS_UNIT_CD
,      GLBL_LOC_ID
,      GLBL_LOC_ID_TYP
,      BSNS_UNIT_NAME
,      ADDR_LOC_ID
,      ADDR_LOC_CD
,      GEO_SUB_RGN_ID
,      SUB_RGN_CD
,      RGN_CD
,      ADDR_TYP_CD
,      CHNL_TYP_CD
,      TIME_ZN
,      LONG_DESC
,      SCNDRY_DESC
,      ADDR_LINE
,      ADDR_USG
,      CITY
,      STATE
,      CNTRY
,      POST_CD
,      GEO_CD
,      ADDR_PHONE
,      EMAIL_ADDR
,      CNSTRCTN_STATUS
,      EXTRNL_NAME
,      CNTCT_NBR
,      CNTCT_TYP
,      LOC_TYP_CD
,      PRMRY_TRD_AREA_CD
,      PRMRY_MKT_AREA_CD
,      SHPNG_CNTR_TYP
,      BSNS_UNIT_CNCPT
,      TOT_LNR_DSTNC
,      VAT_RGN
,      VAT_INCLD_IND
,      ORG_DSTRCT_ID
,      DSTRCT_CD
,      DSTRCT_NAME
,      PRMRY_CRNCY_CD
,      PRMRY_CLNDR_CD
,      STORE_MGR
,      STORE_TYP
,      STORE_OPEN_DT
,      STORE_CLOSE_DT
,      FRMT_CD
,      USABLE_AREA
,      FRMT_DESC
,      DSGN_CNCPT
,      USG_TYP_CD
,      INV_AREA
,      SLNG_AREA
,      SZ_UNIT
,      NBR_OF_LOAD_DCKS
,      NBR_OF_UNLD_DCKS
,      NEW_STORE_IND
,      REMDL_DT
,      STORE_PRICE_INDX
,      NBR_OF_LVLS
,      NBR_OF_WNDW_DISP
,      AREA_OF_WNDW_DISP
,      FTNG_RMS_AVLBL
,      NBR_OF_EXTRNL_SIGN
,      RSTRMS_AVLBL_IND
,      PRKNG_AVLBL_IND
,      TYP_OF_PRKNG
,      DSTNC_TO_NEARST_CROSS_STREET
,      NAME_OF_NEARST_CROSS_STREET
,      STCKHLD_IND
,      TRNSFR_ZN_CD
,      TRNSFR_ZN_DESC
,      PRMTN_ZN
,      TOT_BLT_UP_AREA
,      TOT_SPR_BLT_UP_AREA
,      TERRAIN
,      STATE_FIPS_CD
,      STORE_VOL
,      WEEKLY_VOL
,      FULL_TIME_EMP_EQVLNTS
,      NBR_OF_CHECKOUTS
,      WRHS_SPCLTY
,      BRK_PAC_IND
,      HDR_CD
,      BNR_CD
,      HDR_NAME
,      NBR_OF_PGS
,      PUBLSH_DT
,      VALID_TILL_DT
,      WEB_SITE_URL
,      WEB_SITE_VRSN
,      REF_URL
,      REF_NAME
,      EFF_FROM_DT
,      EFF_TO_DT
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      CRTD_BY_DSR
,      LAST_UPDT_BY_DSR
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      BSNS_UNIT_TYP
,      DFLT_WHSE
,      MKT_AREA_ID_1
,      MKT_AREA_TYP_1
,      MKT_AREA_CD_1
,      MKT_AREA_ID_2
,      MKT_AREA_TYP_2
,      MKT_AREA_CD_2
,      MKT_AREA_ID_3
,      MKT_AREA_TYP_3
,      MKT_AREA_CD_3
FROM DDR.DDR_R_ORG_BSNS_UNIT;

Dependencies

[top of page]

DDR.DDR_R_ORG_BSNS_UNIT does not reference any database object

DDR.DDR_R_ORG_BSNS_UNIT is referenced by following:

SchemaAPPS
SynonymDDR_R_ORG_BSNS_UNIT
Materialized ViewDDR_R_ORG_BU_CHNLTYP_DN_MV