DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_REFERRAL dependencies on PV_PARTNER_PROFILES

Line 415: hz_organization_profiles HZOP, pv_partner_profiles PVPP,

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