VIEW: APPS.CSC_CONDITION_OUTCOMES_V

Source

View Text - Preformatted

SELECT ID ID, PDF_TYPE PDF_TYPE, SFWT_FLAG SFWT_FLAG, DESCRIPTION DESCRIPTION, SHORT_DESCRIPTION SHORT_DESCRIPTION, COMMENTS COMMENTS, USAGE USAGE, NAME NAME, DECODE ( PDF_TYPE,'PPS',PROCEDURE_NAME,'WPS',WF_NAME,'ALERT',NAME, 'SCRIPT', NAME) EXECUTABLE_NAME, WF_NAME WF_NAME, WF_PROCESS_NAME WF_PROCESS_NAME, PROCEDURE_NAME PROCEDURE_NAME, PACKAGE_NAME PACKAGE_NAME, DECODE ( PDF_TYPE, 'PPS' , 'PROCEDURE' , 'WPS' , 'WORK FLOW' , PDF_TYPE ) PROCESS_DEFINITION_TYPE , BEGIN_DATE BEGIN_DATE, END_DATE END_DATE FROM OKC_PROCESS_DEFS_V

View Text - HTML Formatted

SELECT ID ID
, PDF_TYPE PDF_TYPE
, SFWT_FLAG SFWT_FLAG
, DESCRIPTION DESCRIPTION
, SHORT_DESCRIPTION SHORT_DESCRIPTION
, COMMENTS COMMENTS
, USAGE USAGE
, NAME NAME
, DECODE ( PDF_TYPE
, 'PPS'
, PROCEDURE_NAME
, 'WPS'
, WF_NAME
, 'ALERT'
, NAME
, 'SCRIPT'
, NAME) EXECUTABLE_NAME
, WF_NAME WF_NAME
, WF_PROCESS_NAME WF_PROCESS_NAME
, PROCEDURE_NAME PROCEDURE_NAME
, PACKAGE_NAME PACKAGE_NAME
, DECODE ( PDF_TYPE
, 'PPS'
, 'PROCEDURE'
, 'WPS'
, 'WORK FLOW'
, PDF_TYPE ) PROCESS_DEFINITION_TYPE
, BEGIN_DATE BEGIN_DATE
, END_DATE END_DATE
FROM OKC_PROCESS_DEFS_V