DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.QA_CRITERIA_V

Object Details
Object Name: QA_CRITERIA_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewQA.QA_CRITERIA_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.QA_CRITERIA_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymQA_CHARS
ViewQA_CRITERIA_V1
PL/SQL PackageQA_FLEX_UTIL - show dependent code
SynonymQA_PLAN_CHARS
APPS.QA_CRITERIA_V is referenced by following:

SchemaAPPS
Package BodyQA_QLTRSLTR_XMLP_PKG - show dependent code