[Home] [Help] [Dependency Information]
Object Name: | ASO_SUP_INSTANCE_VALUE |
---|---|
Object Type: | TABLE |
Owner: | ASO |
FND Design Data: | ASO.ASO_SUP_INSTANCE_VALUE |
Subobject Name: | |
Status: | VALID |
This table is to store the instance value of the template. When user ties the template to Quote and provides value for the Components, those values are stored in this table. It could be a user entered value or it could be a pre-defined response user can select from.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ASO_SUP_INSTANCE_VALUE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | INSTANCE_VALUE_ID |
SYS_IL0000192694C00029$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
ASO_SUP_INSTANCE_VALUE_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TEMPLATE_INSTANCE_ID
SECT_COMP_MAP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INSTANCE_VALUE_ID | NUMBER | Yes | Instance Value Id | |
SECT_COMP_MAP_ID | NUMBER | Yes | Section Component Mapping Id | |
TEMPLATE_INSTANCE_ID | NUMBER | Yes | Template Instance id | |
VALUE | VARCHAR2 | (2000) | Value | |
RESPONSE_ID | NUMBER | Response Id | ||
VALUE_TYPE_QUALIFIER | VARCHAR2 | (80) | Value Type Qualifier | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CONTEXT | VARCHAR2 | (30) | Context | |
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 | |
SECURITY_GROUP_ID | NUMBER | Security Group Id | ||
RTFDATA | BLOB | (4000) | The RTF data, which is a binary LOB | |
FILE_ID | NUMBER | File Identifier - Used to Store Sales Supplement File Reference | ||
ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive flexfield segment | |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number |
Cut, paste (and edit) the following text to query this object:
SELECT INSTANCE_VALUE_ID
, SECT_COMP_MAP_ID
, TEMPLATE_INSTANCE_ID
, VALUE
, RESPONSE_ID
, VALUE_TYPE_QUALIFIER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, RTFDATA
, FILE_ID
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, OBJECT_VERSION_NUMBER
FROM ASO.ASO_SUP_INSTANCE_VALUE;
ASO.ASO_SUP_INSTANCE_VALUE does not reference any database object
ASO.ASO_SUP_INSTANCE_VALUE is referenced by following:
|
|
|