[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 |
APPS.CE_FORECAST_ERRORS_V