[Home] [Help]
View: CE_FORECAST_ERRORS_V
View Text
SELECT E.ROWID ROW_ID
, E.FORECAST_ID FORECAST_ID
, E.MESSAGE_NAME MESSAGE_NAME
, E.CREATION_DATE CREATION_DATE
, E.CREATED_BY CREATED_BY
, E.APPLICATION_SHORT_NAME APPLICATION_SHORT_NAME
, E.FORECAST_ROW_ID FORECAST_ROW_ID
, R.ROW_NUMBER ROW_NUMBER
, E.MESSAGE_TEXT MESSAGE_TEXT
FROM CE_FORECAST_ERRORS E
, CE_FORECAST_ROWS R
WHERE R.FORECAST_ROW_ID(+) = E.FORECAST_ROW_ID
Columns
Name |
ROW_ID |
FORECAST_ID |
MESSAGE_NAME |
CREATION_DATE |
CREATED_BY |
APPLICATION_SHORT_NAME |
FORECAST_ROW_ID |
ROW_NUMBER |
MESSAGE_TEXT |