[Home] [Help]
[Dependency Information]
| Object Name: | QAFV_QUALSPCELM |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | QA.QAFV_QUALSPCELM
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
This shows a collection element that has been copied or assigned to a specification. A specification is a predefined limit into which you want a parameter to fall.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| SPECIFICATION_ID | NUMBER | Yes | ||
| SPECIFICATION_NAME | VARCHAR2 | (30) | Yes | |
| COLLECTION_ELEMENT_ID | NUMBER | Yes | ||
| COLLECTION_ELEMENT_NAME | VARCHAR2 | (30) | Yes | |
| LOWER_REASONABLE_LIMIT | VARCHAR2 | (150) | ||
| LOWER_SPECIFICATION_LIMIT | VARCHAR2 | (150) | ||
| LOWER_USER_DEFINED_LIMIT | VARCHAR2 | (150) | ||
| UPPER_REASONABLE_LIMIT | VARCHAR2 | (150) | ||
| UPPER_SPECIFICATION_LIMIT | VARCHAR2 | (150) | ||
| UPPER_USER_DEFINED_LIMIT | VARCHAR2 | (150) | ||
| TARGET_VALUE | VARCHAR2 | (150) | ||
| ENABLED_FLAG | VARCHAR2 | (80) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT SPECIFICATION_ID
, SPECIFICATION_NAME
, COLLECTION_ELEMENT_ID
, COLLECTION_ELEMENT_NAME
, LOWER_REASONABLE_LIMIT
, LOWER_SPECIFICATION_LIMIT
, LOWER_USER_DEFINED_LIMIT
, UPPER_REASONABLE_LIMIT
, UPPER_SPECIFICATION_LIMIT
, UPPER_USER_DEFINED_LIMIT
, TARGET_VALUE
, ENABLED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
FROM APPS.QAFV_QUALSPCELM;
APPS
MFG_LOOKUPS
QA_CHARS
QA_SPECS
QA_SPEC_CHARS
APPS.QAFV_QUALSPCELM is not referenced by any database object
|
|
|
|