[Home] [Help] [Dependency Information]
Object Name: | QP_LIMIT_BALANCES |
---|---|
Object Type: | TABLE |
Owner: | QP |
FND Design Data: | QP.QP_LIMIT_BALANCES |
Subobject Name: | |
Status: | VALID |
QP_LIMIT_BALANCES holds the balances for a limit.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QP_LIMIT_BALANCES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | LIMIT_BALANCE_ID |
QP_LIMIT_BALANCES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LIMIT_ID
ORGANIZATION_ATTR_CONTEXT ORGANIZATION_ATTRIBUTE ORGANIZATION_ATTR_VALUE MULTIVAL_ATTR1_CONTEXT MULTIVAL_ATTRIBUTE1 MULTIVAL_ATTR1_VALUE MULTIVAL_ATTR2_CONTEXT MULTIVAL_ATTRIBUTE2 MULTIVAL_ATTR2_VALUE PRICE_REQUEST_CODE |
QP_LIMIT_BALANCES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
LIMIT_ID
PRICE_REQUEST_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LIMIT_BALANCE_ID | NUMBER | Yes | Identifies the Limit Balance. 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 | ||
LIMIT_ID | NUMBER | Yes | Identifies the Limit | |
ORGANIZATION_ATTR_CONTEXT | VARCHAR2 | (30) | Organization Context | |
ORGANIZATION_ATTRIBUTE | VARCHAR2 | (30) | Organization Attribute | |
ORGANIZATION_ATTR_VALUE | VARCHAR2 | (240) | Organization Attribute Value | |
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_VALUE | VARCHAR2 | (240) | The actual value for the attribute for which the balance is for. | |
MULTIVAL_ATTR1_DATATYPE | VARCHAR2 | (10) | Indicates the multiple value datatype of the 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_VALUE | VARCHAR2 | (240) | The actual value for the attribute for which the balance is for. | |
MULTIVAL_ATTR2_DATATYPE | VARCHAR2 | (10) | Indicates the datatype of the multiple value limit attribute. Denormalised from the Descriptive Flexfield Segment. | |
AVAILABLE_AMOUNT | NUMBER | Yes | Amount of limit available | |
RESERVED_AMOUNT | NUMBER | Yes | Amount of limit which has been reserved | |
CONSUMED_AMOUNT | NUMBER | Yes | Amount of limit which has been consumed | |
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 | |
PRICE_REQUEST_CODE | VARCHAR2 | (240) | Pricing transaction code. |
Cut, paste (and edit) the following text to query this object:
SELECT LIMIT_BALANCE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, LIMIT_ID
, ORGANIZATION_ATTR_CONTEXT
, ORGANIZATION_ATTRIBUTE
, ORGANIZATION_ATTR_VALUE
, MULTIVAL_ATTR1_TYPE
, MULTIVAL_ATTR1_CONTEXT
, MULTIVAL_ATTRIBUTE1
, MULTIVAL_ATTR1_VALUE
, MULTIVAL_ATTR1_DATATYPE
, MULTIVAL_ATTR2_TYPE
, MULTIVAL_ATTR2_CONTEXT
, MULTIVAL_ATTRIBUTE2
, MULTIVAL_ATTR2_VALUE
, MULTIVAL_ATTR2_DATATYPE
, AVAILABLE_AMOUNT
, RESERVED_AMOUNT
, CONSUMED_AMOUNT
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, PRICE_REQUEST_CODE
FROM QP.QP_LIMIT_BALANCES;
QP.QP_LIMIT_BALANCES does not reference any database object
QP.QP_LIMIT_BALANCES is referenced by following:
|
|
|