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.AMV_MYCHANNEL_PVT dependencies on WF_NOTIFICATIONS

Line 1638: FROM WF_NOTIFICATIONS N

1634: l_rec_num number := 1;
1635: --
1636: CURSOR Get_Approvals IS
1637: SELECT N.NOTIFICATION_ID
1638: FROM WF_NOTIFICATIONS N
1639: WHERE N.RECIPIENT_ROLE = l_recipient_role
1640: AND N.MESSAGE_TYPE = 'AMV_APPR'
1641: AND N.STATUS = l_status
1642: AND EXISTS

Line 1651: FROM WF_NOTIFICATIONS_VIEW N

1647: AND MA.SUBTYPE = 'RESPOND');
1648:
1649: CURSOR Get_Notifications IS
1650: select DISTINCT N.NOTIFICATION_ID
1651: FROM WF_NOTIFICATIONS_VIEW N
1652: , WF_MESSAGE_ATTRIBUTES_VL MA
1653: WHERE N.RECIPIENT_ROLE = l_recipient_role
1654: AND N.MESSAGE_TYPE = MA.MESSAGE_TYPE
1655: AND N.MESSAGE_NAME = MA.MESSAGE_NAME

Line 1676: FROM WF_NOTIFICATIONS_VIEW

1672: , END_DATE
1673: , DUE_DATE
1674: , STATUS
1675: , PRIORITY
1676: FROM WF_NOTIFICATIONS_VIEW
1677: WHERE NOTIFICATION_ID = l_notification_id
1678: AND RECIPIENT_ROLE = l_recipient_role
1679: AND STATUS = l_status
1680: ORDER BY BEGIN_DATE;