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.POS_SUPPLIER_NOTIFY_PKG dependencies on FND_USER

Line 92: l_user_name fnd_user.user_name%TYPE;

88:
89: l_first_name hz_parties.person_first_name%TYPE;
90: l_last_name hz_parties.person_last_name%TYPE;
91: l_email_address hz_contact_points.email_address%TYPE;
92: l_user_name fnd_user.user_name%TYPE;
93: l_user_email_address fnd_user.email_address%TYPE;
94:
95: l_contact_users_tbl wf_directory.UserTable;
96: l_contact_emails_tbl wf_directory.UserTable;

Line 93: l_user_email_address fnd_user.email_address%TYPE;

89: l_first_name hz_parties.person_first_name%TYPE;
90: l_last_name hz_parties.person_last_name%TYPE;
91: l_email_address hz_contact_points.email_address%TYPE;
92: l_user_name fnd_user.user_name%TYPE;
93: l_user_email_address fnd_user.email_address%TYPE;
94:
95: l_contact_users_tbl wf_directory.UserTable;
96: l_contact_emails_tbl wf_directory.UserTable;
97:

Line 125: ' fnd_user fu, ' ||

121: 'FROM hz_parties hp, ' ||
122: ' hz_relationships hzr, ' ||
123: ' hz_party_usg_assignments hpua, ' ||
124: ' hz_contact_points hcpe, ' ||
125: ' fnd_user fu, ' ||
126: ' ap_suppliers aps ' ||
127: 'WHERE hp.party_id = hzr.subject_id ' ||
128: ' AND hzr.object_id = aps.party_id ' ||
129: ' AND hzr.relationship_type = ''CONTACT'' ' ||