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

VIEW: APPS.QA_CRITERIA_HEADERS_V

Object Details
Object Name: QA_CRITERIA_HEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewQA.QA_CRITERIA_HEADERS_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)
QA_CRITERIA_HEADERS row identifier
CRITERIA_ID 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
ORGANIZATION_ID NUMBER

Inventory Organization identifier
NAME VARCHAR2 (30) Yes Criteria name
PLAN_ID NUMBER

Collection plan identifier
PLAN_NAME VARCHAR2 (30) Yes Collection plan name
OUTPUT_TYPE NUMBER
Yes Indicates the type of the chart or report to which criteria is defined
TITLE VARCHAR2 (50)
Chart or report type
DESCRIPTION VARCHAR2 (225)
Chart or report description
CHART_TYPE NUMBER

Chart type
NUM_BARS NUMBER

Number of bars in histogram
NUM_POINTS NUMBER

Number of points in histogram
X_AXIS_CHAR_ID NUMBER

X-Axis collection element identifier
X_AXIS_CHAR_NAME VARCHAR2 (30)
X-Axis collection element name
X_AXIS_HARDCODED_COLUMN VARCHAR2 (30)
Hardcoded underlying database column for X-Axis collection element
X_AXIS_RESULT_COLUMN_NAME VARCHAR2 (30)
Corresponding results column name for x-axis hardcoded collection element
X_AXIS_DATATYPE NUMBER

Datatype of the x-axis collection element
X_AXIS_DISPLAY_LENGTH NUMBER

Display length of the x-axis collection element
X_AXIS_PROMPT VARCHAR2 (30)
Prompt of the x-axis collection element
X_AXIS_DECIMAL_PRECISION NUMBER

Decimal precision of x-axis collection element
X_AXIS_FK_LOOKUP_TYPE NUMBER

Foreign key lookup type code for x-axis collection element
X_AXIS_FK_TABLE_NAME VARCHAR2 (30)
Foreign key table name for x-axis collection element
X_AXIS_FK_TABLE_SHORT_NAME VARCHAR2 (5)
Short name for foreign key table for x-axis collection element
X_AXIS_FK_ID VARCHAR2 (30)
Foreign key identifier for x-axis collection element
X_AXIS_FK_ID2 VARCHAR2 (30)
Additional foreign key identifier for x-axis collection element
X_AXIS_FK_ID3 VARCHAR2 (30)
Additional foreign key identifier for x-axis collection element
X_AXIS_PK_ID VARCHAR2 (30)
Primary key identifier for X-Axis collection element
X_AXIS_PK_ID2 VARCHAR2 (30)
Additional primary key columns identifier for x-axis collection element
X_AXIS_PK_ID3 VARCHAR2 (30)
Additional primary key identifier for x-axis collection element
X_AXIS_FK_MEANING VARCHAR2 (30)
Meaning of the foreign key column for x-axis collection element
X_AXIS_FK_DESCRIPTION VARCHAR2 (30)
Description of foreign key column for X-Axis collection element
X_AXIS_FK_ADD_WHERE VARCHAR2 (255)
Where clause that needs to be added to Quality's dynamic view creation logic for x-axis collection element
X_AXIS_UOM_CODE VARCHAR2 (3)
Unit of measurement code for X-AXIS collection element
X_AXIS_UNIT_OF_MEASURE VARCHAR2 (25)
Unit of measurement for x-axis collection element
Y_AXIS_CHAR_ID NUMBER

Identifier for Y-AXIS collection element
Y_AXIS_CHAR_NAME VARCHAR2 (30)
Name for Y-Axis collection element
Y_AXIS_HARDCODED_COLUMN VARCHAR2 (30)
Hardcoded underlying database column for Y-Axis collection element
Y_AXIS_RESULT_COLUMN_NAME VARCHAR2 (30)
Corresponding results column name for y-axis hardcoded collection element
Y_AXIS_DATATYPE NUMBER

Datatype of the x-axis collection element
Y_AXIS_DISPLAY_LENGTH NUMBER

Display length of the y-axis collection element
Y_AXIS_PROMPT VARCHAR2 (30)
Prompt of the y-axis collection element
Y_AXIS_DECIMAL_PRECISION NUMBER

Decimal precision of y-axis collection element
Y_AXIS_FK_LOOKUP_TYPE NUMBER

Foreign key lookup type code for x-axis collection element
Y_AXIS_FK_TABLE_NAME VARCHAR2 (30)
Foreign key table name for x-axis collection element
Y_AXIS_FK_TABLE_SHORT_NAME VARCHAR2 (5)
Short name for foreign key table for x-axis collection element
Y_AXIS_FK_ID VARCHAR2 (30)
Foreign key identifier for y-axis collection element
Y_AXIS_FK_ID2 VARCHAR2 (30)
Additional foreign key identifier for y-axis collection element
Y_AXIS_FK_ID3 VARCHAR2 (30)
Additional foreign key identifier for y-axis collection element
Y_AXIS_PK_ID VARCHAR2 (30)
Primary key identifier for y-axis collection element
Y_AXIS_PK_ID2 VARCHAR2 (30)
Additional primary key columns identifier for y-axis collection element
Y_AXIS_PK_ID3 VARCHAR2 (30)
Additional primary key columns identifier for y-axis collection element
Y_AXIS_FK_MEANING VARCHAR2 (30)
Meaning fo the foreign key column for y-axis collection element
Y_AXIS_FK_DESCRIPTION VARCHAR2 (30)
Description of foreign key column for y-axis collection element
Y_AXIS_FK_ADD_WHERE VARCHAR2 (255)
Where clause that needs to be added to quality dynamic view creation logic for y-axiscollection element
Y_AXIS_FXN NUMBER

