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: QP.QP_ATTRIBUTE_GROUPS#

Object Details

Object Name:	QP_ATTRIBUTE_GROUPS#
Object Type:	VIEW
Owner:	QP
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
LIST_HEADER_ID	NUMBER		Yes
LIST_LINE_ID	NUMBER		Yes
ACTIVE_FLAG	VARCHAR2	(1)
LIST_TYPE_CODE	VARCHAR2	(30)
START_DATE_ACTIVE_Q	DATE
END_DATE_ACTIVE_Q	DATE
PATTERN_ID	NUMBER		Yes
CURRENCY_CODE	VARCHAR2	(30)
ASK_FOR_FLAG	VARCHAR2	(1)
LIMIT_EXISTS	VARCHAR2	(1)
SOURCE_SYSTEM_CODE	VARCHAR2	(10)
EFFECTIVE_PRECEDENCE	NUMBER
GROUPING_NO	NUMBER
PRICING_PHASE_ID	NUMBER
MODIFIER_LEVEL_CODE	VARCHAR2	(30)
HASH_KEY	VARCHAR2	(2000)
CACHE_KEY	VARCHAR2	(240)
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
REQUEST_ID	NUMBER
START_DATE_ACTIVE_FIRST	DATE
END_DATE_ACTIVE_FIRST	DATE
START_DATE_ACTIVE_SECOND	DATE
END_DATE_ACTIVE_SECOND	DATE
START_DATE_ACTIVE_L	DATE
END_DATE_ACTIVE_L	DATE
START_DATE_ACTIVE_H	DATE
END_DATE_ACTIVE_H	DATE
GLOBAL_FLAG	VARCHAR2	(1)
ORIG_ORG_ID	NUMBER
HEADER_QUALS_EXIST_FLAG	VARCHAR2	(1)
PRODUCT_UOM_CODE	VARCHAR2	(3)
ACTIVE_DATE_FIRST_TYPE	VARCHAR2	(30)
ACTIVE_DATE_SECOND_TYPE	VARCHAR2	(30)
EQ_FLAG	VARCHAR2	(1)
QUALIFY_HIER_DESCENDENTS_FLAG	VARCHAR2	(1)
LIST_LINE_TYPE_CODE	VARCHAR2	(30)
CURRENCY_HEADER_ID	NUMBER
OTHER_OPRT_COUNT	NUMBER
NULL_OTHER_OPRT_COUNT	NUMBER
HEADER_LIMIT_EXISTS	VARCHAR2	(1)
LINE_LIMIT_EXISTS	VARCHAR2	(1)
PRICE_BREAK_TYPE_CODE	VARCHAR2	(30)
DESCENDENTS_QUALS_EXIST	VARCHAR2	(1)
PTE_CODE	VARCHAR2	(30)
AUTOMATIC_FLAG	VARCHAR2	(1)

Query Text

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


SELECT LIST_HEADER_ID
,      LIST_LINE_ID
,      ACTIVE_FLAG
,      LIST_TYPE_CODE
,      START_DATE_ACTIVE_Q
,      END_DATE_ACTIVE_Q
,      PATTERN_ID
,      CURRENCY_CODE
,      ASK_FOR_FLAG
,      LIMIT_EXISTS
,      SOURCE_SYSTEM_CODE
,      EFFECTIVE_PRECEDENCE
,      GROUPING_NO
,      PRICING_PHASE_ID
,      MODIFIER_LEVEL_CODE
,      HASH_KEY
,      CACHE_KEY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      START_DATE_ACTIVE_FIRST
,      END_DATE_ACTIVE_FIRST
,      START_DATE_ACTIVE_SECOND
,      END_DATE_ACTIVE_SECOND
,      START_DATE_ACTIVE_L
,      END_DATE_ACTIVE_L
,      START_DATE_ACTIVE_H
,      END_DATE_ACTIVE_H
,      GLOBAL_FLAG
,      ORIG_ORG_ID
,      HEADER_QUALS_EXIST_FLAG
,      PRODUCT_UOM_CODE
,      ACTIVE_DATE_FIRST_TYPE
,      ACTIVE_DATE_SECOND_TYPE
,      EQ_FLAG
,      QUALIFY_HIER_DESCENDENTS_FLAG
,      LIST_LINE_TYPE_CODE
,      CURRENCY_HEADER_ID
,      OTHER_OPRT_COUNT
,      NULL_OTHER_OPRT_COUNT
,      HEADER_LIMIT_EXISTS
,      LINE_LIMIT_EXISTS
,      PRICE_BREAK_TYPE_CODE
,      DESCENDENTS_QUALS_EXIST
,      PTE_CODE
,      AUTOMATIC_FLAG
FROM QP.QP_ATTRIBUTE_GROUPS#;

Dependencies

[top of page]

QP.QP_ATTRIBUTE_GROUPS# references the following:

QP: QP_ATTRIBUTE_GROUPS

QP.QP_ATTRIBUTE_GROUPS# is referenced by following:

APPS: QP_ATTRIBUTE_GROUPS