DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.QAFV_COLLECTION_ELEMENTS

Object Details
Object Name: QAFV_COLLECTION_ELEMENTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewQA.QAFV_COLLECTION_ELEMENTS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows an attribute or parameter that describes an application object. Data values will be collected for this attribute.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.QAFV_COLLECTION_ELEMENTS references the following:

SchemaAPPS
ViewFND_COMMON_LOOKUPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewMFG_LOOKUPS
SynonymMTL_UNITS_OF_MEASURE
SynonymQA_CHARS

APPS.QAFV_COLLECTION_ELEMENTS is not referenced by any database object