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_HCUSTCLASS_DTL_V

Object Details

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

This view stores detail information on customer classification/categories

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_ID	NUMBER	(15)		Party unique identification number
CLASS_CATEGORY	VARCHAR2	(30)	Yes	Party classification category
CLASS_CATEGORY_MEANING	VARCHAR2	(80)	Yes	Descriptive meaning of party classification category
CLASS_CODE	VARCHAR2	(30)	Yes	Party classfication code
CLASS_CODE_MEANING	VARCHAR2	(80)	Yes	Descriptive meaning of Classfication code
DESCRIPTION	VARCHAR2	(240)		QuickCode description , pulled from AR_LOOKUPS
PRIMARY_FLAG	VARCHAR2	(1)	Yes	Indicates if this is the primary class code of a class category for the organization. Y for the primary class code, N for all others

Query Text

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


SELECT PARTY_ID
,      CLASS_CATEGORY
,      CLASS_CATEGORY_MEANING
,      CLASS_CODE
,      CLASS_CODE_MEANING
,      DESCRIPTION
,      PRIMARY_FLAG
FROM APPS.OKI_HCUSTCLASS_DTL_V;

Dependencies

[top of page]

APPS.OKI_HCUSTCLASS_DTL_V references the following:

APPS: AR_LOOKUPS; FND_LOOKUP_TYPES_TL; HZ_CODE_ASSIGNMENTS

APPS.OKI_HCUSTCLASS_DTL_V is not referenced by any database object