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_RPT_EFC

Object Details

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

POA_BIS_SAVINGS_RPT_EFC holds data in original sob currency before the euro switch

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	5
PCT Used:

Columns

Name	Datatype	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
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
,      SECURITY_GROUP_ID
FROM PO.POA_BIS_SAVINGS_RPT_EFC;

Dependencies

[top of page]

PO.POA_BIS_SAVINGS_RPT_EFC does not reference any database object

PO.POA_BIS_SAVINGS_RPT_EFC is referenced by following:

APPS: POA_BIS_SAVINGS_RPT_EFC