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]

TABLE: ENI.ENI_ITEM_STAR_TEMP

Object Details

Object Name:	ENI_ITEM_STAR_TEMP
Object Type:	TABLE
Owner:	ENI
Subobject Name:
Status:	VALID

This table will hold item id information when the STAR table needs to be updated with an item which doesn't exist in the STAR table at the time. The records will be updated back into the star table after DBI intial load of the item dimension is complete.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ENI_ITEM_STAR_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	INVENTORY_ITEM_ID ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item Identifier
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier
VALUE	VARCHAR2	(240)		The Item Name
LAST_UPDATE_DATE	DATE			The Last Update Date
INV_CATEGORY_ID	NUMBER			The Catalog Category Identifier to which the item belongs
INV_CONCAT_SEG	VARCHAR2	(240)		The Concatenated Segment Values
INV_CATEGORY_SET_ID	NUMBER			The Inventory Category Set Identifier
VBH_CATEGORY_ID	NUMBER			The Product Catalog Category Identifier
VBH_CONCAT_SEG	VARCHAR2	(240)		The Concatenated Segment Values for the Product catalog category
VBH_CATEGORY_SET_ID	NUMBER			The Product Catalog Identifier
ITEM_CATALOG_GROUP_ID	NUMBER			The Item Catalog Group Identifier
PRIMARY_UOM_CODE	VARCHAR2	(5)		Primary unit of measure code
UNIT_WEIGHT	NUMBER			Conversion between weight unit of measure and base unit of measure
UNIT_VOLUME	NUMBER			Conversion between volume unit of measure and base unit of measure
WEIGHT_UOM_CODE	VARCHAR2	(3)		Weight unit of measure code
VOLUME_UOM_CODE	VARCHAR2	(3)		Volume unit of measure code
EAM_ITEM_TYPE	NUMBER			Asset Item Type
PO_CATEGORY_ID	NUMBER			The PO Catalog Category Identifier to which the item belongs
PO_CONCAT_SEG	VARCHAR2	(240)		The Concatenated Segment Values
PO_CATEGORY_SET_ID	NUMBER			The PO Category Set Identifier

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      VALUE
,      LAST_UPDATE_DATE
,      INV_CATEGORY_ID
,      INV_CONCAT_SEG
,      INV_CATEGORY_SET_ID
,      VBH_CATEGORY_ID
,      VBH_CONCAT_SEG
,      VBH_CATEGORY_SET_ID
,      ITEM_CATALOG_GROUP_ID
,      PRIMARY_UOM_CODE
,      UNIT_WEIGHT
,      UNIT_VOLUME
,      WEIGHT_UOM_CODE
,      VOLUME_UOM_CODE
,      EAM_ITEM_TYPE
,      PO_CATEGORY_ID
,      PO_CONCAT_SEG
,      PO_CATEGORY_SET_ID
FROM ENI.ENI_ITEM_STAR_TEMP;

Dependencies

[top of page]

ENI.ENI_ITEM_STAR_TEMP does not reference any database object

ENI.ENI_ITEM_STAR_TEMP is referenced by following:

APPS: ENI_ITEM_STAR_TEMP