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

Line 391: from AS_SALES_LEADS LEAD, HZ_PARTIES PARTNER, HZ_RELATIONSHIPS REL,HZ_ORGANIZATION_PROFILES ORG

387:
388:
389: CURSOR lc_ptnr_org_name(pc_party_id NUMBER) IS
390: SELECT ORG.PARTY_ID, partner.party_name
391: from AS_SALES_LEADS LEAD, HZ_PARTIES PARTNER, HZ_RELATIONSHIPS REL,HZ_ORGANIZATION_PROFILES ORG
392: where LEAD.REFERRED_BY=REL.PARTY_ID and REL.SUBJECT_ID=PARTNER.PARTY_ID
393: and REL.OBJECT_ID=ORG.PARTY_ID
394: and ORG.internal_flag = 'Y'
395: and ORG.effective_end_date is null

Line 413: hz_relationships PCONTACT, hz_relationships PORG,

409:
410: cursor c_get_ptnr_full_name (c_user_id number) is
411: select ARLKP.meaning ||' '||puser.person_first_name||' ' || puser.person_last_name partner_contact_name
412: from jtf_rs_resource_extns JS,
413: hz_relationships PCONTACT, hz_relationships PORG,
414: hz_parties PUSER, hz_parties PARTNER, hz_parties VENDOR,
415: hz_organization_profiles HZOP, pv_partner_profiles PVPP,
416: hz_org_contacts HZOC, ar_lookups ARLKP
417: where JS.user_id = c_user_id