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_MESSAGE_ATTRIBUTES_VL

Line 1311: WF_MESSAGE_ATTRIBUTES_VL WMA

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
1314: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
1315: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 1388: WF_MESSAGE_ATTRIBUTES_VL WMA

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
1391: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
1392: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 1904: WF_MESSAGE_ATTRIBUTES_VL WMA

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
1907: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
1908: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 1992: WF_MESSAGE_ATTRIBUTES_VL WMA

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
1995: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
1996: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 2110: WF_MESSAGE_ATTRIBUTES_VL WMA

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
2113: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
2114: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 2182: WF_MESSAGE_ATTRIBUTES_VL WMA

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
2185: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
2186: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 2684: from WF_MESSAGE_ATTRIBUTES_VL WMA,

2680: document_type in out NOCOPY varchar2)
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

Line 4423: WF_MESSAGE_ATTRIBUTES_VL WMA

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
4426: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
4427: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 4514: WF_MESSAGE_ATTRIBUTES_VL WMA

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
4517: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
4518: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 6679: from WF_MESSAGE_ATTRIBUTES_VL

6675: -- Order-by is to insure longest prompts are processed first to prevent
6676: -- problems where one prompt is a substring of another prompt.
6677: cursor c1 is
6678: select NAME, DISPLAY_NAME, TYPE, FORMAT
6679: from WF_MESSAGE_ATTRIBUTES_VL
6680: where MESSAGE_NAME = msg_name
6681: and MESSAGE_TYPE = msg_type
6682: and SUBTYPE = 'RESPOND'
6683: and TYPE not in ('FORM', 'URL')

Line 6910: WF_MESSAGE_ATTRIBUTES_VL WMA

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
6913: and WN.MESSAGE_TYPE = WMA.MESSAGE_TYPE
6914: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME

Line 7231: WF_MESSAGE_ATTRIBUTES_VL WMA

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
7235: and WN.MESSAGE_NAME = WMA.MESSAGE_NAME