VIEW: APPS.IBC_PENDING_APPROVALS_V

Source

View Text - Preformatted

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 ,LKP.MEANING RELATES_TO ,A.ACTIVITY_NAME ACTIVITY_NAME ,SUBSTR(A.ITEM_KEY ,INSTR(A.ITEM_KEY,'/')+1 ,INSTR(A.ITEM_KEY,'/',1,2)-1-INSTR(A.ITEM_KEY,'/') ) LANGUAGE, U.ROLE_NAME FROM WF_ITEM_ACTIVITY_STATUSES_V A ,WF_USER_ROLES U ,FND_LOOKUP_VALUES LKP WHERE A.ITEM_TYPE = 'IBC_WF' AND A.ACTIVITY_NAME IN ('IBC_CITEM_APPROVE_NOTIFICATION' ,'IBC_CITEM_TRANS_APPROVE_NOTIFY') AND A.ACTIVITY_STATUS_CODE = 'NOTIFIED' AND A.ASSIGNED_USER = U.ROLE_NAME AND LKP.LOOKUP_TYPE = 'IBC_PA_NOTIFICATIONS' AND LKP.LOOKUP_CODE = A.ACTIVITY_NAME and lkp.language = USERENV('LANG')

View Text - HTML Formatted

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
, LKP.MEANING RELATES_TO
, A.ACTIVITY_NAME ACTIVITY_NAME
, SUBSTR(A.ITEM_KEY
, INSTR(A.ITEM_KEY
, '/')+1
, INSTR(A.ITEM_KEY
, '/'
, 1
, 2)-1-INSTR(A.ITEM_KEY
, '/') ) LANGUAGE
, U.ROLE_NAME
FROM WF_ITEM_ACTIVITY_STATUSES_V A
, WF_USER_ROLES U
, FND_LOOKUP_VALUES LKP
WHERE A.ITEM_TYPE = 'IBC_WF'
AND A.ACTIVITY_NAME IN ('IBC_CITEM_APPROVE_NOTIFICATION'
, 'IBC_CITEM_TRANS_APPROVE_NOTIFY')
AND A.ACTIVITY_STATUS_CODE = 'NOTIFIED'
AND A.ASSIGNED_USER = U.ROLE_NAME
AND LKP.LOOKUP_TYPE = 'IBC_PA_NOTIFICATIONS'
AND LKP.LOOKUP_CODE = A.ACTIVITY_NAME
AND LKP.LANGUAGE = USERENV('LANG')