eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
DDR_R_ORG_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORG_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	(40)		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

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
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:

APPS: DDR_R_MFG_ITEM_CLS_DN_MV; DDR_R_MFG_ITEM_DIV_DN_MV; DDR_R_MFG_ITEM_GRP_DN_MV; DDR_R_MFG_ITEM_ITM_DN_MV; DDR_R_MFG_ITEM_SBC_DN_MV; DDR_R_MFG_ITEM_SKU_DN_MV; DDR_R_ORG; DDR_R_ORG_AREA_DN_MV; DDR_R_ORG_BU_CHNLTYP_DN_MV; DDR_R_ORG_CHN_DN_MV; DDR_R_ORG_DSTRCT_DN_MV; DDR_R_ORG_RGN_DN_MV; DDR_R_RTL_ITEM_CLS_DN_MV; DDR_R_RTL_ITEM_DEPT_DN_MV; DDR_R_RTL_ITEM_DIV_DN_MV; DDR_R_RTL_ITEM_GRP_DN_MV; DDR_R_RTL_ITEM_ITM_DN_MV; DDR_R_RTL_ITEM_SBC_DN_MV; DDR_R_RTL_ITEM_SKU_DN_MV