View: PA_MASS_TXN_ASGMT_SUCCESS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_MASS_TXN_ASGMT_SUCCESS_V

View Text

SELECT ITEM_TYPE
, ITEM_KEY
, WF_TYPE_CODE
, DECODE(WF_TYPE_CODE
, 'MASS_ASGMT'
, OBJECT_ID2
, OBJECT_ID1)
FROM PA_WF_PROCESS_DETAILS
WHERE WF_TYPE_CODE IN ('MASS_ASGMT'
, 'MASS_UPDATE_ASGMT_BASIC_INFO'
, 'MASS_UPDATE_COMPETENCIES'
, 'MASS_UPDATE_FORECAST_ITEMS'
, 'MASS_SUBMIT_FOR_APPROVAL'
, 'MASS_UPDATE_SCHEDULE')
AND PROCESS_STATUS_CODE = 'S'

Columns