DBA Data[Home] [Help]

VIEW: APPS.POA_PMF_SB_OWN_SP

Source

View Text - Preformatted

SELECT All_Organization, Quarter, sum(SB_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(SB_OWN)/SUM(AP_SPEND)*100
FROM POA_PMF_MIN_VIEW_SP GROUP BY ALL_ORGANIZATION
, QUARTER