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_ORD_ALLHIER_L_V

Object Details

Object Name:	QPR_ORD_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 Order dimension in the datamart.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ALL_DESC	VARCHAR2	(240)		Description of the members at the 'All Orders' level.
ALL_SR_LEVEL_PK	VARCHAR2	(240)		Identifier of the members at the 'All Orders' level.
ALL_ATTRIBUTE1	VARCHAR2	(240)		Attribute value of the member at the 'All Orders' level.
ALL_ATTRIBUTE2	VARCHAR2	(240)		Attribute value of the member at the 'All Orders' level.
ALL_ATTRIBUTE3	VARCHAR2	(240)		Attribute value of the member at the 'All Orders' level.
ALL_ATTRIBUTE4	VARCHAR2	(240)		Attribute value of the member at the 'All Orders' level.
ALL_ATTRIBUTE5	VARCHAR2	(240)		Attribute value of the member at the 'All Orders' level.
ORD_TYPE_DESC	VARCHAR2	(240)		Description of the members at the 'Order Type' level.
ORD_TYPE_SR_LEVEL_PK	VARCHAR2	(240)		Identifier of the members at the 'Order Type' level.
ORD_TYPE_ATTRIBUTE1	VARCHAR2	(240)		Attribute value of the member at the 'Order Type' level.
ORD_TYPE_ATTRIBUTE2	VARCHAR2	(240)		Attribute value of the member at the 'Order Type' level.
ORD_TYPE_ATTRIBUTE3	VARCHAR2	(240)		Attribute value of the member at the 'Order Type' level.
ORD_TYPE_ATTRIBUTE4	VARCHAR2	(240)		Attribute value of the member at the 'Order Type' level.
ORD_TYPE_ATTRIBUTE5	VARCHAR2	(240)		Attribute value of the member at the 'Order Type' level.
MOD_DESC	VARCHAR2	(240)		Description of the members at the 'Parent Model' level.
MOD_SR_LEVEL_PK	VARCHAR2	(240)		Identifier of the members at the 'Parent Model' level.
MOD_ATTRIBUTE1	VARCHAR2	(240)		Attribute value of the member at the 'Parent Model' level.
MOD_ATTRIBUTE2	VARCHAR2	(240)		Attribute value of the member at the 'Parent Model' level.
MOD_ATTRIBUTE3	VARCHAR2	(240)		Attribute value of the member at the 'Parent Model' level.
MOD_ATTRIBUTE4	VARCHAR2	(240)		Attribute value of the member at the 'Parent Model' level.
MOD_ATTRIBUTE5	VARCHAR2	(240)		Attribute value of the member at the 'Parent Model' level.
ORD_DESC	VARCHAR2	(240)		Description of the members at the 'Order Header' level.
ORD_SR_LEVEL_PK	VARCHAR2	(240)		Identifier of the members at the 'Order Header' level.
ORD_ATTRIBUTE1	VARCHAR2	(240)		Attribute value of the member at the 'Order Header' level.
ORD_ATTRIBUTE2	VARCHAR2	(240)		Attribute value of the member at the 'Order Header' level.
ORD_ATTRIBUTE3	VARCHAR2	(240)		Attribute value of the member at the 'Order Header' level.
ORD_ATTRIBUTE4	VARCHAR2	(240)		Attribute value of the member at the 'Order Header' level.
ORD_ATTRIBUTE5	VARCHAR2	(240)		Attribute value of the member at the 'Order Header' level.
TMOD_DESC	VARCHAR2	(240)		Description of the members at the 'Top Model' level.
TMOD_SR_LEVEL_PK	VARCHAR2	(240)		Identifier of the members at the 'Top Model' level.
TMOD_ATTRIBUTE1	VARCHAR2	(240)		Attribute value of the member at the 'Top Model' level.
TMOD_ATTRIBUTE2	VARCHAR2	(240)		Attribute value of the member at the 'Top Model' level.
TMOD_ATTRIBUTE3	VARCHAR2	(240)		Attribute value of the member at the 'Top Model' level.
TMOD_ATTRIBUTE4	VARCHAR2	(240)		Attribute value of the member at the 'Top Model' level.
TMOD_ATTRIBUTE5	VARCHAR2	(240)		Attribute value of the member at the 'Top Model' level.
ORD_LINE_DESC	VARCHAR2	(240)		Description of the members at the 'Order Line' level.
ORD_LINE_SR_LEVEL_PK	VARCHAR2	(240)		Identifier of the members at the 'Order Line' level.
ORD_LINE_ATTRIBUTE1	VARCHAR2	(240)		Attribute value of the member at the 'Order Line' level.
ORD_LINE_ATTRIBUTE2	VARCHAR2	(240)		Attribute value of the member at the 'Order Line' level.
ORD_LINE_ATTRIBUTE3	VARCHAR2	(240)		Attribute value of the member at the 'Order Line' level.
ORD_LINE_ATTRIBUTE4	VARCHAR2	(240)		Attribute value of the member at the 'Order Line' level.
ORD_LINE_ATTRIBUTE5	VARCHAR2	(240)		Attribute value of the member at the 'Order Line' level.
ORD_LINE_SP_DESC	VARCHAR2	(238)		Special Description of the order line level. This is mapped to the attribute at the order line 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 ALL_DESC
,      ALL_SR_LEVEL_PK
,      ALL_ATTRIBUTE1
,      ALL_ATTRIBUTE2
,      ALL_ATTRIBUTE3
,      ALL_ATTRIBUTE4
,      ALL_ATTRIBUTE5
,      ORD_TYPE_DESC
,      ORD_TYPE_SR_LEVEL_PK
,      ORD_TYPE_ATTRIBUTE1
,      ORD_TYPE_ATTRIBUTE2
,      ORD_TYPE_ATTRIBUTE3
,      ORD_TYPE_ATTRIBUTE4
,      ORD_TYPE_ATTRIBUTE5
,      MOD_DESC
,      MOD_SR_LEVEL_PK
,      MOD_ATTRIBUTE1
,      MOD_ATTRIBUTE2
,      MOD_ATTRIBUTE3
,      MOD_ATTRIBUTE4
,      MOD_ATTRIBUTE5
,      ORD_DESC
,      ORD_SR_LEVEL_PK
,      ORD_ATTRIBUTE1
,      ORD_ATTRIBUTE2
,      ORD_ATTRIBUTE3
,      ORD_ATTRIBUTE4
,      ORD_ATTRIBUTE5
,      TMOD_DESC
,      TMOD_SR_LEVEL_PK
,      TMOD_ATTRIBUTE1
,      TMOD_ATTRIBUTE2
,      TMOD_ATTRIBUTE3
,      TMOD_ATTRIBUTE4
,      TMOD_ATTRIBUTE5
,      ORD_LINE_DESC
,      ORD_LINE_SR_LEVEL_PK
,      ORD_LINE_ATTRIBUTE1
,      ORD_LINE_ATTRIBUTE2
,      ORD_LINE_ATTRIBUTE3
,      ORD_LINE_ATTRIBUTE4
,      ORD_LINE_ATTRIBUTE5
,      ORD_LINE_SP_DESC
,      INSTANCE_ID
FROM APPS.QPR_ORD_ALLHIER_L_V;

Dependencies

[top of page]

APPS.QPR_ORD_ALLHIER_L_V references the following:

APPS: QPR_DIMENSION_VALUES; QPR_MAINTAIN_AW - show dependent code; QPR_PLAN_MEASURES

APPS.QPR_ORD_ALLHIER_L_V is not referenced by any database object