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

VIEW: APPS.OKX_SPECS_V

Object Details
Object Name: OKX_SPECS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_SPECS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Displays information about specifications and standards.
A specification could be associated with an item, item-supplier, or item-customer.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ID1 NUMBER
Yes Specification identifier
ID2 CHAR (1)
(Multi-part) Primary Key
ORGANIZATION_ID NUMBER

Inventory organization Identifier
NAME VARCHAR2 (30) Yes Specification name
START_DATE_ACTIVE DATE

Date specification is effective from
END_DATE_ACTIVE DATE

Date up to which specification is effective
STATUS VARCHAR2 (1)
Status
DESCRIPTION VARCHAR2 (150)
Specification element value
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID1
,      ID2
,      ORGANIZATION_ID
,      NAME
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      DESCRIPTION
FROM APPS.OKX_SPECS_V;

Dependencies

[top of page]

APPS.OKX_SPECS_V references the following:

SchemaAPPS
SynonymQA_SPECS

APPS.OKX_SPECS_V is not referenced by any database object