[Home] [Help]
VIEW: APPS.POA_PORTAL_RISK_IND_V
Source
View Text - Preformatted
SELECT decode(Risk_Category, 1, '', 2, '', 3, '', ''), fnd.meaning, Sum(Aggregate), Sum(Price), Sum(Quality), Sum(Delivery), Sum(Service), Risk_Category FROM POA_PORTAL_RISK_IND poa, fnd_lookup_values_vl fnd WHERE poa.Risk_Category = fnd.lookup_code and fnd.lookup_type = 'POA_RISK_STATUS' group by Risk_Category, fnd.meaning
View Text - HTML Formatted
SELECT DECODE(RISK_CATEGORY
, 1
, '
'
, 2
, ''
, 3
, ''
, '')
, FND.MEANING
, SUM(AGGREGATE)
, SUM(PRICE)
, SUM(QUALITY)
, SUM(DELIVERY)
, SUM(SERVICE)
, RISK_CATEGORY
FROM POA_PORTAL_RISK_IND POA
, FND_LOOKUP_VALUES_VL FND
WHERE POA.RISK_CATEGORY = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'POA_RISK_STATUS' GROUP BY RISK_CATEGORY
, FND.MEANING