[Home] [Help] [Dependency Information]
Object Name: | QA_CHAR_ACTION_TRIGGERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QA.QA_CHAR_ACTION_TRIGGERS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | QA_CHAR_ACTION_TRIGGERS roe identifier | |
CHAR_ACTION_TRIGGER_ID | NUMBER | Yes | Collection element action trigger identifier | |
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 | ||
TRIGGER_SEQUENCE | NUMBER | Yes | Action trigger sequence | |
CHAR_ID | NUMBER | Yes | Collection element identifier | |
CHAR_NAME | VARCHAR2 | (30) | Yes | Collection element name |
VALUES_EXIST_FLAG | NUMBER | Yes | Flag to indicate if discreet values has been entered for collection element | |
SQL_STRING_FLAG | VARCHAR2 | (1) | flag to indicate if sql_validation_string exist for collection element | |
DATATYPE | NUMBER | Yes | collection element datatype | |
DECIMAL_PRECISION | NUMBER | Collection element decimal precision | ||
OPERATOR | NUMBER | Yes | Operator used in defining action | |
OPERATOR_MEANING | VARCHAR2 | (80) | Yes | Operator meaning |
LOW_VALUE_LOOKUP | NUMBER | Code for specification limit or user defined limit or collection element target value. If the value entered is equal to or greater than this value, trigger will be evaluated to TRUE based on the operator used. | ||
LOW_VALUE_MEANING | VARCHAR2 | (80) | Low value lookup code meaning | |
HIGH_VALUE_LOOKUP | NUMBER | Code for specification limit or user defined limit or collection element target value. If the value entered is equal to or less than this value, trigger will be evaluated to TRUE based on the operator used. | ||
HIGH_VALUE_MEANING | VARCHAR2 | (80) | High value lookup code meaning | |
LOW_VALUE_OTHER | VARCHAR2 | (150) | LOwer limit of the collection element value range as defined in the actiontrigger | |
LOW_VALUE_OTHER_ID | NUMBER | Low value other identifier | ||
HIGH_VALUE_OTHER | VARCHAR2 | (150) | Upper limit of the collection element value range as defined in ation trigger | |
HIGH_VALUE_OTHER_ID | NUMBER | High value other identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CHAR_ACTION_TRIGGER_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, TRIGGER_SEQUENCE
, CHAR_ID
, CHAR_NAME
, VALUES_EXIST_FLAG
, SQL_STRING_FLAG
, DATATYPE
, DECIMAL_PRECISION
, OPERATOR
, OPERATOR_MEANING
, LOW_VALUE_LOOKUP
, LOW_VALUE_MEANING
, HIGH_VALUE_LOOKUP
, HIGH_VALUE_MEANING
, LOW_VALUE_OTHER
, LOW_VALUE_OTHER_ID
, HIGH_VALUE_OTHER
, HIGH_VALUE_OTHER_ID
FROM APPS.QA_CHAR_ACTION_TRIGGERS_V;
APPS.QA_CHAR_ACTION_TRIGGERS_V is not referenced by any database object
|
|
|