[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | DDR_I_ORG_BSNS_UNIT |
|---|---|
| Object Type: | TABLE |
| Owner: | DDR |
| Subobject Name: | |
| Status: | VALID |
Interface table to populate data in DDR_R_ORG_BSNS_UNIT
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| DDR_I_ORG_BSNS_UNIT_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 REC_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REC_ID | NUMBER | Yes | Record ID, uniquely identify each records. | |
| ORG_CD | VARCHAR2 | (30) | Organization Code | |
| BSNS_UNIT_CD | VARCHAR2 | (30) | Business Unit Code | |
| GLBL_LOC_ID | VARCHAR2 | (30) | Universally Unique Global Location ID for a perticular level of organization | |
| GLBL_LOC_ID_TYP | VARCHAR2 | (30) | An indicator of the identification sAn indicator of the identification scheme used to assign the global Location ID.cheme used to assign the global Location ID. | |
| BSNS_UNIT_NAME | VARCHAR2 | (240) | Business Unit Name | |
| 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) | Address Usage | |
| CITY | VARCHAR2 | (40) | City | |
| STATE | VARCHAR2 | (30) | State | |
| CNTRY | VARCHAR2 | (30) | Country | |
| POST_CD | VARCHAR2 | (30) | 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) | Extrernal Name | |
| CNTCT_NBR | VARCHAR2 | (30) | Contract Number | |
| CNTCT_TYP | VARCHAR2 | (30) | Contract 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) | Shipping 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. | |
| PRMRY_CRNCY_CD | VARCHAR2 | (30) | Primary Curreny Code | |
| PRMRY_CLNDR_CD | VARCHAR2 | (30) | Primary Calendar Code | |
| STORE_MGR | VARCHAR2 | (40) | Name of the store manager. | |
| STORE_TYP | VARCHAR2 | (30) | Possible values can include, Specialty, Grocery, Super Market, Convinience etc. | |
| STORE_OPEN_DT | DATE | Date the store opened for business | ||
| STORE_CLOSE_DT | DATE | Date the store closed for business | ||
| FRMT_CD | VARCHAR2 | (30) | Format Code | |
| USABLE_AREA | VARCHAR2 | (40) | The size of the part of the built area that is available for use (in size units) | |
| FRMT_DESC | VARCHAR2 | (240) | Format Description | |
| DSGN_CNCPT | VARCHAR2 | (240) | Design Concept | |
| USG_TYP_CD | VARCHAR2 | (30) | Usage Type Code | |
| INV_AREA | VARCHAR2 | (40) | Total Area (in size units) available for inventory | |
| SLNG_AREA | VARCHAR2 | (40) | Total Floor Area (in size units) available for selling. Showroom size. | |
| 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) | The flag that indicates , Is this a new store. | |
| REMDL_DT | DATE | The date on which the store was last remodeled. | ||
| STORE_PRICE_INDX | NUMBER | Price Index used in the store | ||
| NBR_OF_LVLS | NUMBER | Number of Levels | ||
| NBR_OF_WNDW_DISP | NUMBER | The total number of window displays available | ||
| AREA_OF_WNDW_DISP | NUMBER | The total area reserved for window displays | ||
| FTNG_RMS_AVLBL | VARCHAR2 | (40) | Identifies if fitting rooms are available at the site | |
| NBR_OF_EXTRNL_SIGN | NUMBER | The total number of external signs for a given site that are owned and displayed by the retailer | ||
| RSTRMS_AVLBL_IND | VARCHAR2 | (1) | Identifies if restrooms are available | |
| PRKNG_AVLBL_IND | VARCHAR2 | (1) | Identifies if restrooms are available | |
| TYP_OF_PRKNG | VARCHAR2 | (30) | Type Of Parking, e.g Free, Metered, Paid | |
| DSTNC_TO_NEARST_CROSS_STREET | VARCHAR2 | (40) | Distance from the cross street to the site | |
| NAME_OF_NEARST_CROSS_STREET | VARCHAR2 | (40) | The cross street nearest to the site | |
| 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 | |
| CNTY_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 fo 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 | (32) | The unique identifier of a banner. | |
| HDR_NAME | VARCHAR2 | (40) | Header name of catalogue | |
| NBR_OF_PGS | NUMBER | Header name of catalogue | ||
| PUBLSH_DT | DATE | The date of publish | ||
| VALID_TILL_DT | DATE | To which date the Organization catalogue is valid | ||
| WEB_SITE_URL | VARCHAR2 | (240) | Web site URL of the Organization | |
| WEB_SITE_VRSN | NUMBER | Web site version of the Organization | ||
| REF_URL | VARCHAR2 | (240) | Reference website URL of the Organization | |
| REF_NAME | VARCHAR2 | (40) | Name of the website from where the visitor has been redirected | |
| DEMOG_ATTR_CD_1 | VARCHAR2 | (30) | Demography attribute code | |
| DEMOG_GRP_CD_1 | VARCHAR2 | (30) | Demography group code | |
| DEMOG_ATTR_VAL_1 | VARCHAR2 | (40) | Demography value | |
| DEMOG_UOM_CD_1 | VARCHAR2 | (30) | Demography UOM code | |
| DEMOG_ATTR_CD_2 | VARCHAR2 | (30) | Demography attribute code | |
| DEMOG_GRP_CD_2 | VARCHAR2 | (30) | Demography group code | |
| DEMOG_ATTR_VAL_2 | VARCHAR2 | (40) | Demography value | |
| DEMOG_UOM_CD_2 | VARCHAR2 | (30) | Demography UOM code | |
| DEMOG_ATTR_CD_3 | VARCHAR2 | (30) | Demography attribute code | |
| DEMOG_GRP_CD_3 | VARCHAR2 | (30) | Demography group code | |
| DEMOG_ATTR_VAL_3 | VARCHAR2 | (40) | Demography value | |
| DEMOG_UOM_CD_3 | VARCHAR2 | (30) | Demography UOM code | |
| INV_LOC_CD_1 | VARCHAR2 | (30) | Inventory Location Code | |
| INV_LOC_TYP_CD_1 | VARCHAR2 | (30) | Inventory Location Type Code | |
| INV_LOC_DESC_1 | VARCHAR2 | (240) | Inventory Location Description | |
| LAYOUT_SHAPE_1 | VARCHAR2 | (40) | Inventory Layout Shape | |
| LNR_SZ_1 | NUMBER | The Linear floor size area of the Location. | ||
| SQR_SZ_1 | NUMBER | The Square floor size area of the Location. | ||
| CUBIC_SZ_1 | NUMBER | The Cubic floor size area of the Location. | ||
| LOC_CORDNT_X_1 | NUMBER | X coordinate of the Location | ||
| LOC_CORDNT_Y_1 | NUMBER | Y coordinate of the Location | ||
| LOC_CORDNT_Z_1 | NUMBER | Z coordinate of the Location | ||
| INV_UOM_CD_1 | VARCHAR2 | (30) | The code used to specify the units in which a value is being expressed | |
| SLNG_LOC_TYP_CD_1 | VARCHAR2 | (30) | Different types of selling location. These values can be, Shelf, Floor, Rack and so on. | |
| NBR_OF_FCNGS_1 | NUMBER | Number of Facings of the location | ||
| INV_LOC_CD_2 | VARCHAR2 | (30) | Inventory Location Code | |
| INV_LOC_TYP_CD_2 | VARCHAR2 | (30) | Inventory Location Type Code | |
| INV_LOC_DESC_2 | VARCHAR2 | (240) | Inventory Location Description | |
| LAYOUT_SHAPE_2 | VARCHAR2 | (40) | Inventory Layout Shape | |
| LNR_SZ_2 | NUMBER | The Linear floor size area of the Location. | ||
| SQR_SZ_2 | NUMBER | The Square floor size area of the Location. | ||
| CUBIC_SZ_2 | NUMBER | The Cubic floor size area of the Location. | ||
| LOC_CORDNT_X_2 | NUMBER | X coordinate of the Location | ||
| LOC_CORDNT_Y_2 | NUMBER | Y coordinate of the Location | ||
| LOC_CORDNT_Z_2 | NUMBER | Z coordinate of the Location | ||
| INV_UOM_CD_2 | VARCHAR2 | (30) | The code used to specify the units in which a value is being expressed | |
| SLNG_LOC_TYP_CD_2 | VARCHAR2 | (30) | Different types of selling location. These values can be, Shelf, Floor, Rack and so on. | |
| NBR_OF_FCNGS_2 | NUMBER | Number of Facings of the location | ||
| INV_LOC_CD_3 | VARCHAR2 | (30) | Inventory Location Code | |
| INV_LOC_TYP_CD_3 | VARCHAR2 | (30) | Inventory Location Type Code | |
| INV_LOC_DESC_3 | VARCHAR2 | (240) | Inventory Location Description | |
| LAYOUT_SHAPE_3 | VARCHAR2 | (40) | Inventory Layout Shape | |
| LNR_SZ_3 | NUMBER | The Linear floor size area of the Location. | ||
| SQR_SZ_3 | NUMBER | The Square floor size area of the Location. | ||
| CUBIC_SZ_3 | NUMBER | The Cubic floor size area of the Location. | ||
| LOC_CORDNT_X_3 | NUMBER | X coordinate of the Location | ||
| LOC_CORDNT_Y_3 | NUMBER | Y coordinate of the Location | ||
| LOC_CORDNT_Z_3 | NUMBER | Z coordinate of the Location | ||
| INV_UOM_CD_3 | VARCHAR2 | (30) | The code used to specify the units in which a value is being expressed | |
| SLNG_LOC_TYP_CD_3 | VARCHAR2 | (30) | Different types of selling location. These values can be, Shelf, Floor, Rack and so on. | |
| NBR_OF_FCNGS_3 | NUMBER | Number of Facings of the location | ||
| 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 | |
| BSNS_UNIT_TYP | VARCHAR2 | (30) | A unique dentifier for an Retail Store, Distribution Center or Administration Center that performed the transaction | |
| DFLT_WHSE | VARCHAR2 | (30) | Indicates the defaults warehouse of the perticular business unit | |
| TDLINX_STR_CD | VARCHAR2 | (7) | ||
| STR_STATUS | VARCHAR2 | (1) | ||
| SUB_CHNL_CD | VARCHAR2 | (30) | ||
| CMPNY_SIZE | VARCHAR2 | (30) | ||
| LAT | VARCHAR2 | (40) | ||
| LON | VARCHAR2 | (40) | ||
| STR_ACV_RANGE | VARCHAR2 | (30) | ||
| FAMILY_CD | VARCHAR2 | (5) | ||
| OWNER_OPER_NAME | VARCHAR2 | (32) | ||
| MKTG_GRP_NAME | VARCHAR2 | (32) | ||
| NON_CORP_OWNED | VARCHAR2 | (1) | ||
| GAS_SOLD_IND | VARCHAR2 | (1) | ||
| HIGH_VOL_CGRETTES_IND | VARCHAR2 | (1) | ||
| PHARM_IN_STR_IND | VARCHAR2 | (1) | ||
| LIQ_IN_STR_IND | VARCHAR2 | (1) | ||
| WINE_IN_STR_IND | VARCHAR2 | (1) | ||
| BEER_IN_STR_IND | VARCHAR2 | (1) | ||
| SERVE_ALCOHOL_IND | VARCHAR2 | (1) | ||
| ATTRIBUTE1 | VARCHAR2 | (240) | ||
| ATTRIBUTE2 | VARCHAR2 | (240) | ||
| ATTRIBUTE3 | VARCHAR2 | (240) | ||
| ATTRIBUTE4 | VARCHAR2 | (240) | ||
| ATTRIBUTE5 | VARCHAR2 | (240) | ||
| ATTRIBUTE6 | VARCHAR2 | (240) | ||
| ATTRIBUTE7 | VARCHAR2 | (240) | ||
| ATTRIBUTE8 | VARCHAR2 | (240) | ||
| ATTRIBUTE9 | VARCHAR2 | (240) | ||
| ATTRIBUTE10 | VARCHAR2 | (240) | ||
| ATTRIBUTE11 | NUMBER | |||
| ATTRIBUTE12 | NUMBER | |||
| ATTRIBUTE13 | NUMBER | |||
| ATTRIBUTE14 | NUMBER | |||
| ATTRIBUTE15 | NUMBER | |||
| ATTRIBUTE16 | NUMBER | |||
| ATTRIBUTE17 | NUMBER | |||
| ATTRIBUTE18 | NUMBER | |||
| ATTRIBUTE19 | NUMBER | |||
| ATTRIBUTE20 | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT REC_ID
, ORG_CD
, BSNS_UNIT_CD
, GLBL_LOC_ID
, GLBL_LOC_ID_TYP
, BSNS_UNIT_NAME
, 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
, 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
, CNTY_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
, DEMOG_ATTR_CD_1
, DEMOG_GRP_CD_1
, DEMOG_ATTR_VAL_1
, DEMOG_UOM_CD_1
, DEMOG_ATTR_CD_2
, DEMOG_GRP_CD_2
, DEMOG_ATTR_VAL_2
, DEMOG_UOM_CD_2
, DEMOG_ATTR_CD_3
, DEMOG_GRP_CD_3
, DEMOG_ATTR_VAL_3
, DEMOG_UOM_CD_3
, INV_LOC_CD_1
, INV_LOC_TYP_CD_1
, INV_LOC_DESC_1
, LAYOUT_SHAPE_1
, LNR_SZ_1
, SQR_SZ_1
, CUBIC_SZ_1
, LOC_CORDNT_X_1
, LOC_CORDNT_Y_1
, LOC_CORDNT_Z_1
, INV_UOM_CD_1
, SLNG_LOC_TYP_CD_1
, NBR_OF_FCNGS_1
, INV_LOC_CD_2
, INV_LOC_TYP_CD_2
, INV_LOC_DESC_2
, LAYOUT_SHAPE_2
, LNR_SZ_2
, SQR_SZ_2
, CUBIC_SZ_2
, LOC_CORDNT_X_2
, LOC_CORDNT_Y_2
, LOC_CORDNT_Z_2
, INV_UOM_CD_2
, SLNG_LOC_TYP_CD_2
, NBR_OF_FCNGS_2
, INV_LOC_CD_3
, INV_LOC_TYP_CD_3
, INV_LOC_DESC_3
, LAYOUT_SHAPE_3
, LNR_SZ_3
, SQR_SZ_3
, CUBIC_SZ_3
, LOC_CORDNT_X_3
, LOC_CORDNT_Y_3
, LOC_CORDNT_Z_3
, INV_UOM_CD_3
, SLNG_LOC_TYP_CD_3
, NBR_OF_FCNGS_3
, SRC_SYS_IDNT
, SRC_SYS_DT
, BSNS_UNIT_TYP
, DFLT_WHSE
, TDLINX_STR_CD
, STR_STATUS
, SUB_CHNL_CD
, CMPNY_SIZE
, LAT
, LON
, STR_ACV_RANGE
, FAMILY_CD
, OWNER_OPER_NAME
, MKTG_GRP_NAME
, NON_CORP_OWNED
, GAS_SOLD_IND
, HIGH_VOL_CGRETTES_IND
, PHARM_IN_STR_IND
, LIQ_IN_STR_IND
, WINE_IN_STR_IND
, BEER_IN_STR_IND
, SERVE_ALCOHOL_IND
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
FROM DDR.DDR_I_ORG_BSNS_UNIT;
DDR.DDR_I_ORG_BSNS_UNIT does not reference any database object
DDR.DDR_I_ORG_BSNS_UNIT is referenced by following:
DDR
DDR_I_ORG_BSNS_UNIT#
|
|
|
|