Skip to content

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

TABLE: DDR.DDR_I_ORG

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


Interface table to populate data in DDR_R_ORG


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
DDR_I_ORG_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREC_ID
Columns
Name Datatype Length Mandatory Comments
REC_ID NUMBER
Yes Record ID, uniquely identify each records.
MFG_ORG_CD VARCHAR2 (30)
Manufacture Organization code
ORG_CD VARCHAR2 (30)
Organization code
ORG_TYP VARCHAR2 (30)
Organization type (retailer/manufacturer/competitor)
GLBL_LOC_ID VARCHAR2 (30)
Global location ID
GLBL_LOC_ID_TYP VARCHAR2 (30)
Global location ID type
ORG_NAME VARCHAR2 (240)
Organization name
SIC_CD VARCHAR2 (30)
Standard Industrial Classification code
SHORT_DESC VARCHAR2 (240)
Organization description
LONG_DESC VARCHAR2 (240)
Organization description
SCNDRY_DESC VARCHAR2 (240)
Organization description
WEB_SITE_URL VARCHAR2 (240)
Web site URL of Organization
PRMRY_CRNCY_CD VARCHAR2 (30)
currency code of organization
PRMRY_LANG VARCHAR2 (40)
Language of organization
ESTBD_DT DATE

Date of establishment of organization
CNTCT_NBR VARCHAR2 (30)
organization contact number
CNTCT_TYP VARCHAR2 (30)
organization contact type
CNTCT_NAME VARCHAR2 (40)
Name of the contact person of Organization
CNTCT_EMAIL VARCHAR2 (240)
E-mail address of Organization
CNTCT_PHONE VARCHAR2 (30)
organization phone number
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 number of employee
FULL_TIME_EMP_EQVLNTS NUMBER

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

Total number of store of the organization
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
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 REC_ID
,      MFG_ORG_CD
,      ORG_CD
,      ORG_TYP
,      GLBL_LOC_ID
,      GLBL_LOC_ID_TYP
,      ORG_NAME
,      SIC_CD
,      SHORT_DESC
,      LONG_DESC
,      SCNDRY_DESC
,      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
,      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;

Dependencies

[top of page]

DDR.DDR_I_ORG does not reference any database object

DDR.DDR_I_ORG is referenced by following:

SchemaDDR
ViewDDR_I_ORG#