[Home] [Help] [Dependency Information]
Object Name: | QA_SPEC_CHARS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QA.QA_SPEC_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) | QA_SPEC_CHARS row identifier | |
SPEC_ID | NUMBER | Yes | Specification 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 | ||
TARGET_VALUE | VARCHAR2 | (150) | Collection element target value as defined in specification | |
UPPER_SPEC_LIMIT | VARCHAR2 | (150) | Upper specification limit | |
LOWER_SPEC_LIMIT | VARCHAR2 | (150) | Lower specification limit | |
UPPER_REASONABLE_LIMIT | VARCHAR2 | (150) | Upper reasonable limit | |
LOWER_REASONABLE_LIMIT | VARCHAR2 | (150) | Lower reasonable limit | |
UPPER_USER_DEFINED_LIMIT | VARCHAR2 | (150) | Upper user defined limit | |
LOWER_USER_DEFINED_LIMIT | VARCHAR2 | (150) | Lower user defined limit | |
SPEC_NAME | VARCHAR2 | (30) | Yes | Specification name |
CHAR_NAME | VARCHAR2 | (30) | Yes | Collection element name |
UOM_CODE | VARCHAR2 | (3) | Unit of measurement code | |
EFFECTIVE_FROM | DATE | Date from which specification is effective | ||
EFFECTIVE_TO | DATE | Date up to which specification is effective | ||
DATATYPE | NUMBER | Yes | Collection element datatype | |
DECIMAL_PRECISION | NUMBER | Collection element decimal precision | ||
SPEC_CHAR_ENABLED | NUMBER | Flag to indicate whether specification limits for a collection element are enabled | ||
SPEC_CHAR_ENABLED_MEANING | VARCHAR2 | (80) | Yes | Meaning of the spec char enabled flag |
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 | |
QSC_UOM_CODE | VARCHAR2 | (3) | UOM at the spec element level | |
SPEC_STATUS | NUMBER | Yes | Spec status used for enabling/disabling the spec during eSignature process. | |
SPEC_STATUS_MEANING | VARCHAR2 | (80) | Spec status used for enabling/disabling the spec during eSignature process. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, SPEC_ID
, CHAR_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, TARGET_VALUE
, UPPER_SPEC_LIMIT
, LOWER_SPEC_LIMIT
, UPPER_REASONABLE_LIMIT
, LOWER_REASONABLE_LIMIT
, UPPER_USER_DEFINED_LIMIT
, LOWER_USER_DEFINED_LIMIT
, SPEC_NAME
, CHAR_NAME
, UOM_CODE
, EFFECTIVE_FROM
, EFFECTIVE_TO
, DATATYPE
, DECIMAL_PRECISION
, SPEC_CHAR_ENABLED
, SPEC_CHAR_ENABLED_MEANING
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, QSC_UOM_CODE
, SPEC_STATUS
, SPEC_STATUS_MEANING
FROM APPS.QA_SPEC_CHARS_V;
APPS.QA_SPEC_CHARS_V is not referenced by any database object
|
|
|