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

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LIST_HEADER_ID	NUMBER		Yes	Identifier for price list/modifier/factor list header
LIST_LINE_ID	NUMBER		Yes	Identifier for a price list/modifier/factor list line. -1 for a header pattern record.
ACTIVE_FLAG	VARCHAR2	(1)		Denormalized column from qp_list_headers_b.active_flag
LIST_TYPE_CODE	VARCHAR2	(30)		Denormalized column from qp_list_headers_b.list_type_code
START_DATE_ACTIVE_Q	DATE			Max value of qualifier start date across all the qualifiers (including those with operator_code 'NOT =' and 'BETWEEN') which are part of the same pattern for the list_header_id and list_line_id
END_DATE_ACTIVE_Q	DATE			Min value of qualifier end date across all the qualifiers (including those with operator_code 'NOT =' and 'BETWEEN') that are part of the same pattern for the list_header_id and list_line_id
PATTERN_ID	NUMBER		Yes	Identifier for the pattern. Maps to qp_patterns.pattern_id.
CURRENCY_CODE	VARCHAR2	(30)		Denormalized column from qp_list_headers_b.currency_code
ASK_FOR_FLAG	VARCHAR2	(1)		Denormalized column from qp_list_headers_b.ask_for_flag
LIMIT_EXISTS	VARCHAR2	(1)		Denoralized column from qp_list_headers_b.limit_exists_flag (for header pattern) or from qp_list_lines.limit_exists_flag (for line pattern)
SOURCE_SYSTEM_CODE	VARCHAR2	(10)		Denormalized column from qp_list_headers_b.source_system_code
EFFECTIVE_PRECEDENCE	NUMBER			Min precedence across qualifieres and product
GROUPING_NO	NUMBER			Qualifier grouping number
PRICING_PHASE_ID	NUMBER			Pricing phase ID for the list line for line patterns, -1 for header patterns
MODIFIER_LEVEL_CODE	VARCHAR2	(30)		Modifier level code for the list line for line patterns; null value for header patterns
HASH_KEY	VARCHAR2	(2000)		Concatenation of product, pricing, and qualifier attributes, delimited by the pipe character ('\|'). Maps to segment IDs in qp_patterns.pattern_string in the same order.
CACHE_KEY	VARCHAR2	(240)		Null for product patterns. For line patterns, if no product is attached, then same value as list_header_id; else, value is in the format 'list_header_id\|product_segment_id\|product_attribute_value'.
CREATION_DATE	DATE		Yes	Standard WHO column
CREATED_BY	NUMBER		Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO column
PROGRAM_APPLICATION_ID	NUMBER			Standard WHO column
PROGRAM_ID	NUMBER			Standard WHO column
PROGRAM_UPDATE_DATE	DATE			Standard WHO column
REQUEST_ID	NUMBER			Standard WHO column
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)
LIST_LINE_TYPE_CODE	VARCHAR2	(30)
QUALIFY_HIER_DESCENDENTS_FLAG	VARCHAR2	(1)
CURRENCY_HEADER_ID	NUMBER
OTHER_OPRT_COUNT	NUMBER
NULL_OTHER_OPRT_COUNT	NUMBER
HEADER_LIMIT_EXISTS	VARCHAR2	(1)
LINE_LIMIT_EXISTS	VARCHAR2	(1)
DESCENDENTS_QUALS_EXIST	VARCHAR2	(1)
PRICE_BREAK_TYPE_CODE	VARCHAR2	(30)
PTE_CODE	VARCHAR2	(30)

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
,      LIST_LINE_TYPE_CODE
,      QUALIFY_HIER_DESCENDENTS_FLAG
,      CURRENCY_HEADER_ID
,      OTHER_OPRT_COUNT
,      NULL_OTHER_OPRT_COUNT
,      HEADER_LIMIT_EXISTS
,      LINE_LIMIT_EXISTS
,      DESCENDENTS_QUALS_EXIST
,      PRICE_BREAK_TYPE_CODE
,      PTE_CODE
FROM APPS.QP_SECU_ATTR_GROUPS_V;

Dependencies

[top of page]

APPS.QP_SECU_ATTR_GROUPS_V references the following:

APPS: QP_ATTRIBUTE_GROUPS

APPS.QP_SECU_ATTR_GROUPS_V is referenced by following:

APPS: QP_PREQ_GRP - show dependent code