DBA Data[Home] [Help]

VIEW: APPS.CSC_CONDITION_LINES_V

Source

View Text - Preformatted

SELECT DISTINCT CNH_ID CNH_ID, DECODE( CNL_TYPE ,'CEX','Counter','FEX','Function','GEX','Expression') CONDITION_TYPE, DESCRIPTION DESCRIPTION FROM OKC_CONDITION_LINES_V
View Text - HTML Formatted

SELECT DISTINCT CNH_ID CNH_ID
, DECODE( CNL_TYPE
, 'CEX'
, 'COUNTER'
, 'FEX'
, 'FUNCTION'
, 'GEX'
, 'EXPRESSION') CONDITION_TYPE
, DESCRIPTION DESCRIPTION
FROM OKC_CONDITION_LINES_V