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_SPM_WF_PKG1 dependencies on FND_USER

Line 229: FROM per_people_f ppf, fnd_user fu

225: x_last_name OUT nocopy VARCHAR2)
226: IS
227: CURSOR l_per_cur IS
228: SELECT ppf.first_name, ppf.last_name
229: FROM per_people_f ppf, fnd_user fu
230: WHERE fu.employee_id = ppf.person_id
231: AND fu.user_id = p_user_id;
232: CURSOR l_tca_cur IS
233: SELECT hp.person_first_name, hp.person_last_name

Line 234: FROM hz_parties hp, fnd_user fu

230: WHERE fu.employee_id = ppf.person_id
231: AND fu.user_id = p_user_id;
232: CURSOR l_tca_cur IS
233: SELECT hp.person_first_name, hp.person_last_name
234: FROM hz_parties hp, fnd_user fu
235: WHERE fu.person_party_id = hp.party_id
236: AND fu.user_id = p_user_id;
237: CURSOR l_fnd_cur IS
238: SELECT user_name FROM fnd_user WHERE user_id = p_user_id;

Line 238: SELECT user_name FROM fnd_user WHERE user_id = p_user_id;

234: FROM hz_parties hp, fnd_user fu
235: WHERE fu.person_party_id = hp.party_id
236: AND fu.user_id = p_user_id;
237: CURSOR l_fnd_cur IS
238: SELECT user_name FROM fnd_user WHERE user_id = p_user_id;
239: l_found BOOLEAN;
240: BEGIN
241: l_found := FALSE;
242: -- query the user's employee name.

Line 286: FROM fnd_user

282: x_company_name OUT nocopy VARCHAR2)
283: IS
284: CURSOR l_per_cur IS
285: SELECT employee_id
286: FROM fnd_user
287: WHERE user_name = p_username;
288: l_employee_id NUMBER;
289: l_vendor_id NUMBER;
290: BEGIN

Line 363: FROM fnd_user fu, pos_spmntf_subscription sub

359: l_sql VARCHAR2(1000);
360: BEGIN
361: OPEN x_cur FOR
362: SELECT user_name
363: FROM fnd_user fu, pos_spmntf_subscription sub
364: WHERE fu.user_id = sub.user_id
365: AND sub.event_type = p_event_type;
366: RETURN;
367: END get_buyers;

Line 1178: FROM hz_relationships hzr, hz_parties hp, fnd_user fu

1174: IS
1175: l_supplier_party_id NUMBER;
1176: CURSOR l_user_name_cur (p_supplier_party_id IN NUMBER) IS
1177: SELECT fu.user_name
1178: FROM hz_relationships hzr, hz_parties hp, fnd_user fu
1179: WHERE
1180: fu.person_party_id = hp.party_id
1181: AND fu.email_address IS NOT NULL
1182: AND fu.end_date IS NULL

Line 1220: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua

1216: l_adhoc_user wf_roles.name%TYPE;
1217:
1218: CURSOR l_user_name_cur IS
1219: SELECT fu.user_name
1220: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua
1221: WHERE fu.person_party_id = hp.party_id
1222: AND fu.email_address IS NOT NULL
1223: AND fu.end_date IS NULL
1224: AND ap.vendor_id = p_vendor_id

Line 1253: l_user_name fnd_user.user_name%TYPE;

1249: AND pvsa.country = ft.territory_code (+);
1250:
1251: l_rec l_cur%ROWTYPE;
1252: l_count NUMBER;
1253: l_user_name fnd_user.user_name%TYPE;
1254:
1255: CURSOR l_contact_cur IS
1256: select hp.person_first_name, hp.person_last_name, hzr_hp.email_address
1257: from hz_parties hp, hz_relationships hzr, hz_parties hzr_hp, hz_party_usg_assignments hpua, ap_suppliers apsupp

Line 1575: FROM fnd_user fu

1571: l_user_id NUMBER;
1572:
1573: CURSOR l_email_cur IS
1574: SELECT fu.email_address
1575: FROM fnd_user fu
1576: WHERE fu.user_id = l_user_id;
1577:
1578: CURSOR l_name_cur IS
1579: SELECT ppf.first_name, ppf.last_name

Line 1580: FROM fnd_user fu, per_people_f ppf

1576: WHERE fu.user_id = l_user_id;
1577:
1578: CURSOR l_name_cur IS
1579: SELECT ppf.first_name, ppf.last_name
1580: FROM fnd_user fu, per_people_f ppf
1581: WHERE fu.user_id = l_user_id AND
1582: ppf.person_id = fu.employee_id;
1583:
1584: l_email_rec l_email_cur%ROWTYPE;

Line 1994: from fnd_user fu,

1990: l_function_id NUMBER;
1991:
1992: CURSOR l_receiver_cur IS
1993: select DISTINCT fu.user_name
1994: from fnd_user fu,
1995: fnd_responsibility fr,
1996: fnd_user_resp_groups_direct furg,
1997: hz_relationships hr1, ap_suppliers ap_sup, hz_party_usg_assignments hpua
1998: where fr.menu_id IN

Line 1996: fnd_user_resp_groups_direct furg,

1992: CURSOR l_receiver_cur IS
1993: select DISTINCT fu.user_name
1994: from fnd_user fu,
1995: fnd_responsibility fr,
1996: fnd_user_resp_groups_direct furg,
1997: hz_relationships hr1, ap_suppliers ap_sup, hz_party_usg_assignments hpua
1998: where fr.menu_id IN
1999: (SELECT fme.menu_id
2000: FROM fnd_menu_entries fme

Line 2125: fnd_user_resp_groups_direct furg,

2121: --
2122: OPEN x_refcur FOR
2123: select DISTINCT psuv.user_name
2124: from fnd_responsibility fr,
2125: fnd_user_resp_groups_direct furg,
2126: pos_supplier_users_v psuv
2127: where fr.menu_id IN
2128: (SELECT fme.menu_id
2129: FROM fnd_menu_entries fme

Line 3181: SELECT USER_NAME INTO L_FROM_NAME FROM FND_USER WHERE USER_ID=FND_GLOBAL.USER_ID;

3177: -- Assigning ADHOC User to ADHOC Role
3178: ADDUSERTOADHOCROLE(l_receiver,L_ADHOC_USER);
3179:
3180: -- GET THE CURRENT USER NAME
3181: SELECT USER_NAME INTO L_FROM_NAME FROM FND_USER WHERE USER_ID=FND_GLOBAL.USER_ID;
3182:
3183: -- GENERATING THE PROCESS KEY
3184: GET_WF_ITEM_KEY (l_process,To_char(p_supplier_reg_id),L_ITEMKEY);
3185:

Line 3541: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua

3537: );
3538:
3539: CURSOR l_supplier_users_cur IS
3540: SELECT fu.user_name, fu.email_address
3541: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua
3542: WHERE
3543: fu.user_id in (select spm.user_id from pos_spmntf_subscription spm
3544: where spm.event_type = 'SUPP_BUS_CLASS_RECERT_NTF')
3545: AND fu.person_party_id = hp.party_id