VIEW: APPS.JTF_LOOKUPS_BRM_WF_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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