[Home] [Help] [Dependency Information]
Object Name: | QA_PLAN_COLLECTION_TRIGGERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QA.QA_PLAN_COLLECTION_TRIGGERS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Identifies row in qa_plan_collection_triggers | |
TXN_TRIGGER_ID | NUMBER | Yes | Unique identifier to collection trigger | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
PLAN_ID | NUMBER | Yes | Collection plan identifier | |
PLAN_TRANSACTION_ID | NUMBER | Yes | Plan transaction identifier | |
COLLECTION_TRIGGER_ID | NUMBER | Yes | Collection trigger identifier | |
TRANSACTION_NUMBER | NUMBER | Yes | Transaction number of the parent transaction | |
PLAN_NAME | VARCHAR2 | (30) | Yes | Collection plan name |
TRANSACTION_DESCRIPTION | VARCHAR2 | (240) | Transaction description | |
COLLECTION_TRIGGER_DESCRIPTION | VARCHAR2 | (30) | Yes | Collection trigger description. |
DATATYPE | NUMBER | Yes | Datatype of the collection trigger | |
DECIMAL_PRECISION | NUMBER | Decimal precision of Collection trigger | ||
OPERATOR | NUMBER | Yes | Operator used in defining the trigger | |
OPERATOR_MEANING | VARCHAR2 | (80) | Yes | Meaning of the operator |
LOW_VALUE | VARCHAR2 | (150) | Low value to the range of the collection trigger as defined in the trigger | |
LOW_VALUE_ID | NUMBER | Flex field identifier for the collection element which are flex fields | ||
HIGH_VALUE | VARCHAR2 | (150) | High value to the range of the collection trigger as defined in the trigger | |
HIGH_VALUE_ID | NUMBER | Flex field identifier for the collection element which are flex fields |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, TXN_TRIGGER_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, PLAN_ID
, PLAN_TRANSACTION_ID
, COLLECTION_TRIGGER_ID
, TRANSACTION_NUMBER
, PLAN_NAME
, TRANSACTION_DESCRIPTION
, COLLECTION_TRIGGER_DESCRIPTION
, DATATYPE
, DECIMAL_PRECISION
, OPERATOR
, OPERATOR_MEANING
, LOW_VALUE
, LOW_VALUE_ID
, HIGH_VALUE
, HIGH_VALUE_ID
FROM APPS.QA_PLAN_COLLECTION_TRIGGERS_V;
APPS.QA_PLAN_COLLECTION_TRIGGERS_V is not referenced by any database object
|
|
|