[Home] [Help] [Dependency Information]
Object Name: | QA_PLAN_CHAR_ACTION_TRIGGERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QA.QA_PLAN_CHAR_ACTION_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_CHAR_ACTION_TRIGGERS | |
PLAN_CHAR_ACTION_TRIGGER_ID | NUMBER | Yes | Action trigger identifier for the given plan and collection element | |
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 | Sequence in which trigger is defined | |
PLAN_ID | NUMBER | Yes | Collection plan identifier | |
PLAN_NAME | VARCHAR2 | (30) | Yes | Collection plan name |
VALUES_EXIST_FLAG | NUMBER | Yes | Flag to indicate if master set of values exist for the collection element | |
SQL_STRING_FLAG | VARCHAR2 | (1) | Flag to indicate if SQL validation string exists for collection elements | |
DATATYPE | NUMBER | Yes | Collection element datatype | |
DECIMAL_PRECISION | NUMBER | Collection element decimal precision | ||
CHAR_ID | NUMBER | Yes | Collection element identifier | |
CHAR_NAME | VARCHAR2 | (30) | Yes | Collection element name |
OPERATOR | NUMBER | Yes | Operator used in defining the action rule | |
OPERATOR_MEANING | VARCHAR2 | (80) | Yes | Meaning of the operator |
LOW_VALUE_LOOKUP | NUMBER | Code for specification limit or user defined limit or collection element target value | ||
LOW_VALUE_MEANING | VARCHAR2 | (80) | Lookup code meaning | |
HIGH_VALUE_LOOKUP | NUMBER | Code for specification limit or user defined limit or collection element target value | ||
HIGH_VALUE_MEANING | VARCHAR2 | (80) | Lookup code meaning | |
LOW_VALUE_OTHER | VARCHAR2 | (150) | Lower limit for the collection element value range | |
LOW_VALUE_OTHER_ID | NUMBER | Stores flex field id for collection elements that are flex fields | ||
HIGH_VALUE_OTHER | VARCHAR2 | (150) | Upper limit for the collection element value range | |
HIGH_VALUE_OTHER_ID | NUMBER | Stores flex field id for collection elements that are flex fields |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PLAN_CHAR_ACTION_TRIGGER_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, TRIGGER_SEQUENCE
, PLAN_ID
, PLAN_NAME
, VALUES_EXIST_FLAG
, SQL_STRING_FLAG
, DATATYPE
, DECIMAL_PRECISION
, CHAR_ID
, CHAR_NAME
, 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_PLAN_CHAR_ACTION_TRIGGERS_V;
APPS.QA_PLAN_CHAR_ACTION_TRIGGERS_V is not referenced by any database object
|
|
|