View: WIP_WORKFLOW_V

Product:	WIP - Work in Process
Description:	Workflows that have been launched for job/repetitive schedules
Implementation/DBA Data:	APPS.WIP_WORKFLOW_V

View Text

SELECT WIAV.ITEM_TYPE
, WIAV.ITEM_KEY
, WIAV.NUMBER_VALUE
, WIAV1.NUMBER_VALUE
, WI.BEGIN_DATE
, WI.END_DATE
FROM WF_ITEM_ATTRIBUTE_VALUES WIAV
, WF_ITEM_ATTRIBUTE_VALUES WIAV1
, WF_ITEMS WI
WHERE WIAV.ITEM_TYPE IN ('WIPISHPW'
, 'WIPUPNBD')
AND WIAV.NAME = 'WIP_ENTITY_ID'
AND WIAV1.ITEM_TYPE = WIAV.ITEM_TYPE
AND WIAV1.ITEM_KEY = WIAV.ITEM_KEY
AND WIAV1.NAME = 'REP_SCHEDULE_ID'
AND WI.ITEM_TYPE = WIAV.ITEM_TYPE
AND WI.ITEM_KEY = WIAV.ITEM_KEY

Columns