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 AR_LOOKUPS

Line 400: from ar_lookups

396: and LEAD.referred_by = pc_party_id;
397:
398: cursor c_get_meaning (c_lookup_type varchar2, c_lookup_code varchar2) is
399: select meaning
400: from ar_lookups
401: where lookup_type = c_lookup_type
402: and lookup_code = c_lookup_code;
403:
404:

Line 416: hz_org_contacts HZOC, ar_lookups ARLKP

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
418: AND JS.source_id = pcontact.party_id
419: AND PCONTACT.subject_table_name = 'HZ_PARTIES'
420: AND PCONTACT.object_table_name = 'HZ_PARTIES'