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.WF_MAIL dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 1292: from WF_NOTIFICATION_ATTRIBUTES WNA,

1288: '', to_char(WNA.DATE_VALUE),
1289: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1290: 'LOOKUP', WNA.TEXT_VALUE,
1291: WNA.TEXT_VALUE) VALUE
1292: from WF_NOTIFICATION_ATTRIBUTES WNA,
1293: WF_NOTIFICATIONS WN,
1294: WF_MESSAGE_ATTRIBUTES_VL WMA
1295: where WNA.NOTIFICATION_ID = nid
1296: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 1363: from WF_NOTIFICATION_ATTRIBUTES WNA,

1359: '', to_char(WNA.DATE_VALUE),
1360: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1361: 'LOOKUP', WNA.TEXT_VALUE,
1362: WNA.TEXT_VALUE) VALUE
1363: from WF_NOTIFICATION_ATTRIBUTES WNA,
1364: WF_NOTIFICATIONS WN,
1365: WF_MESSAGE_ATTRIBUTES_VL WMA
1366: where WNA.NOTIFICATION_ID = nid
1367: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 1771: from WF_NOTIFICATION_ATTRIBUTES WNA,

1767: '', to_char(WNA.DATE_VALUE),
1768: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1769: 'LOOKUP', WNA.TEXT_VALUE,
1770: WNA.TEXT_VALUE) VALUE
1771: from WF_NOTIFICATION_ATTRIBUTES WNA,
1772: WF_NOTIFICATIONS WN,
1773: WF_MESSAGE_ATTRIBUTES_VL WMA
1774: where WNA.NOTIFICATION_ID = nid
1775: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 1855: from WF_NOTIFICATION_ATTRIBUTES WNA,

1851: '', to_char(WNA.DATE_VALUE),
1852: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1853: 'LOOKUP', WNA.TEXT_VALUE,
1854: WNA.TEXT_VALUE) VALUE
1855: from WF_NOTIFICATION_ATTRIBUTES WNA,
1856: WF_NOTIFICATIONS WN,
1857: WF_MESSAGE_ATTRIBUTES_VL WMA
1858: where WNA.NOTIFICATION_ID = nid
1859: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 1958: from WF_NOTIFICATION_ATTRIBUTES WNA,

1954: is
1955: -- SQL Statement for fetching URL RESPONSE attributes.
1956: cursor c1 is
1957: select WMA.NAME, WMA.DISPLAY_NAME, WNA.TEXT_VALUE, WMA.DESCRIPTION
1958: from WF_NOTIFICATION_ATTRIBUTES WNA,
1959: WF_NOTIFICATIONS WN,
1960: WF_MESSAGE_ATTRIBUTES_VL WMA
1961: where WNA.NOTIFICATION_ID = nid
1962: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 2030: from WF_NOTIFICATION_ATTRIBUTES WNA,

2026: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
2027: 'LOOKUP', WNA.TEXT_VALUE,
2028: WNA.TEXT_VALUE), WMA.DESCRIPTION
2029: into disp_name, attr_type, attr_format, attr_value, attr_desc
2030: from WF_NOTIFICATION_ATTRIBUTES WNA,
2031: WF_NOTIFICATIONS WN,
2032: WF_MESSAGE_ATTRIBUTES_VL WMA
2033: where WNA.NOTIFICATION_ID = nid
2034: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 2531: WF_NOTIFICATION_ATTRIBUTES WNA,

2527: is
2528: cursor headers(nid in Number) is
2529: select WMA.NAME
2530: from WF_MESSAGE_ATTRIBUTES_VL WMA,
2531: WF_NOTIFICATION_ATTRIBUTES WNA,
2532: WF_NOTIFICATIONS WN
2533: where WNA.NOTIFICATION_ID = nid
2534: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
2535: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 4265: from WF_NOTIFICATION_ATTRIBUTES WNA,

4261: is
4262: -- SQL Statement for fetching URL RESPONSE attributes.
4263: cursor c1 is
4264: select WMA.NAME, WMA.DISPLAY_NAME, WNA.TEXT_VALUE, WMA.DESCRIPTION
4265: from WF_NOTIFICATION_ATTRIBUTES WNA,
4266: WF_NOTIFICATIONS WN,
4267: WF_MESSAGE_ATTRIBUTES_VL WMA
4268: where WNA.NOTIFICATION_ID = nid
4269: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 4350: from WF_NOTIFICATION_ATTRIBUTES WNA,

4346: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
4347: 'LOOKUP', WNA.TEXT_VALUE,
4348: WNA.TEXT_VALUE), WMA.DESCRIPTION
4349: into disp_name, attr_type, attr_format, attr_value, attr_desc
4350: from WF_NOTIFICATION_ATTRIBUTES WNA,
4351: WF_NOTIFICATIONS WN,
4352: WF_MESSAGE_ATTRIBUTES_VL WMA
4353: where WNA.NOTIFICATION_ID = nid
4354: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 6654: from WF_NOTIFICATION_ATTRIBUTES WNA,

6650: '', to_char(WNA.DATE_VALUE),
6651: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
6652: 'LOOKUP', WNA.TEXT_VALUE,
6653: WNA.TEXT_VALUE) VALUE
6654: from WF_NOTIFICATION_ATTRIBUTES WNA,
6655: WF_NOTIFICATIONS WN,
6656: WF_MESSAGE_ATTRIBUTES_VL WMA
6657: where WNA.NOTIFICATION_ID = nid
6658: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 6976: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

6972: select WMA.TYPE, WMA.DISPLAY_NAME,
6973: decode(WMA.TYPE, 'URL', WF_NOTIFICATION.GetUrlText(WNA.TEXT_VALUE,
6974: GetURLAttachment.nid), WNA.TEXT_VALUE) URL,
6975: WNA.NAME
6976: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
6977: WF_MESSAGE_ATTRIBUTES_VL WMA
6978: where WNA.NOTIFICATION_ID = GetURLAttachment.nid
6979: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
6980: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE