[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | QA_CHARS |
|---|---|
| Object Type: | TABLE |
| Owner: | QA |
| FND Design Data: |  QA.QA_CHARS
|
| Subobject Name: | |
| Status: | VALID |
QA_CHARS contains information about collection elements also known as Quality Characteristics. Some collection elements are seeded when Oracle Quality is installed, however, you can define new collection elements, which are also stored in this table. Collection elements may be enabled or disabled. You can only use enabled collection elements for the purpose of defining collection plans.
QA_CHARS can store the following types of information: display information, such as prompts and hints, which are shown during results entry; data, such as the datatype and default value of the collection element; validation information such as SQL validation strings; and specifications, such as upper and lower limits. QA_CHARS also stores information about the collection element type and context.
Collection element context is determined by the value of the CHAR_CONTEXT_FLAG, which indicates whether or not a collection element is a standard Quality Characteristic, has any dependency to any other collection element, or is referenced from any other elements in another Oracle Applications table. Depending on the value of CHAR_CONTEXT_FLAG, some other fields in this table may represent unifying context information for the collection element. For example, the collection element in CHAR_ID depends on the collection element represented by DEPENDENT_CHAR_ID. If a collection element is referenced, information from fields such as FK_TABLENAME or PK_ID denote the relationship between QA_CHARS and the foreign table.
QA_CHARS.HARDCODED_COLUMN stores the name of the corresponding column in the QA_RESULTS table in which the values for this collection element are stored. For example, if QA_CHARS.HARDCODED_COLUMN has a value, there will be a corresponding column in the QA_RESULTS table that will store the collection element's result value. If QA_CHARS.HARDCODED_COLUMN has a null value, then one of the generic CHARACTERx columns is used to store the collection element's value.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| QA_CHARS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CHAR_ID
|
| QA_CHARS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
NAME
|
| QA_CHARS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SEQUENCE_NUMBER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| 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 | Collection element name |
| CHAR_TYPE_CODE | VARCHAR2 | (30) | Yes | Collection element type code |
| 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 | |
| PROMPT | VARCHAR2 | (30) | Collection element prompt to be displayed on the results screen | |
| DATA_ENTRY_HINT | VARCHAR2 | (240) | Collection element data entry hint | |
| DATATYPE | NUMBER | Yes | Collection element datatype | |
| DISPLAY_LENGTH | NUMBER | Collection element display length | ||
| DECIMAL_PRECISION | NUMBER | Collection element decimal precision | ||
| DEFAULT_VALUE | VARCHAR2 | (2000) | Default value for the collection element | |
| DEFAULT_VALUE_ID | NUMBER | Default value Identifier | ||
| MANDATORY_FLAG | NUMBER | Yes | Flag to indicate if collection element is mandatory or optional | |
| UOM_CODE | VARCHAR2 | (3) | Collection element unit of measure code | |
| TARGET_VALUE | VARCHAR2 | (150) | Target value for the collection element. This value is defaulted when the collection element is added to a specification | |
| UPPER_SPEC_LIMIT | VARCHAR2 | (150) | Upper specification limit for the collection element. This value is defaulted when the collection element is added to a specification | |
| LOWER_SPEC_LIMIT | VARCHAR2 | (150) | Lower specification limit for the collection element. This value is defaulted when the collection element is added to a specification | |
| UPPER_REASONABLE_LIMIT | VARCHAR2 | (150) | Upper reasonable limit for the collection element. This value is defaulted when the collection element is added to a specification | |
| LOWER_REASONABLE_LIMIT | VARCHAR2 | (150) | Lower reasonable limit for the collection element. This value is defaulted when the collection element is added to a specification | |
| UPPER_USER_DEFINED_LIMIT | VARCHAR2 | (150) | User defined range upper limit for the collection element. This value is defaulted when the collection element is added to a specification | |
| LOWER_USER_DEFINED_LIMIT | VARCHAR2 | (150) | User defined range lower limit for the collection element. This value is defaulted when the collection element is added to a specification | |
| HARDCODED_COLUMN | VARCHAR2 | (30) | Underlying database column name for hardcoded collection element. All hardcoded collection elements have a corresponding static column in QA_RESULTS table. | |
| DEVELOPER_NAME | VARCHAR2 | (30) | Reference name for the collection element. This field is used by developers internally and is applicable only to pre-seeded collection elements. | |
| SQL_VALIDATION_STRING | VARCHAR2 | (1500) | SQL validation string for the collection element. This string is used to validate collection elements during results entry | |
| ENABLED_FLAG | NUMBER | Yes | Flag to enable or disable collection elements | |
| VALUES_EXIST_FLAG | NUMBER | Yes | Flag to indicate if a permissible set of values has been entered for this collection element | |
| DEPENDENT_CHAR_ID | NUMBER | Dependent collection element Identifier on which the current collection element depends | ||
| 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 of the foreign key table | |
| 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 Oracle 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 Identifier | |
| PK_ID3 | VARCHAR2 | (30) | Additional primary key Identifier | |
| FK_ID3 | VARCHAR2 | (30) | Additional foreign key Identifier | |
| 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) | Descriptive 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 number if the datatype is sequence | ||
| SEQUENCE_PREFIX | VARCHAR2 | (10) | Sequence prefix if the datatype is sequence | |
| SEQUENCE_SUFFIX | VARCHAR2 | (10) | Sequence suffix if the datatype is sequence | |
| SEQUENCE_SEPARATOR | VARCHAR2 | (1) | Sequence separator character if datatype is sequence | |
| SEQUENCE_START | NUMBER | Sequence starting number if datatype is sequence | ||
| SEQUENCE_LENGTH | NUMBER | Sequence display length if datatype is sequence | ||
| SEQUENCE_INCREMENT | NUMBER | Sequence incremental value if datatype is sequence | ||
| SEQUENCE_NEXTVAL | NUMBER | Next value if datatype is sequence | ||
| SEQUENCE_ZERO_PAD | NUMBER | Indicates whether the sequence number should be padded with 0 | ||
| DEPENDENT_ELEMENT | VARCHAR2 | (1) | Column to indicate if the collection element is a dependent element |
Cut, paste (and edit) the following text to query this object:
SELECT CHAR_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, NAME
, CHAR_TYPE_CODE
, CHAR_CONTEXT_FLAG
, PROMPT
, DATA_ENTRY_HINT
, DATATYPE
, DISPLAY_LENGTH
, DECIMAL_PRECISION
, DEFAULT_VALUE
, DEFAULT_VALUE_ID
, MANDATORY_FLAG
, UOM_CODE
, TARGET_VALUE
, UPPER_SPEC_LIMIT
, LOWER_SPEC_LIMIT
, UPPER_REASONABLE_LIMIT
, LOWER_REASONABLE_LIMIT
, UPPER_USER_DEFINED_LIMIT
, LOWER_USER_DEFINED_LIMIT
, HARDCODED_COLUMN
, DEVELOPER_NAME
, SQL_VALIDATION_STRING
, ENABLED_FLAG
, VALUES_EXIST_FLAG
, 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
, DEPENDENT_ELEMENT
FROM QA.QA_CHARS;
QA.QA_CHARS does not reference any database object
QA.QA_CHARS is referenced by following:
APPS
QA_CHARS
|
|
|
|