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


VIEW: APPS.QABV_QUALSPCELM

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

View Type

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.


[View Source]

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

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.QABV_QUALSPCELM;

Dependencies

[top of page]

APPS.QABV_QUALSPCELM references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymQA_CHARS
SynonymQA_SPECS
SynonymQA_SPEC_CHARS

APPS.QABV_QUALSPCELM is not referenced by any database object