FND Design Data [Home] [Help]

View: CSC_CONDITION_OUTCOMES_V

Product: CSC - Customer Care
Description: Registration of a PL/SQL process or a workflow with the application for use as an OUTCOME, CONTRACT PROCESS, QA PROCESS, or FUNCTION in a CONDITION LINE.
Implementation/DBA Data: ViewAPPS.CSC_CONDITION_OUTCOMES_V
View Text

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

Columns

Name
ID
PDF_TYPE
SFWT_FLAG
DESCRIPTION
SHORT_DESCRIPTION
COMMENTS
USAGE
NAME
EXECUTABLE_NAME
WF_NAME
WF_PROCESS_NAME
PROCEDURE_NAME
PACKAGE_NAME
PROCESS_DEFINITION_TYPE
BEGIN_DATE
END_DATE