DBA Data[Home] [Help]

VIEW: APPS.POA_PORTAL_CUR_LINE_V

Source

View Text - Preformatted

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