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_ITMINST_OLTP_V

Object Details

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

This view contains information about items installed at a site in the Install base. Basicall a view to store information about products at customer site

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INSTANCE_ID	NUMBER		Yes
REFERENCE_NUMBER	VARCHAR2	(30)	Yes	Instance Number for Covered Product
SERIAL_NUMBER	VARCHAR2	(30)		Instance Serial Number for Covered Product
INSTALL_DATE	DATE			Instance Installation Date
ORDER_LINE_ID	NUMBER

Query Text

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


SELECT INSTANCE_ID
,      REFERENCE_NUMBER
,      SERIAL_NUMBER
,      INSTALL_DATE
,      ORDER_LINE_ID
FROM APPS.OKI_ITMINST_OLTP_V;

Dependencies

[top of page]

APPS.OKI_ITMINST_OLTP_V references the following:

APPS: CSI_ITEM_INSTANCES

APPS.OKI_ITMINST_OLTP_V is not referenced by any database object