View: JTF_LOOKUPS_BRM_WF_V

Product:	JTF - CRM Foundation
Description:	View used to select workflow processes in JTFBRWKB form
Implementation/DBA Data:	APPS.JTF_LOOKUPS_BRM_WF_V

View Text

SELECT ITEM_TYPE WF_ITEM_TYPE
, PROCESS_NAME WF_PROCESS_NAME
, DISPLAY_NAME WF_DESCRIPTION
FROM WF_RUNNABLE_PROCESSES_V
WHERE ITEM_TYPE IN ( SELECT FND.LOOKUP_CODE
FROM FND_LOOKUPS FND
WHERE FND.LOOKUP_TYPE = 'JTF_BRM_WF_ITEM_TYPE'
AND FND.ENABLED_FLAG = 'Y'
AND ( FND.START_DATE_ACTIVE <= SYSDATE OR FND.START_DATE_ACTIVE IS NULL )
AND ( FND.END_DATE_ACTIVE > SYSDATE OR FND.END_DATE_ACTIVE IS NULL ) ) ORDER BY ITEM_TYPE
, PROCESS_NAME

Columns