DBA Data[Home] [Help] [Dependency Information]

TABLE: QP.QP_ATTRIBUTE_GROUPS

Object Details
Object Name: QP_ATTRIBUTE_GROUPS
Object Type: TABLE
Owner: QP
FND Design Data: TableQP.QP_ATTRIBUTE_GROUPS
Subobject Name:
Status: VALID


Denormalized table for storing the pattern string for pattern based search.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QP_ATTRIBUTE_GROUPS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_HEADER_ID
ColumnLIST_LINE_ID
ColumnGROUPING_NO
QP_ATTRIBUTE_GROUPS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCACHE_KEY
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
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
FROM QP.QP_ATTRIBUTE_GROUPS;

Dependencies

[top of page]

QP.QP_ATTRIBUTE_GROUPS does not reference any database object

QP.QP_ATTRIBUTE_GROUPS is referenced by following:

SchemaAPPS
SynonymQP_ATTRIBUTE_GROUPS