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

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view lists the items belonging to the child organizations where the description of items is concatenated to the item name

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ID	VARCHAR2	(25)		Unique identifier for organization inventory item
VALUE	VARCHAR2	(240)		Name of inventory item
DESCRIPTION	VARCHAR2	(240)		Item description
INVENTORY_ITEM_ID	NUMBER			Unique identifier for inventory item
ORGANIZATION_ID	VARCHAR2	(40)		Unique identifier for organization the item exists in
INV_CATEGORY_ID	NUMBER			Unique identifier for inventory category item is associated to
INV_CATEGORY_DESC	VARCHAR2	(240)		Description of inventory category item is associated to
MASTER_ID	VARCHAR2	(25)		Unique identifier for Master Organization item
CREATION_DATE	DATE		Yes	Standard WHO column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO column
ITEM_CATALOG_GROUP_ID	NUMBER			Unique identifier for item catalog category item is associated to
ITEM_CATALOG_DESC	VARCHAR2	(240)		Description of item catalog category item is associated to
PRIMARY_UOM_CODE	VARCHAR2	(5)		Primary unit of measure code
UNIT_WEIGHT	NUMBER
UNIT_VOLUME	NUMBER
WEIGHT_UOM_CODE	VARCHAR2	(3)
VOLUME_UOM_CODE	VARCHAR2	(3)

Query Text

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


SELECT ID
,      VALUE
,      DESCRIPTION
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      INV_CATEGORY_ID
,      INV_CATEGORY_DESC
,      MASTER_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      ITEM_CATALOG_GROUP_ID
,      ITEM_CATALOG_DESC
,      PRIMARY_UOM_CODE
,      UNIT_WEIGHT
,      UNIT_VOLUME
,      WEIGHT_UOM_CODE
,      VOLUME_UOM_CODE
FROM APPS.ENI_ITEM_ORG_V;

Dependencies

[top of page]

APPS.ENI_ITEM_ORG_V references the following:

APPS: ENI_OLTP_ITEM_STAR; FND_LOOKUP_VALUES; MTL_CATEGORIES_TL; MTL_ITEM_CATALOG_GROUPS_TL; MTL_SYSTEM_ITEMS_TL

APPS.ENI_ITEM_ORG_V is referenced by following:

APPS: ENI_DBI_ITEM_CAT_V