[Home] [Help] [Dependency Information]
Object Name: | AMS_QUERY_TEMP_INST_COND_ASSOC |
---|---|
Object Type: | TABLE |
Owner: | AMS |
FND Design Data: | AMS.AMS_QUERY_TEMP_INST_COND_ASSOC |
Subobject Name: | |
Status: | VALID |
This table provides condition selectivity within an INSTANCE. If the INSTANCE is for Admin, this table will have as many rows as template conditions. If the INSTANCE is for an End User, the table will have only rows corresponding to the conditions being used in a template.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AMS_QUERY_TEMP_INST_ASSOC_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ASSOC_ID |
AMS_QUERY_TEMP_INST_ASSOC_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TEMPLATE_INSTANCE_ID |
AMS_QUERY_TEMP_INST_ASSOC_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | QUERY_CONDITION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSOC_ID | NUMBER | Unique Identifier | ||
TEMPLATE_INSTANCE_ID | NUMBER | The template instance to which these assoc rows are tied. | ||
QUERY_CONDITION_ID | NUMBER | The query condition identifier whose instance has been created. | ||
CONDITION_SEQUENCE | NUMBER | The sequence in which the conditions should appear in the end user template instance. | ||
RUNNING_TOTAL | NUMBER | running total value | ||
DELTA | NUMBER | delta value | ||
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | This column is used for locking purposes | |
REQUEST_ID | NUMBER | (15) | Request identifier of last concurrent program to update this record | |
PROGRAM_ID | NUMBER | (15) | Program identifier of last concurrent program to update this record | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Application identifier of last concurrent program to update this record | |
PROGRAM_UPDATE_DATE | DATE | Last update date of this record by a concurrent program | ||
SECURITY_GROUP_ID | NUMBER | Column not currently used. |
Cut, paste (and edit) the following text to query this object:
SELECT ASSOC_ID
, TEMPLATE_INSTANCE_ID
, QUERY_CONDITION_ID
, CONDITION_SEQUENCE
, RUNNING_TOTAL
, DELTA
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, SECURITY_GROUP_ID
FROM AMS.AMS_QUERY_TEMP_INST_COND_ASSOC;
AMS.AMS_QUERY_TEMP_INST_COND_ASSOC does not reference any database object
AMS.AMS_QUERY_TEMP_INST_COND_ASSOC is referenced by following:
|
|
|