VIEW: APPS.WIP_INTERFACE_ERRORS_V

Source

View Text - Preformatted

SELECT WIE.ROWID ROW_ID , INTERFACE_ID , ERROR_TYPE , ML.MEANING ERROR_TYPE_MEANING , ERROR , WIE.LAST_UPDATED_BY , WIE.LAST_UPDATE_DATE , WIE.CREATED_BY , WIE.CREATION_DATE , WIE.LAST_UPDATE_LOGIN FROM MFG_LOOKUPS ML, WIP_INTERFACE_ERRORS WIE WHERE ML.LOOKUP_TYPE = 'WIP_ML_ERROR_TYPE' AND ML.LOOKUP_CODE = WIE.ERROR_TYPE

View Text - HTML Formatted

SELECT WIE.ROWID ROW_ID
, INTERFACE_ID
, ERROR_TYPE
, ML.MEANING ERROR_TYPE_MEANING
, ERROR
, WIE.LAST_UPDATED_BY
, WIE.LAST_UPDATE_DATE
, WIE.CREATED_BY
, WIE.CREATION_DATE
, WIE.LAST_UPDATE_LOGIN
FROM MFG_LOOKUPS ML
, WIP_INTERFACE_ERRORS WIE
WHERE ML.LOOKUP_TYPE = 'WIP_ML_ERROR_TYPE'
AND ML.LOOKUP_CODE = WIE.ERROR_TYPE