Function which is applied to calculate Y_AXIS values
TOP_N_GROUPS NUMBER

Number of groups user want to display in pareto chart
X_AXIS_GROUP_BY_ID NUMBER

Grouping element of X-AXIS. This information is used only for trend chart
X_AXIS_GROUP_BY_NAME VARCHAR2 (80)
Name of the grouping element of x-axis
SPEC_ID NUMBER

Specification identifier
SPEC_NAME VARCHAR2 (30)
Specification name
TARGET_VALUE VARCHAR2 (150)
Target value of the collection element as defined in specification
LOWER_SPEC_LIMIT VARCHAR2 (150)
Lower specification limit for the collection element
UPPER_SPEC_LIMIT VARCHAR2 (150)
Upper specification limit for the collection element
LOWER_USER_DEFINED_LIMIT VARCHAR2 (150)
Lower limit of the user defined range as defined in the specification for collection element
UPPER_USER_DEFINED_LIMIT VARCHAR2 (150)
Upper limit fo the user defined range as defined in the specification for the collection element
TARGET_VALUE_FLAG NUMBER

Flag to indicate if specification target value should be used in histogram
SPEC_LIMIT_FLAG NUMBER

Flag to indicate if specification limit should be used in histogram
USER_DEFINED_LIMIT_FLAG NUMBER

Flag to indicate if user defined limit should be used in histogram
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      CRITERIA_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_ID
,      NAME
,      PLAN_ID
,      PLAN_NAME
,      OUTPUT_TYPE
,      TITLE
,      DESCRIPTION
,      CHART_TYPE
,      NUM_BARS
,      NUM_POINTS
,      X_AXIS_CHAR_ID
,      X_AXIS_CHAR_NAME
,      X_AXIS_HARDCODED_COLUMN
,      X_AXIS_RESULT_COLUMN_NAME
,      X_AXIS_DATATYPE
,      X_AXIS_DISPLAY_LENGTH
,      X_AXIS_PROMPT
,      X_AXIS_DECIMAL_PRECISION
,      X_AXIS_FK_LOOKUP_TYPE
,      X_AXIS_FK_TABLE_NAME
,      X_AXIS_FK_TABLE_SHORT_NAME
,      X_AXIS_FK_ID
,      X_AXIS_FK_ID2
,      X_AXIS_FK_ID3
,      X_AXIS_PK_ID
,      X_AXIS_PK_ID2
,      X_AXIS_PK_ID3
,      X_AXIS_FK_MEANING
,      X_AXIS_FK_DESCRIPTION
,      X_AXIS_FK_ADD_WHERE
,      X_AXIS_UOM_CODE
,      X_AXIS_UNIT_OF_MEASURE
,      Y_AXIS_CHAR_ID
,      Y_AXIS_CHAR_NAME
,      Y_AXIS_HARDCODED_COLUMN
,      Y_AXIS_RESULT_COLUMN_NAME
,      Y_AXIS_DATATYPE
,      Y_AXIS_DISPLAY_LENGTH
,      Y_AXIS_PROMPT
,      Y_AXIS_DECIMAL_PRECISION
,      Y_AXIS_FK_LOOKUP_TYPE
,      Y_AXIS_FK_TABLE_NAME
,      Y_AXIS_FK_TABLE_SHORT_NAME
,      Y_AXIS_FK_ID
,      Y_AXIS_FK_ID2
,      Y_AXIS_FK_ID3
,      Y_AXIS_PK_ID
,      Y_AXIS_PK_ID2
,      Y_AXIS_PK_ID3
,      Y_AXIS_FK_MEANING
,      Y_AXIS_FK_DESCRIPTION
,      Y_AXIS_FK_ADD_WHERE
,      Y_AXIS_FXN
,      TOP_N_GROUPS
,      X_AXIS_GROUP_BY_ID
,      X_AXIS_GROUP_BY_NAME
,      SPEC_ID
,      SPEC_NAME
,      TARGET_VALUE
,      LOWER_SPEC_LIMIT
,      UPPER_SPEC_LIMIT
,      LOWER_USER_DEFINED_LIMIT
,      UPPER_USER_DEFINED_LIMIT
,      TARGET_VALUE_FLAG
,      SPEC_LIMIT_FLAG
,      USER_DEFINED_LIMIT_FLAG
FROM APPS.QA_CRITERIA_HEADERS_V;

Dependencies

[top of page]

APPS.QA_CRITERIA_HEADERS_V references the following:

SchemaAPPS
SynonymFND_LOOKUP_VALUES
SynonymMTL_UNITS_OF_MEASURE_TL
SynonymQA_CHARS
SynonymQA_CRITERIA_HEADERS
SynonymQA_PLANS
SynonymQA_PLAN_CHARS
SynonymQA_SPECS
SynonymQA_SPEC_CHARS

APPS.QA_CRITERIA_HEADERS_V is not referenced by any database object