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_NOTIFICATION dependencies on FND_LOOKUP_VALUES

Line 10177: l_lookupType FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE := 'WF_NTF_RESP_DEFER_ITEM_TYPES';

10173: l_agent wf_agent_t := null ;
10174:
10175: l_itemType WF_NOTIFICATIONS.MESSAGE_TYPE%TYPE := null;
10176: l_lookupCode_cnt number := 0;
10177: l_lookupType FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE := 'WF_NTF_RESP_DEFER_ITEM_TYPES';
10178: l_ntf_status WF_NOTIFICATIONS.STATUS%TYPE;
10179:
10180: l_dummy_var varchar2(400);
10181: response_found boolean;

Line 10200: from fnd_lookup_values

10196: -- WF_NTF_RESP_DEFER_ITEM_TYPES Lookup Type for 'SPECIFIC' case
10197: if(defer_response = 'SPECIFIC') then
10198: select count(1)
10199: into l_lookupCode_cnt
10200: from fnd_lookup_values
10201: where lookup_type = l_lookupType
10202: and lookup_code = l_itemType
10203: and security_group_id = 0
10204: and view_application_id = 0 ; -- for FND product view application id is 0