View: OKC_PROCESS_DEF_OUTCOME_V

Product:	OKC - Contracts Core
Description:	Subtype view for Process Definitions - Outcomes
Implementation/DBA Data:	APPS.OKC_PROCESS_DEF_OUTCOME_V

View Text

SELECT PDF.ID PDF_ID
, PDP.ID PDP_ID
, PDPT.NAME NAME
, PDP.REQUIRED_YN
, PDP.DATA_TYPE DATA_TYPE
, TO_NUMBER(NULL) OCE_ID
FROM OKC_PROCESS_DEFS_B PDF
, OKC_PROCESS_DEF_PARMS_B PDP
, OKC_PROCESS_DEF_PARMS_TL PDPT
WHERE PDF.ID = PDP.PDF_ID
AND PDPT.ID = PDP.ID
AND PDPT.LANGUAGE = USERENV('LANG')
AND PDF.USAGE = 'OUTCOME' UNION SELECT PDF.ID PDF_ID
, PDP.ID PDP_ID
, PDPT.NAME NAME
, PDP.REQUIRED_YN
, PDP.DATA_TYPE DATA_TYPE
, OCE.ID OCE_ID
FROM OKC_PROCESS_DEFS_B PDF
, OKC_PROCESS_DEF_PARMS_B PDP
, OKC_PROCESS_DEF_PARMS_TL PDPT
, OKC_OUTCOMES_B OCE
WHERE PDF.ID = PDP.PDF_ID
AND PDF.USAGE = 'OUTCOME'
AND PDF.ID = OCE.PDF_ID
AND PDPT.ID = PDP.ID
AND PDPT.LANGUAGE = USERENV('LANG')
AND PDP.ID NOT IN(SELECT PDP_ID
FROM OKC_OUTCOME_ARGUMENTS OAT
, OKC_OUTCOMES_B OCE1
WHERE OCE.ID = OAT.OCE_ID
AND OCE1.ID = OCE.ID)

Columns