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 1309: from WF_NOTIFICATION_ATTRIBUTES WNA,

1305: --'DATE', wf_notification_util.GetCalendarDate(p_nid=>nid, p_date=>WNA.DATE_VALUE, p_date_format=>WMA.FORMAT),
1306: 'LOOKUP', WNA.TEXT_VALUE,
1307: WNA.TEXT_VALUE) VALUE,
1308: WNA.DATE_VALUE -- value is Date type <
1309: from WF_NOTIFICATION_ATTRIBUTES WNA,
1310: WF_NOTIFICATIONS WN,
1311: WF_MESSAGE_ATTRIBUTES_VL WMA
1312: where WNA.NOTIFICATION_ID = nid
1313: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 1386: from WF_NOTIFICATION_ATTRIBUTES WNA,

1382: -- 'DATE', wf_notification_util.GetCalendarDate(nid, WNA.DATE_VALUE, WMA.FORMAT, true),
1383: 'LOOKUP', WNA.TEXT_VALUE,
1384: WNA.TEXT_VALUE) VALUE,
1385: WNA.DATE_VALUE
1386: from WF_NOTIFICATION_ATTRIBUTES WNA,
1387: WF_NOTIFICATIONS WN,
1388: WF_MESSAGE_ATTRIBUTES_VL WMA
1389: where WNA.NOTIFICATION_ID = nid
1390: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 1902: from WF_NOTIFICATION_ATTRIBUTES WNA,

1898: '', to_char(WNA.DATE_VALUE),
1899: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
1900: 'LOOKUP', WNA.TEXT_VALUE,
1901: WNA.TEXT_VALUE) VALUE
1902: from WF_NOTIFICATION_ATTRIBUTES WNA,
1903: WF_NOTIFICATIONS WN,
1904: WF_MESSAGE_ATTRIBUTES_VL WMA
1905: where WNA.NOTIFICATION_ID = nid
1906: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 1990: from WF_NOTIFICATION_ATTRIBUTES WNA,

1986: --
1987: 'LOOKUP', WNA.TEXT_VALUE,
1988: WNA.TEXT_VALUE) VALUE,
1989: WNA.DATE_VALUE -- << sstomar: bug8430385 >>
1990: from WF_NOTIFICATION_ATTRIBUTES WNA,
1991: WF_NOTIFICATIONS WN,
1992: WF_MESSAGE_ATTRIBUTES_VL WMA
1993: where WNA.NOTIFICATION_ID = nid
1994: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 2108: from WF_NOTIFICATION_ATTRIBUTES WNA,

2104: is
2105: -- SQL Statement for fetching URL RESPONSE attributes.
2106: cursor c1 is
2107: select WMA.NAME, WMA.DISPLAY_NAME, WNA.TEXT_VALUE, WMA.DESCRIPTION
2108: from WF_NOTIFICATION_ATTRIBUTES WNA,
2109: WF_NOTIFICATIONS WN,
2110: WF_MESSAGE_ATTRIBUTES_VL WMA
2111: where WNA.NOTIFICATION_ID = nid
2112: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 2180: from WF_NOTIFICATION_ATTRIBUTES WNA,

2176: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
2177: 'LOOKUP', WNA.TEXT_VALUE,
2178: WNA.TEXT_VALUE), WMA.DESCRIPTION
2179: into disp_name, attr_type, attr_format, attr_value, attr_desc
2180: from WF_NOTIFICATION_ATTRIBUTES WNA,
2181: WF_NOTIFICATIONS WN,
2182: WF_MESSAGE_ATTRIBUTES_VL WMA
2183: where WNA.NOTIFICATION_ID = nid
2184: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 2685: WF_NOTIFICATION_ATTRIBUTES WNA,

2681: is
2682: cursor headers(nid in Number) is
2683: select WMA.NAME
2684: from WF_MESSAGE_ATTRIBUTES_VL WMA,
2685: WF_NOTIFICATION_ATTRIBUTES WNA,
2686: WF_NOTIFICATIONS WN
2687: where WNA.NOTIFICATION_ID = nid
2688: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
2689: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE

Line 4421: from WF_NOTIFICATION_ATTRIBUTES WNA,

4417: is
4418: -- SQL Statement for fetching URL RESPONSE attributes.
4419: cursor c1 is
4420: select WMA.NAME, WMA.DISPLAY_NAME, WNA.TEXT_VALUE, WMA.DESCRIPTION
4421: from WF_NOTIFICATION_ATTRIBUTES WNA,
4422: WF_NOTIFICATIONS WN,
4423: WF_MESSAGE_ATTRIBUTES_VL WMA
4424: where WNA.NOTIFICATION_ID = nid
4425: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 4512: from WF_NOTIFICATION_ATTRIBUTES WNA,

4508: -- 'LOOKUP', WNA.TEXT_VALUE,
4509: -- WNA.TEXT_VALUE),
4510: WMA.DESCRIPTION
4511: into disp_name, attr_type, attr_format, attr_desc
4512: from WF_NOTIFICATION_ATTRIBUTES WNA,
4513: WF_NOTIFICATIONS WN,
4514: WF_MESSAGE_ATTRIBUTES_VL WMA
4515: where WNA.NOTIFICATION_ID = nid
4516: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 6908: from WF_NOTIFICATION_ATTRIBUTES WNA,

6904: '', to_char(WNA.DATE_VALUE),
6905: to_char(WNA.DATE_VALUE, WMA.FORMAT)),
6906: 'LOOKUP', WNA.TEXT_VALUE,
6907: WNA.TEXT_VALUE) VALUE
6908: from WF_NOTIFICATION_ATTRIBUTES WNA,
6909: WF_NOTIFICATIONS WN,
6910: WF_MESSAGE_ATTRIBUTES_VL WMA
6911: where WNA.NOTIFICATION_ID = nid
6912: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID

Line 7230: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,

7226: select WMA.TYPE, WMA.DISPLAY_NAME,
7227: decode(WMA.TYPE, 'URL', WF_NOTIFICATION.GetUrlText(WNA.TEXT_VALUE,
7228: GetURLAttachment.nid), WNA.TEXT_VALUE) URL,
7229: WNA.NAME
7230: from WF_NOTIFICATION_ATTRIBUTES WNA, WF_NOTIFICATIONS WN,
7231: WF_MESSAGE_ATTRIBUTES_VL WMA
7232: where WNA.NOTIFICATION_ID = GetURLAttachment.nid
7233: and WN.NOTIFICATION_ID = WNA.NOTIFICATION_ID
7234: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE