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


VIEW: APPS.QABV_QUALITY_SPECIFICATIONS

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

View Type

A Business Intelligence System view


This shows a predefined limit into which you want a parameter to fall. A specification can be specific to a customer or supplier.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SPECIFICATION_ID NUMBER
Yes
SPECIFICATION_NAME VARCHAR2 (30) Yes
START_EFFECTIVE_DATE DATE


END_EFFECTIVE_DATE DATE


SUBTYPE_ELEMENT_VALUE VARCHAR2 (150)

ASSIGNMENT_TYPE VARCHAR2 (80) Yes
ORGANIZATION_ID NUMBER


CATEGORY_ID NUMBER
Yes
CATEGORY_SET_ID NUMBER
Yes
ITEM_ID NUMBER
Yes
ITEM_REVISION VARCHAR2 (4) Yes
VENDOR_ID NUMBER
Yes
CUSTOMER_ID NUMBER
Yes
SUBTYPE_ELEMENT_ID NUMBER


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
,      START_EFFECTIVE_DATE
,      END_EFFECTIVE_DATE
,      SUBTYPE_ELEMENT_VALUE
,      ASSIGNMENT_TYPE
,      ORGANIZATION_ID
,      CATEGORY_ID
,      CATEGORY_SET_ID
,      ITEM_ID
,      ITEM_REVISION
,      VENDOR_ID
,      CUSTOMER_ID
,      SUBTYPE_ELEMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.QABV_QUALITY_SPECIFICATIONS;

Dependencies

[top of page]

APPS.QABV_QUALITY_SPECIFICATIONS references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymQA_SPECS

APPS.QABV_QUALITY_SPECIFICATIONS is not referenced by any database object