VIEW: APPS.POA_PORTAL_PURCHASES_ORG_V

Source

View Text - Preformatted

SELECT OPERATING_UNIT_PK_KEY, OPERATING_UNIT_NAME, category_pk_key, category_name, sum(nvl(v_current,0)), sum(nvl(v_previous,0)) FROM ( select OPERATING_UNIT_PK_KEY, OPERATING_UNIT_NAME, Category_PK_Key, Category_Name, sum(sum_purchases) v_current, 0 v_previous from POA_PORTAL_PDIST WHERE quarter = 'C' AND sum_purchases <> 0 AND SUM_PURCHASES IS NOT NULL GROUP BY OPERATING_UNIT_PK_KEY, OPERATING_UNIT_NAME, Category_PK_Key, Category_Name UNION ALL select OPERATING_UNIT_PK_KEY, OPERATING_UNIT_NAME, Category_PK_Key, Category_Name, 0, sum(sum_purchases) from POA_PORTAL_PDIST WHERE QUARTER = 'L' AND sum_purchases <> 0 AND SUM_PURCHASES IS NOT NULL group by OPERATING_UNIT_PK_KEY, OPERATING_UNIT_NAME, Category_PK_Key, Category_Name) GROUP BY OPERATING_UNIT_PK_KEY, OPERATING_UNIT_NAME, Category_PK_Key, Category_Name

View Text - HTML Formatted

SELECT OPERATING_UNIT_PK_KEY
, OPERATING_UNIT_NAME
, CATEGORY_PK_KEY
, CATEGORY_NAME
, SUM(NVL(V_CURRENT
, 0))
, SUM(NVL(V_PREVIOUS
, 0))
FROM ( SELECT OPERATING_UNIT_PK_KEY
, OPERATING_UNIT_NAME
, CATEGORY_PK_KEY
, CATEGORY_NAME
, SUM(SUM_PURCHASES) V_CURRENT
, 0 V_PREVIOUS
FROM POA_PORTAL_PDIST
WHERE QUARTER = 'C'
AND SUM_PURCHASES <> 0
AND SUM_PURCHASES IS NOT NULL GROUP BY OPERATING_UNIT_PK_KEY
, OPERATING_UNIT_NAME
, CATEGORY_PK_KEY
, CATEGORY_NAME UNION ALL SELECT OPERATING_UNIT_PK_KEY
, OPERATING_UNIT_NAME
, CATEGORY_PK_KEY
, CATEGORY_NAME
, 0
, SUM(SUM_PURCHASES)
FROM POA_PORTAL_PDIST
WHERE QUARTER = 'L'
AND SUM_PURCHASES <> 0
AND SUM_PURCHASES IS NOT NULL GROUP BY OPERATING_UNIT_PK_KEY
, OPERATING_UNIT_NAME
, CATEGORY_PK_KEY
, CATEGORY_NAME) GROUP BY OPERATING_UNIT_PK_KEY
, OPERATING_UNIT_NAME
, CATEGORY_PK_KEY
, CATEGORY_NAME