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.PV_SQL_UTILITY dependencies on AS_LEAD_CONTACTS_ALL

Line 574: as_lead_contacts_all aslc

570:
571: FOR x IN (SELECT PERSON_LAST_NAME || ' ' || PERSON_FIRST_NAME meaning
572: FROM hz_relationships a,
573: hz_parties b,
574: as_lead_contacts_all aslc
575: WHERE aslc.lead_id = p_lead_id AND
576: aslc.primary_contact_flag = 'Y' AND
577: a.party_id = aslc.contact_party_id AND
578: a.subject_type = 'PERSON' AND

Line 618: as_lead_contacts_all aslc

614:
615: FOR x IN (SELECT email_address meaning
616: FROM hz_relationships a,
617: hz_parties b,
618: as_lead_contacts_all aslc
619: WHERE aslc.lead_id = p_lead_id AND
620: aslc.primary_contact_flag = 'Y' AND
621: a.party_id = aslc.contact_party_id AND
622: a.subject_type = 'PERSON' AND

Line 662: as_lead_contacts_all aslc

658:
659: FOR x IN (SELECT PHONE_COUNTRY_CODE || PHONE_AREA_CODE || PHONE_NUMBER ||
660: PHONE_EXTENSION meaning
661: FROM hz_contact_points,
662: as_lead_contacts_all aslc
663: WHERE aslc.lead_id = p_lead_id AND
664: aslc.primary_contact_flag = 'Y' AND
665: owner_table_name = 'HZ_PARTIES' AND
666: owner_table_id = aslc.contact_party_id AND