[Home] [Help] [Dependency Information]
Object Name: | QA_CRITERIA_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QA.QA_CRITERIA_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) | 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 | |
ORDER_SEQUENCE | NUMBER | Collection element order sequence in criteria | ||
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 | |
CHAR_NAME | VARCHAR2 | (30) | Yes | Collection element name |
HARDCODED_COLUMN | VARCHAR2 | (30) | Underlying database column name for the collection element | |
RESULT_COLUMN_NAME | VARCHAR2 | (30) | Column name in QA_RESULTS to which this collection element is mapped | |
DATATYPE | NUMBER | Yes | Collection element datattype | |
DISPLAY_LENGTH | NUMBER | Collection element display length | ||
PROMPT | VARCHAR2 | (30) | Collection element prompt | |
DECIMAL_PRECISION | NUMBER | Collection element decimal precision | ||
VALUES_EXIST_FLAG | NUMBER | Flag to indicate if values has been enteredfor collection element | ||
SQL_STRING_FLAG | VARCHAR2 | (1) | Flag to indicate if SQL validation string has been entered for collection element | |
FK_LOOKUP_TYPE | NUMBER | Foreign key lookup type | ||
FK_TABLE_NAME | VARCHAR2 | (30) | Name of the table to which collection element is a foreign key | |
FK_TABLE_SHORT_NAME | VARCHAR2 | (5) | Short name to the foreign key table | |
FK_ID | VARCHAR2 | (30) | Foreign key column identifier in Quality | |
FK_ID2 | VARCHAR2 | (30) | Additional foreign key identifier column | |
FK_ID3 | VARCHAR2 | (30) | Additional foreign key identifier column | |
PK_ID | VARCHAR2 | (30) | Primary key column identifier | |
PK_ID2 | VARCHAR2 | (30) | Additional primary key identifier columns | |
PK_ID3 | VARCHAR2 | (30) | Additional primary key identifier columns | |
FK_MEANING | VARCHAR2 | (30) | foreign key column meaning | |
FK_DESCRIPTION | VARCHAR2 | (30) | Foreign key description | |
FK_ADD_WHERE | VARCHAR2 | (255) | Where clause used for view creation logic | |
OPERATOR | NUMBER | Operator used in defining criteria | ||
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) | Higher 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 | ||
FXN_MEANING | VARCHAR2 | (80) | Meaning of the function | |
TOTAL | NUMBER | Flag to indicate if total of the collection element 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
, ORDER_SEQUENCE
, SQL_TYPE
, CHAR_ID
, CHAR_NAME
, HARDCODED_COLUMN
, RESULT_COLUMN_NAME
, DATATYPE
, DISPLAY_LENGTH
, PROMPT
, DECIMAL_PRECISION
, VALUES_EXIST_FLAG
, SQL_STRING_FLAG
, FK_LOOKUP_TYPE
, FK_TABLE_NAME
, FK_TABLE_SHORT_NAME
, FK_ID
, FK_ID2
, FK_ID3
, PK_ID
, PK_ID2
, PK_ID3
, FK_MEANING
, FK_DESCRIPTION
, FK_ADD_WHERE
, OPERATOR
, LOW_VALUE
, LOW_VALUE_ID
, HIGH_VALUE
, HIGH_VALUE_ID
, FXN
, FXN_MEANING
, TOTAL
, SORT_BY
FROM APPS.QA_CRITERIA_V;
|
|
|