[Home] [Help] [Dependency Information]
Object Name: | QA_CRITERIA_V1 |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QA.QA_CRITERIA_V1 |
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) | Row identifier | |
CRITERIA_SEQUENCE | NUMBER | Yes | Criteria 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 | ||
CRITERIA_ID | NUMBER | Yes | Criteria header identifier | |
PLAN_ID | NUMBER | Collection plan identifier | ||
ORDER_SEQUENCE | NUMBER | Collection element order in criteria definition | ||
SQL_TYPE | NUMBER | Yes | Indicates if collection element will appear in report body or it will be used as selection criteria for the report | |
CHAR_ID | NUMBER | Yes | Collection element identifier | |
OPERATOR | NUMBER | Operator used in defining the condition | ||
LOW_VALUE | VARCHAR2 | (150) | Lower limit to the collection element value range used in defining criteria | |
LOW_VALUE_ID | NUMBER | Identifies flex field id for collection elements that are flex fields | ||
HIGH_VALUE | VARCHAR2 | (150) | Upper limit to the collection element value range used in defining criteria | |
HIGH_VALUE_ID | NUMBER | Identifies flex field id for collection elements that are flex fields | ||
FXN | NUMBER | Function applied to collection element | ||
TOTAL | NUMBER | Indicates if collection element total is to be printed | ||
SORT_BY | NUMBER | This column has been obsoleted |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CRITERIA_SEQUENCE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CRITERIA_ID
, PLAN_ID
, ORDER_SEQUENCE
, SQL_TYPE
, CHAR_ID
, OPERATOR
, LOW_VALUE
, LOW_VALUE_ID
, HIGH_VALUE
, HIGH_VALUE_ID
, FXN
, TOTAL
, SORT_BY
FROM APPS.QA_CRITERIA_V1;
|
|
|