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]

VIEW: APPS.POA_REP_SUP_SCORE_V

Object Details

Object Name:	POA_REP_SUP_SCORE_V
Object Type:	VIEW
Owner:	APPS
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.

View Type

Internal

[View Source]

Columns

Name	Datatype	Mandatory
ALL_ORGANIZATION	NUMBER
OPERATING_UNIT	NUMBER
ORGANIZATION	NUMBER	Yes
ALL_ITEM	NUMBER
COMMODITY	NUMBER
ITEM	NUMBER
ALL_TRADING_PARTNER	NUMBER
PARENT_SUPPLIER	NUMBER
SUPPLIER	NUMBER
SUPPLIER_SITE	NUMBER	Yes
ALL_TIME	NUMBER
YEAR	NUMBER
QUARTER	NUMBER
MONTH	NUMBER
ALL_DUNS	NUMBER
DUNS_GLOBAL_ULT	NUMBER
DUNS_DOMESTIC_ULT	NUMBER
DUNS_PARENT	NUMBER
DUNS_HEADQUARTERS	NUMBER
DUNS_NAME	NUMBER	Yes
UNSPSC_SEGMENT	NUMBER
UNSPSC_FAMILY	NUMBER
UNSPSC_CLASS	NUMBER
UNSPSC_COMMODITY	NUMBER
UNSPSC_FUNCTION	NUMBER	Yes
ALL_UNSPSC	NUMBER
QUANTITY	NUMBER
PRICE	NUMBER
TARGET_PRICE	NUMBER
AMT_PURCHASED	NUMBER
PRICE_SCORE	NUMBER
DELIVERY_SCORE	NUMBER
QUALITY_SCORE	NUMBER
SURVEY_SCORE	NUMBER
TOTAL_SCORE	NUMBER

Query Text

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


SELECT ALL_ORGANIZATION
,      OPERATING_UNIT
,      ORGANIZATION
,      ALL_ITEM
,      COMMODITY
,      ITEM
,      ALL_TRADING_PARTNER
,      PARENT_SUPPLIER
,      SUPPLIER
,      SUPPLIER_SITE
,      ALL_TIME
,      YEAR
,      QUARTER
,      MONTH
,      ALL_DUNS
,      DUNS_GLOBAL_ULT
,      DUNS_DOMESTIC_ULT
,      DUNS_PARENT
,      DUNS_HEADQUARTERS
,      DUNS_NAME
,      UNSPSC_SEGMENT
,      UNSPSC_FAMILY
,      UNSPSC_CLASS
,      UNSPSC_COMMODITY
,      UNSPSC_FUNCTION
,      ALL_UNSPSC
,      QUANTITY
,      PRICE
,      TARGET_PRICE
,      AMT_PURCHASED
,      PRICE_SCORE
,      DELIVERY_SCORE
,      QUALITY_SCORE
,      SURVEY_SCORE
,      TOTAL_SCORE
FROM APPS.POA_REP_SUP_SCORE_V;

Dependencies

[top of page]

APPS.POA_REP_SUP_SCORE_V references the following:

APPS: EDW_DUNS_M; EDW_ITEMS_M; EDW_ORGANIZATION_M; EDW_TIME_M; EDW_TRD_PARTNER_M; EDW_UNSPSC_M; POA_REP_CSTM_MSR_V

APPS.POA_REP_SUP_SCORE_V is referenced by following:

APPS: POA_PORTAL_POPULATE_C - show dependent code