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_I_MKT_AREA

Object Details

Object Name:	DDR_I_MKT_AREA
Object Type:	TABLE
Owner:	DDR
Subobject Name:
Status:	VALID

Interface table to populate data in DDR_R_MKT_AREA

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
DDR_I_MKT_AREA_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REC_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REC_ID	NUMBER		Yes	Record ID, uniquely identify each records.
MFG_ORG_CD	VARCHAR2	(30)		Manufacturer Organization Code
MKT_AREA_CD	VARCHAR2	(30)		Unique identifire for market area.
MKT_AREA_NAME	VARCHAR2	(40)		Market area name
MKT_AREA_DESC	VARCHAR2	(240)		Market area description
DEFN_TYP	VARCHAR2	(30)		Some of the standard classifications can include: Study traffic flowm, Use a retail gravity model, Use a zip code method etc.
PRMRY_ZIP_CD	VARCHAR2	(30)		Primary zip code of the market area.
SCNDRY_ZIP_CD	VARCHAR2	(30)		Applicable only in case the zip code spans across multiple zip codes
AREA_SHAPE	VARCHAR2	(40)		Types of market area shape.Eg. Rings,Donut Rings,Drive-time polygons etc.
AREA_TYP	VARCHAR2	(30)		Type of market area. Eg. Urban,Suburban,Exurban,Rural etc
MKT_AREA_UOM_CD	VARCHAR2	(30)		This is the unit of measure used to measure the size of the trading area i.e. miles, minutes, etc
CNTY	VARCHAR2	(40)
CITY	VARCHAR2	(40)		City in which the market area belongs
STATE	VARCHAR2	(40)		State or province
CNTRY	VARCHAR2	(40)		Country
TRD_AREA_CPTR	NUMBER
TOT_POPLTN	NUMBER			Estimated total population of the market area
STATE_POPLTN	NUMBER			Approximate population of the state
STATE_SLS	NUMBER			Extimated total retail sales in the state
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
MKT_AREA_TYP	VARCHAR2	(30)		Market area information provider.
RANKING	NUMBER			Rank of Market Area
ATTRIBUTE1	VARCHAR2	(40)		Provision to intoduce extra attributes
ATTRIBUTE2	VARCHAR2	(40)		Provision to intoduce extra attributes
ATTRIBUTE3	VARCHAR2	(40)		Provision to intoduce extra attributes
ATTRIBUTE4	VARCHAR2	(40)		Provision to intoduce extra attributes
ATTRIBUTE5	VARCHAR2	(40)		Provision to intoduce extra attributes
ATTRIBUTE6	VARCHAR2	(40)		Provision to intoduce extra attributes
ATTRIBUTE7	VARCHAR2	(40)		Provision to intoduce extra attributes
ATTRIBUTE8	VARCHAR2	(40)		Provision to intoduce extra attributes
ATTRIBUTE9	VARCHAR2	(40)		Provision to intoduce extra attributes
ATTRIBUTE10	VARCHAR2	(40)		Provision to intoduce extra attributes

Query Text

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


SELECT REC_ID
,      MFG_ORG_CD
,      MKT_AREA_CD
,      MKT_AREA_NAME
,      MKT_AREA_DESC
,      DEFN_TYP
,      PRMRY_ZIP_CD
,      SCNDRY_ZIP_CD
,      AREA_SHAPE
,      AREA_TYP
,      MKT_AREA_UOM_CD
,      CNTY
,      CITY
,      STATE
,      CNTRY
,      TRD_AREA_CPTR
,      TOT_POPLTN
,      STATE_POPLTN
,      STATE_SLS
,      SRC_SYS_IDNT
,      SRC_SYS_DT
,      MKT_AREA_TYP
,      RANKING
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
FROM DDR.DDR_I_MKT_AREA;

Dependencies

[top of page]

DDR.DDR_I_MKT_AREA does not reference any database object

DDR.DDR_I_MKT_AREA is referenced by following:

APPS: DDR_I_MKT_AREA