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]

VIEW: APPS.DDR_R_GEO_DEMOG_OPT_V

Object Details

Object Name:	DDR_R_GEO_DEMOG_OPT_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Comments
MFG_ORG_CD	VARCHAR2	(30)
GEO_DEMOG_ID	NUMBER
GEO_CD	VARCHAR2	(30)
GEO_VAL	VARCHAR2	(40)
GEO_DESC	VARCHAR2	(240)
ISO_CNTRY_CD	VARCHAR2	(30)
FMLY_TYP_CD	VARCHAR2	(30)
FMLY_TYP_CD_DESC	VARCHAR2	(240)	Family Type Description
EDU_LVL_CD	VARCHAR2	(30)
EDU_LVL_CD_DESC	VARCHAR2	(240)	Education Level Description
INDSTRY_CD	VARCHAR2	(30)
INDSTRY_CD_DESC	VARCHAR2	(240)	Industry Description
ANCSTRY_CD	VARCHAR2	(30)
ANCSTRY_CD_DESC	VARCHAR2	(240)	Ancestry Description
ML_TO_FML_RATIO	NUMBER
URBN_TO_RURAL_RATIO	NUMBER
MEDIAN_COMUT_TIME	NUMBER
AUTO_AVLBLTY_NBR	VARCHAR2	(30)
TOT_POPLTN	NUMBER
PVRTY_TOT	NUMBER		Total number at poverty level
RENT_TO_OWN_RATIO	NUMBER		Rent to Own Ratio
MEDIAN_RTRMNT_INCM	NUMBER
AVG_RM_NBR_PER_HM	NUMBER		Average room number per home
AVG_HSNG_VAL	NUMBER		Average housing value
AVG_HM_BLT_YR	NUMBER		Average Home Built Year
POPLTN_DNSTY	NUMBER		Population Density
POPLTN_DNSTY_UOM_CD	VARCHAR2	(30)
POPLTN_RATIO_WHT	NUMBER
POPLTN_RATIO_BLK	NUMBER		Population Ratio - Black
POPLTN_RATIO_ASIAN	NUMBER		Population Ratio - Asian
POPLTN_RATIO_HSPNIC	NUMBER		Population Ratio - Hispanic
POPLTN_RATIO_OTHR	NUMBER		Population Ratio - Other
POPLTN_MEDIAN_AGE	NUMBER		Population Median Age
HH_MEDIAN_SZ	NUMBER
HH_MEDIAN_INCM	NUMBER		Median household income
HH_AVG_INCM	NUMBER		Average household income
HH_PER_CPT_INCM	NUMBER		Per Capita Household Income
ANNUAL_HTNG_DEG_DAYS	NUMBER
ANNUAL_PRCPTN	NUMBER		Annual precipitation
ANNUAL_AVG_SNOWFL	NUMBER		Annual average snowfall
AVG_NBR_OF_DAYS_SNOW	NUMBER		Average number of days with snow
AVG_NBR_OF_DAYS_CLR	NUMBER		Average number of days with clear skies
AVG_NBR_OF_DAYS_RAIN	NUMBER		Average number of days with rain
CRIME_INDX	NUMBER		Crime index
EFF_FROM_DT	DATE
EFF_TO_DT	DATE

Query Text

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


SELECT MFG_ORG_CD
,      GEO_DEMOG_ID
,      GEO_CD
,      GEO_VAL
,      GEO_DESC
,      ISO_CNTRY_CD
,      FMLY_TYP_CD
,      FMLY_TYP_CD_DESC
,      EDU_LVL_CD
,      EDU_LVL_CD_DESC
,      INDSTRY_CD
,      INDSTRY_CD_DESC
,      ANCSTRY_CD
,      ANCSTRY_CD_DESC
,      ML_TO_FML_RATIO
,      URBN_TO_RURAL_RATIO
,      MEDIAN_COMUT_TIME
,      AUTO_AVLBLTY_NBR
,      TOT_POPLTN
,      PVRTY_TOT
,      RENT_TO_OWN_RATIO
,      MEDIAN_RTRMNT_INCM
,      AVG_RM_NBR_PER_HM
,      AVG_HSNG_VAL
,      AVG_HM_BLT_YR
,      POPLTN_DNSTY
,      POPLTN_DNSTY_UOM_CD
,      POPLTN_RATIO_WHT
,      POPLTN_RATIO_BLK
,      POPLTN_RATIO_ASIAN
,      POPLTN_RATIO_HSPNIC
,      POPLTN_RATIO_OTHR
,      POPLTN_MEDIAN_AGE
,      HH_MEDIAN_SZ
,      HH_MEDIAN_INCM
,      HH_AVG_INCM
,      HH_PER_CPT_INCM
,      ANNUAL_HTNG_DEG_DAYS
,      ANNUAL_PRCPTN
,      ANNUAL_AVG_SNOWFL
,      AVG_NBR_OF_DAYS_SNOW
,      AVG_NBR_OF_DAYS_CLR
,      AVG_NBR_OF_DAYS_RAIN
,      CRIME_INDX
,      EFF_FROM_DT
,      EFF_TO_DT
FROM APPS.DDR_R_GEO_DEMOG_OPT_V;

Dependencies

[top of page]

APPS.DDR_R_GEO_DEMOG_OPT_V references the following:

APPS: DDR_R_GEO_DEMOG
PUBLIC: DUAL

APPS.DDR_R_GEO_DEMOG_OPT_V is not referenced by any database object