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.FND_PII_UTILITY_PVT dependencies on HZ_CONTACT_PREFERENCES

Line 41: FROM HZ_CONTACT_PREFERENCES pref

37: l_party_id in varchar2)
38: is
39: select contact_preference_id,
40: preference_code
41: FROM HZ_CONTACT_PREFERENCES pref
42: WHERE pref.CONTACT_LEVEL_TABLE_ID = l_party_id
43: AND pref.CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
44: AND pref.preference_topic_type_code = l_purpose_code -- this will be l_purpose_code
45: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B' -- this will be FND_BUSINESS_PURPOSES

Line 179: FROM HZ_CONTACT_PREFERENCES pref

175: l_party_id in number)
176: is
177: select pref.contact_preference_id,
178: pref.preference_code
179: FROM HZ_CONTACT_PREFERENCES pref
180: WHERE pref.CONTACT_LEVEL_TABLE_ID = l_party_id
181: AND pref.CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
182: AND pref.preference_topic_type_code = l_purpose_code -- this will be l_purpose_code
183: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B' -- this will be FND_BUSINESS_PURPOSES

Line 297: FROM HZ_CONTACT_PREFERENCES pref

293: l_party_id in varchar2)
294: is
295: select contact_preference_id,
296: preference_code
297: FROM HZ_CONTACT_PREFERENCES pref
298: WHERE pref.CONTACT_LEVEL_TABLE_ID = l_party_id
299: AND pref.CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
300: AND pref.preference_topic_type_code = l_purpose_code -- this will be l_purpose_code
301: AND pref.preference_topic_type = 'FND_BUSINESS_PURPOSES_B' -- this will be FND_BUSINESS_PURPOSES