SELECT OPERATING_UNIT_PK_KEY,ORGANIZATION_PK_KEY,CNT_PO_LINES,CNT_PO_HEADERS,SUM_PURCHASES FROM POA_PORTAL_PDIST WHERE quarter = 'C' AND SUM_PURCHASES IS NOT NULL AND SUM_PURCHASES <> 0
View Text - HTML Formatted
SELECT OPERATING_UNIT_PK_KEY , ORGANIZATION_PK_KEY , CNT_PO_LINES , CNT_PO_HEADERS , SUM_PURCHASES FROM POA_PORTAL_PDIST WHERE QUARTER = 'C' AND SUM_PURCHASES IS NOT NULL AND SUM_PURCHASES <> 0