DBA Data[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