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: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
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:

SchemaAPPS
SynonymPOA_PORTAL_RISK_SUMMARY