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: PO.POA_BIS_SUPPLIER_PERFORMAN_EFC

Object Details

Object Name:	POA_BIS_SUPPLIER_PERFORMAN_EFC
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.POA_BIS_SUPPLIER_PERFORMAN_EFC
Subobject Name:
Status:	VALID

POA_BIS_SUPPLIER_PERFORMAN_EFC holds data in original sob currency before the euro switch

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
AMOUNT	NUMBER			amount
PURCHASE_PRICE	NUMBER			purchase price
SHIP_TO_ORGANIZATION_ID	NUMBER		Yes	ship to organization identifier
SET_OF_BOOKS_ID	NUMBER			set of books identifier
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
RATE	NUMBER			Currency conversion rate
SECURITY_GROUP_ID	NUMBER			security group

Query Text

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


SELECT AMOUNT
,      PURCHASE_PRICE
,      SHIP_TO_ORGANIZATION_ID
,      SET_OF_BOOKS_ID
,      CURRENCY_CODE
,      RATE
,      SECURITY_GROUP_ID
FROM PO.POA_BIS_SUPPLIER_PERFORMAN_EFC;

Dependencies

[top of page]

PO.POA_BIS_SUPPLIER_PERFORMAN_EFC does not reference any database object

PO.POA_BIS_SUPPLIER_PERFORMAN_EFC is referenced by following:

APPS: POA_BIS_SUPPLIER_PERFORMAN_EFC