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.QPR_GEO_ALLHIER_L_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

Mapping view for geography dimension in the datamart

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TP_SITE_DESC	VARCHAR2	(240)		Description of the members at the 'Customer Site' level.
TP_SITE_SR_LEVEL_PK	VARCHAR2	(240)		Identifier of the members at the 'Customer Site' level.
TP_SITE_ATTRIBUTE1	VARCHAR2	(240)		Attribute value of the member at the 'Customer Site' level.
TP_SITE_ATTRIBUTE2	VARCHAR2	(240)		Attribute value of the member at the 'Customer Site' level.
TP_SITE_ATTRIBUTE3	VARCHAR2	(240)		Attribute value of the member at the 'Customer Site' level.
TP_SITE_ATTRIBUTE4	VARCHAR2	(240)		Attribute value of the member at the 'Customer Site' level.
TP_SITE_ATTRIBUTE5	VARCHAR2	(240)		Attribute value of the member at the 'Customer Site' level.
REG_DESC	VARCHAR2	(240)		Description of the members at the 'Region' level.
REG_SR_LEVEL_PK	VARCHAR2	(240)		Identifier of the members at the 'Region' level.
REG_ATTRIBUTE1	VARCHAR2	(240)		Attribute value of the member at the 'Region' level.
REG_ATTRIBUTE2	VARCHAR2	(240)		Attribute value of the member at the 'Region' level.
REG_ATTRIBUTE3	VARCHAR2	(240)		Attribute value of the member at the 'Region' level.
REG_ATTRIBUTE4	VARCHAR2	(240)		Attribute value of the member at the 'Region' level.
REG_ATTRIBUTE5	VARCHAR2	(240)		Attribute value of the member at the 'Region' level.
GS_DESC	VARCHAR2	(240)		Description of the members at the 'Geography Segment' level.
GS_SR_LEVEL_PK	VARCHAR2	(240)		Identifier of the members at the 'Geography Segment' level.
GS_ATTRIBUTE1	VARCHAR2	(240)		Attribute value of the member at the 'Geography Segment' level.
GS_ATTRIBUTE2	VARCHAR2	(240)		Attribute value of the member at the 'Geography Segment' level.
GS_ATTRIBUTE3	VARCHAR2	(240)		Attribute value of the member at the 'Geography Segment' level.
GS_ATTRIBUTE4	VARCHAR2	(240)		Attribute value of the member at the 'Geography Segment' level.
GS_ATTRIBUTE5	VARCHAR2	(240)		Attribute value of the member at the 'Geography Segment' level.
COUNTRY_DESC	VARCHAR2	(240)		Description of the members at the 'Country' level.
COUNTRY_SR_LEVEL_PK	VARCHAR2	(240)		Identifier of the members at the 'Country' level.
COUNTRY_ATTRIBUTE1	VARCHAR2	(240)		Attribute value of the member at the 'Country' level.
COUNTRY_ATTRIBUTE2	VARCHAR2	(240)		Attribute value of the member at the 'Country' level.
COUNTRY_ATTRIBUTE3	VARCHAR2	(240)		Attribute value of the member at the 'Country' level.
COUNTRY_ATTRIBUTE4	VARCHAR2	(240)		Attribute value of the member at the 'Country' level.
COUNTRY_ATTRIBUTE5	VARCHAR2	(240)		Attribute value of the member at the 'Country' level.
AREA_DESC	VARCHAR2	(240)		Description of the members at the 'Area' level.
AREA_SR_LEVEL_PK	VARCHAR2	(240)		Identifier of the members at the 'Area' level.
AREA_ATTRIBUTE1	VARCHAR2	(240)		Attribute value of the member at the 'Area' level.
AREA_ATTRIBUTE2	VARCHAR2	(240)		Attribute value of the member at the 'Area' level.
AREA_ATTRIBUTE3	VARCHAR2	(240)		Attribute value of the member at the 'Area' level.
AREA_ATTRIBUTE4	VARCHAR2	(240)		Attribute value of the member at the 'Area' level.
AREA_ATTRIBUTE5	VARCHAR2	(240)		Attribute value of the member at the 'Area' level.
ALL_GEO_DESC	VARCHAR2	(240)		Description of the members at the 'All Geographies' level.
ALL_GEO_SR_LEVEL_PK	VARCHAR2	(240)		Identifier of the members at the 'All Geographies' level.
ALL_GEO_ATTRIBUTE1	VARCHAR2	(240)		Attribute value of the member at the 'All Geographies' level.
ALL_GEO_ATTRIBUTE2	VARCHAR2	(240)		Attribute value of the member at the 'All Geographies' level.
ALL_GEO_ATTRIBUTE3	VARCHAR2	(240)		Attribute value of the member at the 'All Geographies' level.
ALL_GEO_ATTRIBUTE4	VARCHAR2	(240)		Attribute value of the member at the 'All Geographies' level.
ALL_GEO_ATTRIBUTE5	VARCHAR2	(240)		Attribute value of the member at the 'All Geographies' level.
INSTANCE_ID	NUMBER		Yes	Unique identifier of the application instance from which the data is sourced.

Query Text

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


SELECT TP_SITE_DESC
,      TP_SITE_SR_LEVEL_PK
,      TP_SITE_ATTRIBUTE1
,      TP_SITE_ATTRIBUTE2
,      TP_SITE_ATTRIBUTE3
,      TP_SITE_ATTRIBUTE4
,      TP_SITE_ATTRIBUTE5
,      REG_DESC
,      REG_SR_LEVEL_PK
,      REG_ATTRIBUTE1
,      REG_ATTRIBUTE2
,      REG_ATTRIBUTE3
,      REG_ATTRIBUTE4
,      REG_ATTRIBUTE5
,      GS_DESC
,      GS_SR_LEVEL_PK
,      GS_ATTRIBUTE1
,      GS_ATTRIBUTE2
,      GS_ATTRIBUTE3
,      GS_ATTRIBUTE4
,      GS_ATTRIBUTE5
,      COUNTRY_DESC
,      COUNTRY_SR_LEVEL_PK
,      COUNTRY_ATTRIBUTE1
,      COUNTRY_ATTRIBUTE2
,      COUNTRY_ATTRIBUTE3
,      COUNTRY_ATTRIBUTE4
,      COUNTRY_ATTRIBUTE5
,      AREA_DESC
,      AREA_SR_LEVEL_PK
,      AREA_ATTRIBUTE1
,      AREA_ATTRIBUTE2
,      AREA_ATTRIBUTE3
,      AREA_ATTRIBUTE4
,      AREA_ATTRIBUTE5
,      ALL_GEO_DESC
,      ALL_GEO_SR_LEVEL_PK
,      ALL_GEO_ATTRIBUTE1
,      ALL_GEO_ATTRIBUTE2
,      ALL_GEO_ATTRIBUTE3
,      ALL_GEO_ATTRIBUTE4
,      ALL_GEO_ATTRIBUTE5
,      INSTANCE_ID
FROM APPS.QPR_GEO_ALLHIER_L_V;

Dependencies

[top of page]

APPS.QPR_GEO_ALLHIER_L_V references the following:

APPS: QPR_DIMENSION_VALUES; QPR_MAINTAIN_AW - show dependent code; QPR_PLAN_MEASURES

APPS.QPR_GEO_ALLHIER_L_V is not referenced by any database object