DBA Data[Home] [Help]

VIEW: APPS.POA_PMF_MIN_OWN_SP

Source

View Text - Preformatted

SELECT All_Organization, Quarter, sum(Min_Own)/sum(AP_Spend)*100 from POA_PMF_MIN_VIEW_SP group by All_Organization, Quarter
View Text - HTML Formatted

SELECT ALL_ORGANIZATION
, QUARTER
, SUM(MIN_OWN)/SUM(AP_SPEND)*100
FROM POA_PMF_MIN_VIEW_SP GROUP BY ALL_ORGANIZATION
, QUARTER