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_MESSAGE_ATTRIBUTES_VL

Line 1652: , WF_MESSAGE_ATTRIBUTES_VL MA

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
1656: AND MA.MESSAGE_NAME IN (

Line 1658: from wf_message_attributes_vl x

1654: AND N.MESSAGE_TYPE = MA.MESSAGE_TYPE
1655: AND N.MESSAGE_NAME = MA.MESSAGE_NAME
1656: AND MA.MESSAGE_NAME IN (
1657: select x.message_name
1658: from wf_message_attributes_vl x
1659: where x.subtype = 'SEND'
1660: and NOT EXISTS(
1661: select '1'
1662: from wf_message_attributes_vl b

Line 1662: from wf_message_attributes_vl b

1658: from wf_message_attributes_vl x
1659: where x.subtype = 'SEND'
1660: and NOT EXISTS(
1661: select '1'
1662: from wf_message_attributes_vl b
1663: where b.subtype = 'RESPOND'
1664: and b.message_name = MA.MESSAGE_NAME)
1665: )
1666: AND N.MESSAGE_TYPE = 'AMV_APPR'