[Home] [Help]
[Dependency Information]
| Object Name: | QAFV_COLLECTION_ELEMENTS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | QA.QAFV_COLLECTION_ELEMENTS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
This shows an attribute or parameter that describes an application object. Data values will be collected for this attribute.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| COLLECTION_ELEMENT_ID | NUMBER | Yes | ||
| COLLECTION_ELEMENT_NAME | VARCHAR2 | (30) | Yes | |
| DATA_ENTRY_HINT | VARCHAR2 | (240) | ||
| DATA_TYPE | VARCHAR2 | (80) | Yes | |
| DEFAULT_VALUE | VARCHAR2 | (2000) | ||
| ELEMENT_TYPE | VARCHAR2 | (80) | 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) | ||
| RESULTS_COLUMN_PROMPT | VARCHAR2 | (30) | ||
| ENABLED_FLAG | VARCHAR2 | (80) | Yes | |
| MANDATORY_FLAG | VARCHAR2 | (80) | Yes | |
| UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
| 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 COLLECTION_ELEMENT_ID
, COLLECTION_ELEMENT_NAME
, DATA_ENTRY_HINT
, DATA_TYPE
, DEFAULT_VALUE
, ELEMENT_TYPE
, LOWER_REASONABLE_LIMIT
, LOWER_SPECIFICATION_LIMIT
, LOWER_USER_DEFINED_LIMIT
, UPPER_REASONABLE_LIMIT
, UPPER_SPECIFICATION_LIMIT
, UPPER_USER_DEFINED_LIMIT
, TARGET_VALUE
, RESULTS_COLUMN_PROMPT
, ENABLED_FLAG
, MANDATORY_FLAG
, UNIT_OF_MEASURE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
FROM APPS.QAFV_COLLECTION_ELEMENTS;
APPS
FND_COMMON_LOOKUPS
FND_GLOBAL
- show dependent code
MFG_LOOKUPS
MTL_UNITS_OF_MEASURE
QA_CHARS
APPS.QAFV_COLLECTION_ELEMENTS is not referenced by any database object
|
|
|
|