[Home] [Help]
VIEW: APPS.POA_PMF_TOT_MIN_SP
Source
View Text - Preformatted
SELECT All_Organization, Quarter, sum(Tot_Min)/ sum(AP_Spend)*100 from POA_PMF_MIN_VIEW_SP group by All_Organization, Quarter
View Text - HTML Formatted
SELECT ALL_ORGANIZATION
, QUARTER
, SUM(TOT_MIN)/ SUM(AP_SPEND)*100
FROM POA_PMF_MIN_VIEW_SP GROUP BY ALL_ORGANIZATION
, QUARTER