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_PORTAL_RISK_SUMMARY

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length
RISK_CATEGORY	NUMBER
STATUS	VARCHAR2	(50)
TOTAL_RANGE_LOW	NUMBER
TOTAL_RANGE_HIGH	NUMBER
SUPPLIER_PK_KEY	NUMBER
SUPPLIER_NAME	VARCHAR2	(480)
PURCHASE_AMOUNT	NUMBER
TOTAL_SCORE	NUMBER
PRICE_SCORE	NUMBER
QUALITY_SCORE	NUMBER
DELIVERY_SCORE	NUMBER
SERVICE_SCORE	NUMBER
PRICE_RANGE_LOW	NUMBER
PRICE_RANGE_HIGH	NUMBER
QUALITY_RANGE_LOW	NUMBER
QUALITY_RANGE_HIGH	NUMBER
DELIVERY_RANGE_LOW	NUMBER
DELIVERY_RANGE_HIGH	NUMBER
SERVICE_RANGE_LOW	NUMBER
SERVICE_RANGE_HIGH	NUMBER

Query Text

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


SELECT RISK_CATEGORY
,      STATUS
,      TOTAL_RANGE_LOW
,      TOTAL_RANGE_HIGH
,      SUPPLIER_PK_KEY
,      SUPPLIER_NAME
,      PURCHASE_AMOUNT
,      TOTAL_SCORE
,      PRICE_SCORE
,      QUALITY_SCORE
,      DELIVERY_SCORE
,      SERVICE_SCORE
,      PRICE_RANGE_LOW
,      PRICE_RANGE_HIGH
,      QUALITY_RANGE_LOW
,      QUALITY_RANGE_HIGH
,      DELIVERY_RANGE_LOW
,      DELIVERY_RANGE_HIGH
,      SERVICE_RANGE_LOW
,      SERVICE_RANGE_HIGH
FROM POA.POA_PORTAL_RISK_SUMMARY;

Dependencies

[top of page]

POA.POA_PORTAL_RISK_SUMMARY does not reference any database object

POA.POA_PORTAL_RISK_SUMMARY is referenced by following:

APPS: POA_PORTAL_RISK_SUMMARY