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: POA.POA_ITEMS

Object Details

Object Name:	POA_ITEMS
Object Type:	TABLE
Owner:	POA
Subobject Name:
Status:	VALID

POA specific item table populated during the (daily) collection process. The only operation allowed on this table is insertation.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
POA_ITEMS_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	PO_ITEM_ID
POA_ITEMS_U2	NORMAL	UNIQUE	APPS_TS_SUMMARY	ITEM_ID CATEGORY_ID VENDOR_PRODUCT_NUM VENDOR_ID DESCRIPTION ORGANIZATION_ID
POA_ITEMS_U3	NORMAL	UNIQUE	APPS_TS_SUMMARY	VENDOR_PRODUCT_NUM VENDOR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PO_ITEM_ID	NUMBER		Yes	Primary Key
ITEM_ID	NUMBER			Item Id
ORGANIZATION_ID	NUMBER			Master inventory organization id
CATEGORY_ID	NUMBER			category id
VENDOR_PRODUCT_NUM	VARCHAR2	(125)		Supplier Product Number
VENDOR_ID	NUMBER			Supplier Id
DESCRIPTION	VARCHAR2	(240)		Description

Query Text

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


SELECT PO_ITEM_ID
,      ITEM_ID
,      ORGANIZATION_ID
,      CATEGORY_ID
,      VENDOR_PRODUCT_NUM
,      VENDOR_ID
,      DESCRIPTION
FROM POA.POA_ITEMS;

Dependencies

[top of page]

POA.POA_ITEMS does not reference any database object

POA.POA_ITEMS is referenced by following:

APPS: POA_ITEMS; POA_ITEMS_MV