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

Object Details

Object Name:	OKL_OR_AS_ADDON_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_OR_AS_ADDON_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
CLEV_ADDON_ID	NUMBER		Yes	System generated unique identifier. Primary key column of the table.
DNZ_CHR_ID	NUMBER		Yes	Contract ID. Denormalized for performance.
PRICE_UNIT	NUMBER			Price per unit.
CLE_ID	NUMBER			ID of the parent Line. A line can have sub-lines. Refers to ID in OKC_K_LINES_B.
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.
INVENTORY_ORG_ID	VARCHAR2	(200)		Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view.
JTOT_OBJECT1_CODE	VARCHAR2	(30)		Foreign key to JTF_OBJECTS_B. Represents view referenced by OBJECT_ID columns.
NUMBER_OF_ITEMS	NUMBER			Number of items.
INVENTORY_ITEM_NAME	VARCHAR2	(240)		This column contains Item translated description
MANUFACTURER_NAME	VARCHAR2	(360)		Manufacturer name
MODEL_NUMBER	VARCHAR2	(40)		Model number
YEAR_OF_MANUFACTURE	VARCHAR2	(240)		Year in which the item/asset is manufactured
VENDOR_NAME	VARCHAR2	(240)		Supplier name
CPL_ID	NUMBER			Unique identifier of contract party role. Primary key column
VENDOR_ID	VARCHAR2	(40)		Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. First part of primary key in view.
OBJECT1_ID2	VARCHAR2	(200)		Foreign key to an OKX view identifitied by corresponding JTOT_OBJECT_CODE column. Second part of primary key in view.
RLE_CODE	VARCHAR2	(30)		Role code for this party. Refers to lookup_code in fnd_lookups where lookup_type = OKC_ROLE.
NOTES	VARCHAR2	(1995)		User entered comment.
ORIG_SYSTEM_ID1	NUMBER			Original system id reference

Query Text

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


SELECT CLEV_ADDON_ID
,      DNZ_CHR_ID
,      PRICE_UNIT
,      CLE_ID
,      INVENTORY_ITEM_ID
,      INVENTORY_ORG_ID
,      JTOT_OBJECT1_CODE
,      NUMBER_OF_ITEMS
,      INVENTORY_ITEM_NAME
,      MANUFACTURER_NAME
,      MODEL_NUMBER
,      YEAR_OF_MANUFACTURE
,      VENDOR_NAME
,      CPL_ID
,      VENDOR_ID
,      OBJECT1_ID2
,      RLE_CODE
,      NOTES
,      ORIG_SYSTEM_ID1
FROM APPS.OKL_OR_AS_ADDON_V;

Dependencies

[top of page]

APPS.OKL_OR_AS_ADDON_V references the following:

APPS: MTL_SYSTEM_ITEMS_B; MTL_SYSTEM_ITEMS_TL; OKC_K_ITEMS; OKC_K_LINES_B; OKC_K_LINES_TL; OKC_K_PARTY_ROLES_B; OKC_LINE_STYLES_B; OKL_K_LINES; PO_VENDORS

APPS.OKL_OR_AS_ADDON_V is not referenced by any database object