Skip to content

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

TABLE: DDR.DDR_R_ORG

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


Stores information for retailer, manufacturer and competitor organizations


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DDR_R_ORG_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORG_CD
Columns
Name Datatype Length Mandatory Comments
MFG_ORG_CD VARCHAR2 (30) Yes Manufacturer Organization Code
ORG_CD VARCHAR2 (30) Yes Code for a Retailer Organization or Competitor Organization
ORG_TYP VARCHAR2 (30)
Organization Type
GLBL_LOC_ID VARCHAR2 (30) Yes Global Location ID
GLBL_LOC_ID_TYP VARCHAR2 (30) Yes Global Location ID Type
ORG_NAME VARCHAR2 (240)
Organization Name
SIC_CD VARCHAR2 (30)
Standard Industrial Classification Code - indicate the company's type of business
ADDR_LOC_CD VARCHAR2 (30)
Address Location Code
ADDR_TYP_CD VARCHAR2 (30)
Address Location Type
TIME_ZN VARCHAR2 (30)
Time Zone
SHORT_DESC VARCHAR2 (240)
Short Description
LONG_DESC VARCHAR2 (240)
Long Description
SCNDRY_DESC VARCHAR2 (240)
Secondary Description
ADDR_LINE VARCHAR2 (240)
Address
CITY VARCHAR2 (40)
City
STATE VARCHAR2 (40)
State
CNTRY VARCHAR2 (40)
Country
POST_CD VARCHAR2 (30)
Postal Code (Zip Code)
WEB_SITE_URL VARCHAR2 (240)
Web Site URL
PRMRY_CRNCY_CD VARCHAR2 (30)
Primary Currency Code
PRMRY_LANG VARCHAR2 (40)
Primary Language
ESTBD_DT DATE

Established Date
CNTCT_NBR VARCHAR2 (30)
Contact Number
CNTCT_TYP VARCHAR2 (30)
Contact Type
CNTCT_NAME VARCHAR2 (40)
Contact Name
CNTCT_EMAIL VARCHAR2 (240)
Contact E-mail
CNTCT_PHONE VARCHAR2 (30)
Contact Phone
FRNCHSE_CD VARCHAR2 (30)
Franchise Code
INDSTRY_SPFC_CD VARCHAR2 (30)
Industry Specific Code
DUNS_NBR VARCHAR2 (30)
Data Universal Numbering System is a unique nine-digit numbering system that is used to identify a business.
CR_RTNG_CD VARCHAR2 (30)
Credit Rating Code
INDVL_FIRM_CD VARCHAR2 (30)
Individual Firm Code
FIRST_APPEAR_YR NUMBER

The year when the product first launch in the market
DB_ADD_DT DATE

Date the organization was added to the database
SLS_VOL_CD VARCHAR2 (30)
Unique code of sales volume
PUB_IND VARCHAR2 (1)
Indicates whether company is public or not
STCK_EXCHNG_CD VARCHAR2 (30)
Stock Exchange Code
STCK_TCKR_SYMBL VARCHAR2 (30)
Stock Ticker Symbol
FICO_SCR VARCHAR2 (40)
FICO Score
TOT_EMP_SZ NUMBER

Total Employee Size
FULL_TIME_EMP_EQVLNTS NUMBER

Total number of full time employees all employees equal (full and part time)
NBR_OF_STORES NUMBER

Number of Stores
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
ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
ATTRIBUTE6 VARCHAR2 (240)
User defined attribute
ATTRIBUTE7 VARCHAR2 (240)
User defined attribute
ATTRIBUTE8 VARCHAR2 (240)
User defined attribute
ATTRIBUTE9 VARCHAR2 (240)
User defined attribute
ATTRIBUTE10 VARCHAR2 (240)
User defined attribute
ATTRIBUTE11 NUMBER

User defined attribute
ATTRIBUTE12 NUMBER

User defined attribute
ATTRIBUTE13 NUMBER

User defined attribute
ATTRIBUTE14 NUMBER

User defined attribute
ATTRIBUTE15 NUMBER

User defined attribute
ATTRIBUTE16 NUMBER

User defined attribute
ATTRIBUTE17 NUMBER

User defined attribute
ATTRIBUTE18 NUMBER

User defined attribute
ATTRIBUTE19 NUMBER

User defined attribute
ATTRIBUTE20 NUMBER

User defined attribute
Query Text

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


SELECT MFG_ORG_CD
,      ORG_CD
,      ORG_TYP
,      GLBL_LOC_ID
,      GLBL_LOC_ID_TYP
,      ORG_NAME
,      SIC_CD
,      ADDR_LOC_CD
,      ADDR_TYP_CD
,      TIME_ZN
,      SHORT_DESC
,      LONG_DESC
,      SCNDRY_DESC
,      ADDR_LINE
,      CITY
,      STATE
,      CNTRY
,      POST_CD
,      WEB_SITE_URL
,      PRMRY_CRNCY_CD
,      PRMRY_LANG
,      ESTBD_DT
,      CNTCT_NBR
,      CNTCT_TYP
,      CNTCT_NAME
,      CNTCT_EMAIL
,      CNTCT_PHONE
,      FRNCHSE_CD
,      INDSTRY_SPFC_CD
,      DUNS_NBR
,      CR_RTNG_CD
,      INDVL_FIRM_CD
,      FIRST_APPEAR_YR
,      DB_ADD_DT
,      SLS_VOL_CD
,      PUB_IND
,      STCK_EXCHNG_CD
,      STCK_TCKR_SYMBL
,      FICO_SCR
,      TOT_EMP_SZ
,      FULL_TIME_EMP_EQVLNTS
,      NBR_OF_STORES
,      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
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
FROM DDR.DDR_R_ORG;

Dependencies

[top of page]

DDR.DDR_R_ORG does not reference any database object

DDR.DDR_R_ORG is referenced by following:

SchemaAPPS
Materialized ViewDDR_R_MFG_ITEM_CLS_DN_MV
Materialized ViewDDR_R_MFG_ITEM_DIV_DN_MV
Materialized ViewDDR_R_MFG_ITEM_GRP_DN_MV
Materialized ViewDDR_R_MFG_ITEM_ITM_DN_MV
Materialized ViewDDR_R_MFG_ITEM_SBC_DN_MV
Materialized ViewDDR_R_MFG_ITEM_SKU_DN_MV
Materialized ViewDDR_R_ORG_AREA_DN_MV
Materialized ViewDDR_R_ORG_BU_CHNLTYP_DN_MV
Materialized ViewDDR_R_ORG_CHN_DN_MV
Materialized ViewDDR_R_ORG_DSTRCT_DN_MV
Materialized ViewDDR_R_ORG_RGN_DN_MV
Materialized ViewDDR_R_RTL_ITEM_CLS_DN_MV
Materialized ViewDDR_R_RTL_ITEM_DEPT_DN_MV
Materialized ViewDDR_R_RTL_ITEM_DIV_DN_MV
Materialized ViewDDR_R_RTL_ITEM_GRP_DN_MV
Materialized ViewDDR_R_RTL_ITEM_ITM_DN_MV
Materialized ViewDDR_R_RTL_ITEM_SBC_DN_MV
Materialized ViewDDR_R_RTL_ITEM_SKU_DN_MV
SchemaDDR
ViewDDR_R_ORG#