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

Object Details

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

View that joins the inventory item dimension with Purchasing Item

[View Source]

Columns

Name	Datatype	Length	Comments
ID	VARCHAR2	(25)	PO Item Id
VALUE	VARCHAR2	(406)	PO Item Name
ORGANIZATION_CODE	VARCHAR2	(3)	Organization Code
INVENTORY_ITEM_ID	NUMBER		Inventory Item Identifier
ORGANIZATION_ID	NUMBER		Organization Identifier
PO_CATEGORY_ID	NUMBER		PO Category Identifier
PO_CATEGORY_SET_ID	NUMBER		PO Category Set Identifier
PO_CONCAT_SEG	VARCHAR2	(200)	Category Concatenated Segments
INV_CATEGORY_ID	NUMBER		Inventory Category Identifier
INV_CATEGORY_SET_ID	NUMBER		Inventory Category Set Identifier
INV_CONCAT_SEG	VARCHAR2	(200)	Inventory Concatenated Segments
VBH_CATEGORY_ID	NUMBER		Product Category Identifier
VBH_CATEGORY_SET_ID	NUMBER		Product Category Set Identifier
VBH_CONCAT_SEG	VARCHAR2	(200)	Product Concatenated Segments
MASTER_ID	VARCHAR2	(25)	Master Identifier
CREATION_DATE	DATE		WHO column
LAST_UPDATE_DATE	DATE		WHO column
ITEM_CATALOG_GROUP_ID	NUMBER		Item Catalog Group Identifier
PRIMARY_UOM_CODE	VARCHAR2	(5)	Primary UOM Code
UNIT_WEIGHT	NUMBER		Unit Weight
UNIT_VOLUME	NUMBER		Unit Volume
WEIGHT_UOM_CODE	VARCHAR2	(3)	Weight UOM Code
VOLUME_UOM_CODE	VARCHAR2	(3)	Volume UOM Code
PO_ITEM_ID	NUMBER		PO Item Identifier
PO_ITEM_DESCRIPTION	VARCHAR2	(240)	PO Item Description

Query Text

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


SELECT ID
,      VALUE
,      ORGANIZATION_CODE
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PO_CATEGORY_ID
,      PO_CATEGORY_SET_ID
,      PO_CONCAT_SEG
,      INV_CATEGORY_ID
,      INV_CATEGORY_SET_ID
,      INV_CONCAT_SEG
,      VBH_CATEGORY_ID
,      VBH_CATEGORY_SET_ID
,      VBH_CONCAT_SEG
,      MASTER_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      ITEM_CATALOG_GROUP_ID
,      PRIMARY_UOM_CODE
,      UNIT_WEIGHT
,      UNIT_VOLUME
,      WEIGHT_UOM_CODE
,      VOLUME_UOM_CODE
,      PO_ITEM_ID
,      PO_ITEM_DESCRIPTION
FROM APPS.POA_ENI_OLTP_ITEM_STAR_V;

Dependencies

[top of page]

APPS.POA_ENI_OLTP_ITEM_STAR_V references the following:

APPS: ENI_OLTP_ITEM_STAR; MTL_CATEGORIES_KFV; POA_ITEMS; POA_ITEMS_MV

APPS.POA_ENI_OLTP_ITEM_STAR_V is not referenced by any database object