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.OKS_USAGE_ITEM_V

Object Details

Object Name:	OKS_USAGE_ITEM_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKS.OKS_USAGE_ITEM_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
NAME	VARCHAR2	(40)	Name
SOURCE_DETAILS	VARCHAR2	(693)	Source Details
DESCRIPTION	VARCHAR2	(240)	Description
UOM_CODE	VARCHAR2	(3)	Uom Code
ID1	NUMBER		Id1
ID2	CHAR	(1)
OBJECT_CODE	CHAR	(11)	Object Code
SOURCE_ID	NUMBER		Source Id
COUNTER_GROUP_ID	NUMBER		Counter Group Id
TEMPLATE_COUNTER_GROUP_ID	NUMBER		Template Counter Group Id
COUNTER	VARCHAR2	(80)	Counter
USAGE_ITEM_ID	NUMBER		Usage Item Id
PARTY_ID	NUMBER		Party Id
REC_TYPE	VARCHAR2	(5)	Rec Type
START_DATE_ACTIVE	DATE		Start Date Active
END_DATE_ACTIVE	DATE		End Date Active
SOURCE_OBJECT_CODE	VARCHAR2	(30)	Source Object Code
INSTANCE_NUMBER	VARCHAR2	(30)	Instance Number
SERIAL_NUMBER	VARCHAR2	(30)	Serial Number
EXTERNAL_REFERENCE	VARCHAR2	(30)	External Reference

Query Text

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


SELECT NAME
,      SOURCE_DETAILS
,      DESCRIPTION
,      UOM_CODE
,      ID1
,      ID2
,      OBJECT_CODE
,      SOURCE_ID
,      COUNTER_GROUP_ID
,      TEMPLATE_COUNTER_GROUP_ID
,      COUNTER
,      USAGE_ITEM_ID
,      PARTY_ID
,      REC_TYPE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SOURCE_OBJECT_CODE
,      INSTANCE_NUMBER
,      SERIAL_NUMBER
,      EXTERNAL_REFERENCE
FROM APPS.OKS_USAGE_ITEM_V;

Dependencies

[top of page]

APPS.OKS_USAGE_ITEM_V references the following:

APPS: CSI_COUNTERS_B; CSI_COUNTERS_TL; CSI_COUNTER_ASSOCIATIONS; CSI_ITEM_INSTANCES; CS_CSI_COUNTER_GROUPS; MTL_SYSTEM_ITEMS_KFV; OKC_K_HEADERS_B; OKC_K_ITEMS; OKC_K_LINES_V

APPS.OKS_USAGE_ITEM_V is not referenced by any database object