[Home] [Help] [Dependency Information]
Object Name: | QP_PRC_CONTEXTS_B |
---|---|
Object Type: | TABLE |
Owner: | QP |
FND Design Data: | QP.QP_PRC_CONTEXTS_B |
Subobject Name: | |
Status: | VALID |
This table stores all the Context definition and their details. Contexts are logical grouping of attributes that are used by Pricing module to determine the final price. The context may be qualifier, product or a pricing context, depending on the type.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QP_PRC_CONTEXTS_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PRC_CONTEXT_ID |
QP_PRC_CONTEXTS_B_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PRC_CONTEXT_TYPE
PRC_CONTEXT_CODE |
QP_PRC_CONTEXTS_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PRC_CONTEXT_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRC_CONTEXT_ID | NUMBER | Yes | System generated unique identifier | |
PRC_CONTEXT_CODE | VARCHAR2 | (30) | Yes | User entered non-unique identifier code |
PRC_CONTEXT_TYPE | VARCHAR2 | (30) | Yes | Indicates the type of context. A context may be a Qualifier, Pricing or a Product context. For a given context, combination of PRC_CONTEXT_CODE and PRC_CONTEXT_TYPE is unique. |
SEEDED_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the context is a part of seed data. |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the context is enabled or not. |
CONTEXT | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield structure | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield structure | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield structure | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield structure | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield structure | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield structure | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield structure | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield structure | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield structure | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield structure | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield structure | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield structure | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield structure | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield structure | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield structure | |
CREATED_BY | NUMBER | Yes | Standard WHO column | |
CREATION_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column | |
LAST_UPDATE_DATE | DATE | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT PRC_CONTEXT_ID
, PRC_CONTEXT_CODE
, PRC_CONTEXT_TYPE
, SEEDED_FLAG
, ENABLED_FLAG
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM QP.QP_PRC_CONTEXTS_B;
QP.QP_PRC_CONTEXTS_B does not reference any database object
QP.QP_PRC_CONTEXTS_B is referenced by following:
|
|
|