eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: SY_REAS_CDS_VL

Product:	GMA - Process Manufacturing Systems
Description:	MLS enabled view of OPM Reason Codes.
Implementation/DBA Data:	APPS.SY_REAS_CDS_VL

View Text

SELECT B.ROWID ROW_ID
, B.REASON_CODE
, B.REASON_DESC2
, B.REASON_TYPE
, B.FLOW_TYPE
, B.AUTH_STRING
, B.DELETE_MARK
, B.TEXT_CODE
, B.TRANS_CNT
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, T.REASON_DESC1
FROM SY_REAS_CDS_TL T
, SY_REAS_CDS_B B
WHERE B.REASON_CODE = T.REASON_CODE
AND T.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
REASON_CODE
REASON_DESC2
REASON_TYPE
FLOW_TYPE
AUTH_STRING
DELETE_MARK
TEXT_CODE
TRANS_CNT
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
REASON_DESC1