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.JTF_UM_WF_APPROVAL dependencies on HZ_RELATIONSHIPS

Line 228: from fnd_user fnd, hz_parties hz, hz_relationships hzr

224: l_method_name varchar2 (12) := 'GET_ORG_INFO';
225:
226: cursor getOrgNameAndNumber is
227: select hz.party_name, hz.party_number
228: from fnd_user fnd, hz_parties hz, hz_relationships hzr
229: where fnd.user_id = p_user_id
230: and fnd.customer_id = hzr.party_id
231: and hzr.start_date <= sysdate
232: and nvl (hzr.end_date, sysdate + 1) > sysdate

Line 632: from hz_parties hz, hz_relationships hzr, fnd_user fnd

628:
629: --
630: cursor getCompanyNumber is
631: select hz.party_number
632: from hz_parties hz, hz_relationships hzr, fnd_user fnd
633: where fnd.user_id = requesterUserID
634: and fnd.customer_id = hzr.party_id
635: and hzr.start_date <= sysdate
636: and nvl (hzr.end_date, sysdate + 1) > sysdate

Line 935: from hz_parties hz_org, hz_relationships hzr, fnd_user fnd

931: where name = x_role_name;
932:
933: cursor getUniversalApprovers is
934: select fnd.user_name
935: from hz_parties hz_org, hz_relationships hzr, fnd_user fnd
936: where hz_org.party_number = l_org_number
937: and hz_org.party_type = 'ORGANIZATION'
938: and hz_org.party_id = hzr.object_id
939: and hzr.start_date <= sysdate

Line 1269: from hz_relationships hzr,

1265:
1266: -- select the requesters org party id
1267: cursor requesterOrgCursor is
1268: select hzr.object_id requester_org_id
1269: from hz_relationships hzr,
1270: FND_USER fu
1271: where fu.USER_ID = l_requesterUserID
1272: and fu.CUSTOMER_ID = hzr.PARTY_ID
1273: and hzr.start_date <= sysdate

Line 2694: SELECT party.status FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL

2690: where subscription_reg_id = to_number (itemkey);
2691:
2692: -- For bug fix 3894853
2693: cursor getOrgDetail is
2694: SELECT party.status FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
2695: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
2696: AND PREL.PARTY_ID = (select fnd.customer_id
2697: from jtf_um_usertype_reg reg , fnd_user fnd
2698: where usertype_reg_id = to_number(itemkey)

Line 3189: from jtf_um_usertype_reg utreg, fnd_user fu, hz_relationships hzr

3185: p_org_party_id in number) is
3186:
3187: cursor usertype_reg is
3188: select utreg.usertype_reg_id, utreg.user_id
3189: from jtf_um_usertype_reg utreg, fnd_user fu, hz_relationships hzr
3190: where utreg.usertype_id = p_usertype_id
3191: and utreg.status_code = 'PENDING'
3192: and nvl (utreg.effective_end_date, sysdate + 1) > sysdate
3193: and utreg.user_id = fu.user_id

Line 3318: from jtf_um_subscription_reg subreg, fnd_user fu, hz_relationships hzr

3314: or effective_end_date > sysdate);
3315:
3316: cursor subscription_reg_w_org is
3317: select subreg.subscription_reg_id, fu.user_id, subreg.wf_item_type
3318: from jtf_um_subscription_reg subreg, fnd_user fu, hz_relationships hzr
3319: where subreg.subscription_id = p_subscription_id
3320: and subreg.status_code = 'PENDING'
3321: and nvl (subreg.effective_end_date, sysdate + 1) > sysdate
3322: and subreg.user_id = fu.user_id