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_SAVINGS_EFC

Object Details

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

POA_BIS_SAVINGS_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	Comments
NON_CONTRACT_AMOUNT	NUMBER		non contract amount
CONTRACT_AMOUNT	NUMBER		contract amount
POT_CONTRACT_AMOUNT	NUMBER		pot contract amount
PURCHASE_AMOUNT	NUMBER		purchase amount
SHIP_TO_ORGANIZATION_ID	NUMBER		ship to organization identifier
POTENTIAL_SAVING	NUMBER		potential saving
SET_OF_BOOKS_ID	NUMBER		set of books identifier
CURRENCY_CODE	VARCHAR2	(15)	currency code
SECURITY_GROUP_ID	NUMBER		security group

Query Text

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


SELECT NON_CONTRACT_AMOUNT
,      CONTRACT_AMOUNT
,      POT_CONTRACT_AMOUNT
,      PURCHASE_AMOUNT
,      SHIP_TO_ORGANIZATION_ID
,      POTENTIAL_SAVING
,      SET_OF_BOOKS_ID
,      CURRENCY_CODE
,      SECURITY_GROUP_ID
FROM PO.POA_BIS_SAVINGS_EFC;

Dependencies

[top of page]

PO.POA_BIS_SAVINGS_EFC does not reference any database object

PO.POA_BIS_SAVINGS_EFC is referenced by following:

APPS: POA_BIS_SAVINGS_EFC