DBA Data[Home] [Help]

VIEW: APPS.CE_FC_RX_TITLE1_V

Source

View Text - Preformatted

SELECT F.FORECAST_NAME , MAX(COLUMN1) , MAX(COLUMN2) , MAX(COLUMN3) , MAX(COLUMN4) , MAX(COLUMN5) , MAX(COLUMN6) , MAX(COLUMN7) , MAX(COLUMN8) , MAX(COLUMN9) , MAX(COLUMN10) , MAX(COLUMN11) , MAX(COLUMN12) FROM CE_FC_RX_COLUMN_TITLE_V F GROUP BY F.FORECAST_NAME
View Text - HTML Formatted

SELECT F.FORECAST_NAME
, MAX(COLUMN1)
, MAX(COLUMN2)
, MAX(COLUMN3)
, MAX(COLUMN4)
, MAX(COLUMN5)
, MAX(COLUMN6)
, MAX(COLUMN7)
, MAX(COLUMN8)
, MAX(COLUMN9)
, MAX(COLUMN10)
, MAX(COLUMN11)
, MAX(COLUMN12)
FROM CE_FC_RX_COLUMN_TITLE_V F GROUP BY F.FORECAST_NAME