[Home] [Help] [Dependency Information]
Object Name: | QA_CHARS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QA.QA_CHARS_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 | |
CHAR_ID | NUMBER | Yes | Collection element 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 | ||
NAME | VARCHAR2 | (30) | Yes | Collectione element name |
CHAR_TYPE_CODE | VARCHAR2 | (30) | Yes | Collection element type code |
CHAR_TYPE_MEANING | VARCHAR2 | (80) | Yes | Collection element type meaning |
CHAR_TYPE_DESCRIPTION | VARCHAR2 | (240) | Collection element type description | |
CHAR_CONTEXT_FLAG | NUMBER | Yes | Collection element context indicating whether the collection element is a standard Quality characteristic or it is a referenced collection element. This flag also indicates if the collection element is a dependent collection element | |
CHAR_CONTEXT_MEANING | VARCHAR2 | (80) | Yes | Context flag meaning |
CHAR_CONTEXT_CHECKBOX | NUMBER | Indicates if the collection element is quality characteristics or not | ||
PROMPT | VARCHAR2 | (30) | Collection element prompt to be displayed on results screen | |
DATA_ENTRY_HINT | VARCHAR2 | (240) | Data entry help text | |
DATATYPE | NUMBER | Yes | Collection element datatype | |
DATATYPE_MEANING | VARCHAR2 | (80) | Yes | Datatype meaning |
DISPLAY_LENGTH | NUMBER | Collection element display length | ||
DECIMAL_PRECISION | NUMBER | Collection element decimal precision | ||
DEFAULT_VALUE | VARCHAR2 | (2000) | Collection element default value | |
DEFAULT_VALUE_ID | NUMBER | Default value identifier | ||
MANDATORY_FLAG | NUMBER | Yes | Flag to Indicate if collection element is mandatory or optional | |
MANDATORY_MEANING | VARCHAR2 | (80) | Yes | Mandatory flag meaning |
UOM_CODE | VARCHAR2 | (3) | Unit of measure code | |
UNIT_OF_MEASURE | VARCHAR2 | (25) | Unit of measurement | |
TARGET_VALUE | VARCHAR2 | (150) | Target value | |
UPPER_SPEC_LIMIT | VARCHAR2 | (150) | Upper specification limit for the collection limit | |
LOWER_SPEC_LIMIT | VARCHAR2 | (150) | Lower specification limit | |
UPPER_REASONABLE_LIMIT | VARCHAR2 | (150) | Upper reasonable limit for the collection element value | |
LOWER_REASONABLE_LIMIT | VARCHAR2 | (150) | Lower reasonable limit for collectionelement value | |
UPPER_USER_DEFINED_LIMIT | VARCHAR2 | (150) | Upper user defined limit for the collection element value | |
LOWER_USER_DEFINED_LIMIT | VARCHAR2 | (150) | Lower user defined limit for collection element value | |
HARDCODED_COLUMN | VARCHAR2 | (30) | Underlying database column for hardcoded collection element | |
ENABLED_FLAG | NUMBER | Yes | Flag to indicate if collection element is enabled or not | |
DEVELOPER_NAME | VARCHAR2 | (30) | Reference column for collection element name. This column is used internally by developers. | |
SQL_VALIDATION_STRING | VARCHAR2 | (1500) | SQL statement used for collection element validation | |
SQL_STRING_FLAG | VARCHAR2 | (1) | Indicates if SQL validation string exists or not | |
ENABLED_MEANING | VARCHAR2 | (80) | Yes | Enabled flag meaning |
VALUES_EXIST_FLAG | NUMBER | Yes | Flag to indicate if permissible set of values exist for collection element | |
VALUES_EXIST_MEANING | VARCHAR2 | (80) | Yes | Valuer exist flag meaning |
DEPENDENT_CHAR_ID | NUMBER | Dependent collection element identifer | ||
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) | Foreign ley table short name | |
PK_ID | VARCHAR2 | (30) | Primary key column identifier for the foreign key. Oracle quality uses this information for dynamic view creation and validation purposes | |
FK_ID | VARCHAR2 | (30) | Foreign key column identifier in Quality. This information is used for dynamic view creation and validation purposes | |
PK_ID2 | VARCHAR2 | (30) | Additional primary key identifier | |
FK_ID2 | VARCHAR2 | (30) | Additional foreign key column | |
PK_ID3 | VARCHAR2 | (30) | Additional primary key identifier | |
FK_ID3 | VARCHAR2 | (30) | Additional foreign key column | |
FK_MEANING | VARCHAR2 | (30) | Foreign key meaning | |
FK_DESCRIPTION | VARCHAR2 | (30) | Foreign key description | |
FK_ADD_WHERE | VARCHAR2 | (255) | Where clause that needs to be added to quality dynamic view creation logic | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descripive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
SEQUENCE_NUMBER | NUMBER | |||
SEQUENCE_PREFIX | VARCHAR2 | (10) | ||
SEQUENCE_SUFFIX | VARCHAR2 | (10) | ||
SEQUENCE_SEPARATOR | VARCHAR2 | (1) | ||
SEQUENCE_START | NUMBER | |||
SEQUENCE_LENGTH | NUMBER | |||
SEQUENCE_INCREMENT | NUMBER | |||
SEQUENCE_NEXTVAL | NUMBER | |||
SEQUENCE_ZERO_PAD | NUMBER | |||
SEQUENCE_NAME | VARCHAR2 | (80) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CHAR_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, NAME
, CHAR_TYPE_CODE
, CHAR_TYPE_MEANING
, CHAR_TYPE_DESCRIPTION
, CHAR_CONTEXT_FLAG
, CHAR_CONTEXT_MEANING
, CHAR_CONTEXT_CHECKBOX
, PROMPT
, DATA_ENTRY_HINT
, DATATYPE
, DATATYPE_MEANING
, DISPLAY_LENGTH
, DECIMAL_PRECISION
, DEFAULT_VALUE
, DEFAULT_VALUE_ID
, MANDATORY_FLAG
, MANDATORY_MEANING
, UOM_CODE
, UNIT_OF_MEASURE
, TARGET_VALUE
, UPPER_SPEC_LIMIT
, LOWER_SPEC_LIMIT
, UPPER_REASONABLE_LIMIT
, LOWER_REASONABLE_LIMIT
, UPPER_USER_DEFINED_LIMIT
, LOWER_USER_DEFINED_LIMIT
, HARDCODED_COLUMN
, ENABLED_FLAG
, DEVELOPER_NAME
, SQL_VALIDATION_STRING
, SQL_STRING_FLAG
, ENABLED_MEANING
, VALUES_EXIST_FLAG
, VALUES_EXIST_MEANING
, DEPENDENT_CHAR_ID
, FK_LOOKUP_TYPE
, FK_TABLE_NAME
, FK_TABLE_SHORT_NAME
, PK_ID
, FK_ID
, PK_ID2
, FK_ID2
, PK_ID3
, FK_ID3
, FK_MEANING
, FK_DESCRIPTION
, FK_ADD_WHERE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SEQUENCE_NUMBER
, SEQUENCE_PREFIX
, SEQUENCE_SUFFIX
, SEQUENCE_SEPARATOR
, SEQUENCE_START
, SEQUENCE_LENGTH
, SEQUENCE_INCREMENT
, SEQUENCE_NEXTVAL
, SEQUENCE_ZERO_PAD
, SEQUENCE_NAME
FROM APPS.QA_CHARS_V;
APPS.QA_CHARS_V is not referenced by any database object
|
|
|