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

Object Details

Object Name:	OKX_COVERED_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKX.OKX_COVERED_LINES_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	Mandatory	Comments
ID1	NUMBER		Yes
ID2	CHAR	(1)
NAME	VARCHAR2	(240)
DESCRIPTION	VARCHAR2	(150)	Yes
ITEM_DESCRIPTION	VARCHAR2	(1995)		Item description.
COMMENTS	VARCHAR2	(1995)		User entered comment.
CHR_ID	NUMBER			Contract ID. Denormalized for performance.
DNZ_CHR_ID	NUMBER		Yes	Contract ID. Denormalized for performance.
LINE_NUMBER	VARCHAR2	(150)	Yes	Sequencial line number.
DATE_TERMINATED	DATE			Date contract was terminated.
START_DATE_ACTIVE	DATE			The beginning of the active period, one second after midnight on the date indicated.
END_DATE_ACTIVE	DATE			The end of the active period, one second before midnight on the date indicated.
STATUS	VARCHAR2	(1)
INVENTORY_ITEM_ID	VARCHAR2	(40)		Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view.
ORGANIZATION_ID	NUMBER
QUANTITY	NUMBER			Number of items.
UNIT_OF_MEASURE_CODE	VARCHAR2	(3)		Unit of Measure code.
ITEM_NAME	VARCHAR2	(240)		Item name.
SERVICEABLE_PRODUCT_FLAG	VARCHAR2	(1)	Yes	Indicates whether the item is serviceable by other service-type items and can have service requests reported against it
PRIMARY_UOM_CODE	VARCHAR2	(0)
UNIT_OF_MEASURE	VARCHAR2	(25)

Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      ITEM_DESCRIPTION
,      COMMENTS
,      CHR_ID
,      DNZ_CHR_ID
,      LINE_NUMBER
,      DATE_TERMINATED
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      QUANTITY
,      UNIT_OF_MEASURE_CODE
,      ITEM_NAME
,      SERVICEABLE_PRODUCT_FLAG
,      PRIMARY_UOM_CODE
,      UNIT_OF_MEASURE
FROM APPS.OKX_COVERED_LINES_V;

Dependencies

[top of page]

APPS.OKX_COVERED_LINES_V references the following:

APPS: JTF_OBJECTS_B; MTL_UNITS_OF_MEASURE_TL; OKC_K_ITEMS; OKC_K_LINES_B; OKC_K_LINES_TL; OKX_SYSTEM_ITEMS_V

APPS.OKX_COVERED_LINES_V is not referenced by any database object