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 177: FROM per_people_f ppf, fnd_user fu

173: x_last_name OUT nocopy VARCHAR2)
174: IS
175: CURSOR l_per_cur IS
176: SELECT ppf.first_name, ppf.last_name
177: FROM per_people_f ppf, fnd_user fu
178: WHERE fu.employee_id = ppf.person_id
179: AND fu.user_id = p_user_id;
180: CURSOR l_tca_cur IS
181: SELECT hp.person_first_name, hp.person_last_name

Line 182: FROM hz_parties hp, fnd_user fu

178: WHERE fu.employee_id = ppf.person_id
179: AND fu.user_id = p_user_id;
180: CURSOR l_tca_cur IS
181: SELECT hp.person_first_name, hp.person_last_name
182: FROM hz_parties hp, fnd_user fu
183: WHERE fu.person_party_id = hp.party_id
184: AND fu.user_id = p_user_id;
185: CURSOR l_fnd_cur IS
186: SELECT user_name FROM fnd_user WHERE user_id = p_user_id;

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

182: FROM hz_parties hp, fnd_user fu
183: WHERE fu.person_party_id = hp.party_id
184: AND fu.user_id = p_user_id;
185: CURSOR l_fnd_cur IS
186: SELECT user_name FROM fnd_user WHERE user_id = p_user_id;
187: l_found BOOLEAN;
188: BEGIN
189: l_found := FALSE;
190: -- query the user's employee name.

Line 234: FROM fnd_user

230: x_company_name OUT nocopy VARCHAR2)
231: IS
232: CURSOR l_per_cur IS
233: SELECT employee_id
234: FROM fnd_user
235: WHERE user_name = p_username;
236: l_employee_id NUMBER;
237: l_vendor_id NUMBER;
238: BEGIN

Line 311: FROM fnd_user fu, pos_spmntf_subscription sub

307: l_sql VARCHAR2(1000);
308: BEGIN
309: OPEN x_cur FOR
310: SELECT user_name
311: FROM fnd_user fu, pos_spmntf_subscription sub
312: WHERE fu.user_id = sub.user_id
313: AND sub.event_type = p_event_type;
314: RETURN;
315: END get_buyers;

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

1122: IS
1123: l_supplier_party_id NUMBER;
1124: CURSOR l_user_name_cur (p_supplier_party_id IN NUMBER) IS
1125: SELECT fu.user_name
1126: FROM hz_relationships hzr, hz_parties hp, fnd_user fu
1127: WHERE
1128: fu.person_party_id = hp.party_id
1129: AND fu.email_address IS NOT NULL
1130: AND fu.end_date IS NULL

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

1164: l_adhoc_user wf_roles.name%TYPE;
1165:
1166: CURSOR l_user_name_cur IS
1167: SELECT fu.user_name
1168: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua
1169: WHERE fu.person_party_id = hp.party_id
1170: AND fu.email_address IS NOT NULL
1171: AND fu.end_date IS NULL
1172: AND ap.vendor_id = p_vendor_id

Line 1201: l_user_name fnd_user.user_name%TYPE;

1197: AND pvsa.country = ft.territory_code (+);
1198:
1199: l_rec l_cur%ROWTYPE;
1200: l_count NUMBER;
1201: l_user_name fnd_user.user_name%TYPE;
1202:
1203: CURSOR l_contact_cur IS
1204: select hp.person_first_name, hp.person_last_name, hzr_hp.email_address
1205: from hz_parties hp, hz_relationships hzr, hz_parties hzr_hp, hz_party_usg_assignments hpua, ap_suppliers apsupp

Line 1523: FROM fnd_user fu

1519: l_user_id NUMBER;
1520:
1521: CURSOR l_email_cur IS
1522: SELECT fu.email_address
1523: FROM fnd_user fu
1524: WHERE fu.user_id = l_user_id;
1525:
1526: CURSOR l_name_cur IS
1527: SELECT ppf.first_name, ppf.last_name

Line 1528: FROM fnd_user fu, per_people_f ppf

1524: WHERE fu.user_id = l_user_id;
1525:
1526: CURSOR l_name_cur IS
1527: SELECT ppf.first_name, ppf.last_name
1528: FROM fnd_user fu, per_people_f ppf
1529: WHERE fu.user_id = l_user_id AND
1530: ppf.person_id = fu.employee_id;
1531:
1532: l_email_rec l_email_cur%ROWTYPE;

Line 1926: from fnd_user fu,

1922: l_function_id NUMBER;
1923:
1924: CURSOR l_receiver_cur IS
1925: select DISTINCT fu.user_name
1926: from fnd_user fu,
1927: fnd_responsibility fr,
1928: fnd_user_resp_groups_direct furg,
1929: hz_relationships hr1, ap_suppliers ap_sup, hz_party_usg_assignments hpua
1930: where fr.menu_id IN

Line 1928: fnd_user_resp_groups_direct furg,

1924: CURSOR l_receiver_cur IS
1925: select DISTINCT fu.user_name
1926: from fnd_user fu,
1927: fnd_responsibility fr,
1928: fnd_user_resp_groups_direct furg,
1929: hz_relationships hr1, ap_suppliers ap_sup, hz_party_usg_assignments hpua
1930: where fr.menu_id IN
1931: (SELECT fme.menu_id
1932: FROM fnd_menu_entries fme

Line 2057: fnd_user_resp_groups_direct furg,

2053: --
2054: OPEN x_refcur FOR
2055: select DISTINCT psuv.user_name
2056: from fnd_responsibility fr,
2057: fnd_user_resp_groups_direct furg,
2058: pos_supplier_users_v psuv
2059: where fr.menu_id IN
2060: (SELECT fme.menu_id
2061: FROM fnd_menu_entries fme

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

3330: OR APS.BUS_CLASS_LAST_CERTIFIED_DATE IS NULL;
3331:
3332: CURSOR l_supplier_users_cur IS
3333: SELECT fu.user_name, fu.email_address
3334: FROM hz_relationships hzr, hz_parties hp, fnd_user fu, ap_suppliers ap, hz_party_usg_assignments hpua
3335: WHERE
3336: fu.user_id in (select spm.user_id from pos_spmntf_subscription spm
3337: where spm.event_type = 'SUPP_BUS_CLASS_RECERT_NTF')
3338: AND fu.person_party_id = hp.party_id