VIEW: APPS.PA_MASS_TXN_ASGMT_SUCCESS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'