View: IBC_PENDING_APPROVALS_V

Product:	IBC - Content Manager
Description:
Implementation/DBA Data:	APPS.IBC_PENDING_APPROVALS_V

View Text

SELECT SUBSTR(A.ITEM_KEY
, 1
, INSTR(A.ITEM_KEY
, '@') - 1) CITEM_VERSION_ID
, A.ITEM_KEY
, U.USER_NAME
, A.ACTIVITY_BEGIN_DATE NOTIFICATION_BEGIN_DATE
FROM WF_ITEM_ACTIVITY_STATUSES_V A
, WF_USER_ROLES U
WHERE A.ITEM_TYPE = 'IBC_WF'
AND A.ACTIVITY_NAME = 'IBC_CITEM_APPROVE_NOTIFICATION'
AND A.ACTIVITY_STATUS_CODE = 'NOTIFIED'
AND A.ASSIGNED_USER = U.ROLE_NAME

Columns