eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSL_WF_NOTIFICATION_AT_ACC_PKG dependencies on ASG_USER

Line 362: ASG_USER ADU

358: SELECT DISTINCT WNO.NOTIFICATION_ID
359: FROM WF_NOTIFICATIONS WNO,
360: WF_NOTIFICATION_ATTRIBUTES WNA,
361: FND_USER USR,
362: ASG_USER ADU
363: WHERE WNO.NOTIFICATION_ID = WNA.NOTIFICATION_ID
364: AND WNA.NAME = 'SENDER'
365: AND WNO.MESSAGE_TYPE = 'CS_MSGS'
366: AND WNO.MESSAGE_NAME = 'FYI_MESSAGE'

Line 377: ASG_USER ADU

373: CURSOR c_notification_receive (b_resource_id NUMBER) IS
374: SELECT DISTINCT WNO.NOTIFICATION_ID
375: FROM WF_NOTIFICATIONS WNO,
376: FND_USER USR,
377: ASG_USER ADU
378: WHERE WNO.RECIPIENT_ROLE = USR.USER_NAME
379: AND USR.USER_ID = ADU.USER_ID
380: AND ADU.RESOURCE_ID = b_resource_id
381: AND WNO.STATUS = 'OPEN'

Line 541: ASG_USER ADU

537: USR.USER_ID
538: FROM WF_NOTIFICATIONS WNO,
539: WF_NOTIFICATION_ATTRIBUTES WNA,
540: FND_USER USR,
541: ASG_USER ADU
542: WHERE WNO.NOTIFICATION_ID = WNA.NOTIFICATION_ID
543: AND WNA.NAME = 'SENDER'
544: AND WNA.TEXT_VALUE = USR.USER_NAME
545: AND USR.USER_ID = ADU.USER_ID

Line 554: ASG_USER ADU

550: SELECT DISTINCT WNO.NOTIFICATION_ID,
551: USR.USER_ID
552: FROM WF_NOTIFICATIONS WNO,
553: FND_USER USR,
554: ASG_USER ADU
555: WHERE WNO.RECIPIENT_ROLE = USR.USER_NAME
556: AND USR.USER_ID = ADU.USER_ID
557: AND ADU.RESOURCE_ID = b_resource_id
558: AND WNO.STATUS = 'OPEN'