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

TABLE: QP.QP_LIMITS

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


This table table holds the definition of the limit, and the Promotion, Deal or modifier for which the limit is set.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QP_LIMITS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIMIT_ID
QP_LIMITS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_HEADER_ID
ColumnLIST_LINE_ID
QP_LIMITS_U2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMULTIVAL_ATTR1_CONTEXT
ColumnMULTIVAL_ATTRIBUTE1
QP_LIMITS_U3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMULTIVAL_ATTR2_CONTEXT
ColumnMULTIVAL_ATTRIBUTE2
Columns
Name Datatype Length Mandatory Comments
LIMIT_ID NUMBER
Yes Identifies the Limit. System generated.
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
LIST_HEADER_ID NUMBER
Yes Identifies the List Header.
LIST_LINE_ID NUMBER

Identifies the List Line.
LIMIT_NUMBER NUMBER
Yes Limit sequence number within the List Header or List Line.
BASIS VARCHAR2 (30) Yes The basis for the Limit. Can be Revenue, Cost, Accrual Units, Quantity or Usage. Based on lookup type - QP_LIMIT_BASIS.
ORGANIZATION_FLAG VARCHAR2 (1) Yes Indicates whether the limit is across Sales Organizations or by each Sales Organization that a customer does business with.
LIMIT_LEVEL_CODE VARCHAR2 (30) Yes Indicates the level at which the limit is set. Based on Lookup Type -LIMIT_LEVEL.
LIMIT_EXCEED_ACTION_CODE VARCHAR2 (30) Yes Indicates the action to be taken if a limit is exceeded.Based on Lookup Type - LIMIT_EXCEED_ACTION.
LIMIT_HOLD_FLAG VARCHAR2 (1) Yes Indicates whether the pricing engine should return a hold status on the price request line if the limit is exceeded.
MULTIVAL_ATTR1_TYPE VARCHAR2 (30)
Indicates whether the multiple value attribute is a qualifier, product or pricing attribute.Based on Lookup Type -LIMIT_ATTRIBUTE _TYPE
MULTIVAL_ATTR1_CONTEXT VARCHAR2 (30)
Context in the Qualifier or Pricing Attribute Descriptive Flexfield.
MULTIVAL_ATTRIBUTE1 VARCHAR2 (30)
The attribute in the Qualifier or Pricing Descriptive Flexfield that represents the dimension for which the limit is set.
MULTIVAL_ATTR1_DATATYPE VARCHAR2 (10)
Indicates the datatype of the multiple value limit attribute. Denormalised from the Descriptive Flexfield Segment.
MULTIVAL_ATTR2_TYPE VARCHAR2 (30)
Indicates whether the multiple value attribute is a qualifier, product or pricing attribute.Based on Lookup Type -LIMIT_ATTRIBUTE _TYPE
MULTIVAL_ATTR2_CONTEXT VARCHAR2 (30)
Context in the Qualifier or Pricing Attribute Descriptive Flexfield.
MULTIVAL_ATTRIBUTE2 VARCHAR2 (30)
The attribute in the Qualifier or Pricing Descriptive Flexfield that represents the dimension for which the limit is set.
MULTIVAL_ATTR2_DATATYPE VARCHAR2 (10)
Indicates the datatype of the multiple value limit attribute. Denormalised from the Descriptive Flexfield Segment.
AMOUNT NUMBER
Yes Amount of the limit.
CONTEXT VARCHAR2 (30)
Descriptive Flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexfield segment.
ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexfield segment.
ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexfield segment.
ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexfield segment.
ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexfield segment.
ATTRIBUTE6 VARCHAR2 (240)
Descriptive Flexfield segment.
ATTRIBUTE7 VARCHAR2 (240)
Descriptive Flexfield segment.
ATTRIBUTE8 VARCHAR2 (240)
Descriptive Flexfield segment.
ATTRIBUTE9 VARCHAR2 (240)
Descriptive Flexfield segment.
ATTRIBUTE10 VARCHAR2 (240)
Descriptive Flexfield segment.
ATTRIBUTE11 VARCHAR2 (240)
Descriptive Flexfield segment.
ATTRIBUTE12 VARCHAR2 (240)
Descriptive Flexfield segment.
ATTRIBUTE13 VARCHAR2 (240)
Descriptive Flexfield segment.
ATTRIBUTE14 VARCHAR2 (240)
Descriptive Flexfield segment.
ATTRIBUTE15 VARCHAR2 (240)
Descriptive Flexfield segment.
EACH_ATTR_EXISTS VARCHAR2 (1)
Whether the limit has got Limit Attributes of type EACH or no.
NON_EACH_ATTR_COUNT NUMBER

It will store the count of NON-EACH Limit Attributes.
TOTAL_ATTR_COUNT NUMBER

Total count of all Limit Attributes including NON-EACH & EACH.
Query Text

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


SELECT LIMIT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      LIST_HEADER_ID
,      LIST_LINE_ID
,      LIMIT_NUMBER
,      BASIS
,      ORGANIZATION_FLAG
,      LIMIT_LEVEL_CODE
,      LIMIT_EXCEED_ACTION_CODE
,      LIMIT_HOLD_FLAG
,      MULTIVAL_ATTR1_TYPE
,      MULTIVAL_ATTR1_CONTEXT
,      MULTIVAL_ATTRIBUTE1
,      MULTIVAL_ATTR1_DATATYPE
,      MULTIVAL_ATTR2_TYPE
,      MULTIVAL_ATTR2_CONTEXT
,      MULTIVAL_ATTRIBUTE2
,      MULTIVAL_ATTR2_DATATYPE
,      AMOUNT
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      EACH_ATTR_EXISTS
,      NON_EACH_ATTR_COUNT
,      TOTAL_ATTR_COUNT
FROM QP.QP_LIMITS;

Dependencies

[top of page]

QP.QP_LIMITS does not reference any database object

QP.QP_LIMITS is referenced by following:

SchemaQP
ViewQP_LIMITS#