DBA Data[Home] [Help]

VIEW: APPS.CE_FORECAST_ERRORS_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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