eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OKI_CCLASS_OLTP_V

Object Details

Object Name:	OKI_CCLASS_OLTP_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

This view gives Customer Classification information

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CLASS_CATEGORY	VARCHAR2	(30)	Yes	Classification Category
CLASS_CODE	VARCHAR2	(30)	Yes	Classification Code
CLASS_CODE_MEANING	VARCHAR2	(80)	Yes	Descriptive meaning for Classification Code
CLASS_CODE_DESCRIPTION	VARCHAR2	(240)		Description for Classification Code
CATEGORY_MEANING	VARCHAR2	(80)	Yes	Descriptive meaning for Classification Category

Query Text

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


SELECT CLASS_CATEGORY
,      CLASS_CODE
,      CLASS_CODE_MEANING
,      CLASS_CODE_DESCRIPTION
,      CATEGORY_MEANING
FROM APPS.OKI_CCLASS_OLTP_V;

Dependencies

[top of page]

APPS.OKI_CCLASS_OLTP_V references the following:

APPS: AR_LOOKUPS; FND_LOOKUP_TYPES_TL; HZ_CLASS_CATEGORY_USES

APPS.OKI_CCLASS_OLTP_V is not referenced by any database object