[Home] [Help] [Dependency Information]
Object Name: | QA_CRITERIA_HEADERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QA.QA_CRITERIA_HEADERS_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) | 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 |
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;
APPS.QA_CRITERIA_HEADERS_V is not referenced by any database object
|
|
|