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 942: from hz_parties hz_org, hz_relationships hzr, fnd_user fnd

938: where name = x_role_name;
939:
940: cursor getUniversalApprovers is
941: select fnd.user_name
942: from hz_parties hz_org, hz_relationships hzr, fnd_user fnd
943: where hz_org.party_number = l_org_number
944: and hz_org.party_type = 'ORGANIZATION'
945: and hz_org.party_id = hzr.object_id
946: and hzr.start_date <= sysdate

Line 1281: from hz_relationships hzr,

1277:
1278: -- select the requesters org party id
1279: cursor requesterOrgCursor is
1280: select hzr.object_id requester_org_id
1281: from hz_relationships hzr,
1282: FND_USER fu
1283: where fu.USER_ID = l_requesterUserID
1284: and fu.CUSTOMER_ID = hzr.PARTY_ID
1285: and hzr.start_date <= sysdate

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

2716: where subscription_reg_id = to_number (itemkey);
2717:
2718: -- For bug fix 3894853
2719: cursor getOrgDetail is
2720: SELECT party.status FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
2721: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
2722: AND PREL.PARTY_ID = (select fnd.customer_id
2723: from jtf_um_usertype_reg reg , fnd_user fnd
2724: where usertype_reg_id = to_number(itemkey)

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

3245: p_org_party_id in number) is
3246:
3247: cursor usertype_reg is
3248: select utreg.usertype_reg_id, utreg.user_id
3249: from jtf_um_usertype_reg utreg, fnd_user fu, hz_relationships hzr
3250: where utreg.usertype_id = p_usertype_id
3251: and utreg.status_code = 'PENDING'
3252: and nvl (utreg.effective_end_date, sysdate + 1) > sysdate
3253: and utreg.user_id = fu.user_id

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

3374: or effective_end_date > sysdate);
3375:
3376: cursor subscription_reg_w_org is
3377: select subreg.subscription_reg_id, fu.user_id, subreg.wf_item_type
3378: from jtf_um_subscription_reg subreg, fnd_user fu, hz_relationships hzr
3379: where subreg.subscription_id = p_subscription_id
3380: and subreg.status_code = 'PENDING'
3381: and nvl (subreg.effective_end_date, sysdate + 1) > sysdate
3382: and subreg.user_id = fu.user_id