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.WSH_VENDOR_PARTY_MERGE_PKG dependencies on HZ_PARTIES

Line 372: hz_parties contact_person,

368: SELECT contact_person.party_name shipper_name,
369: phone_record.phone_number phone_number,
370: email_record.email_address email_address
371: FROM hz_party_sites hps,
372: hz_parties contact_person,
373: hz_org_contacts supplier_contact,
374: hz_contact_points phone_record,
375: hz_contact_points email_record,
376: hz_relationships hrel

Line 378: AND hrel.subject_table_name = 'HZ_PARTIES'

374: hz_contact_points phone_record,
375: hz_contact_points email_record,
376: hz_relationships hrel
377: WHERE hrel.subject_id = contact_person.party_id
378: AND hrel.subject_table_name = 'HZ_PARTIES'
379: AND hrel.subject_type = 'PERSON'
380: AND hrel.object_id = hps.party_id
381: AND hrel.object_table_name = 'HZ_PARTIES'
382: AND hrel.object_type = 'ORGANIZATION'

Line 381: AND hrel.object_table_name = 'HZ_PARTIES'

377: WHERE hrel.subject_id = contact_person.party_id
378: AND hrel.subject_table_name = 'HZ_PARTIES'
379: AND hrel.subject_type = 'PERSON'
380: AND hrel.object_id = hps.party_id
381: AND hrel.object_table_name = 'HZ_PARTIES'
382: AND hrel.object_type = 'ORGANIZATION'
383: AND hrel.relationship_code = 'CONTACT_OF'
384: AND hrel.directional_flag = 'F'
385: AND supplier_contact.party_relationship_id =hrel.relationship_id

Line 387: AND phone_record.owner_table_name(+) = 'HZ_PARTIES'

383: AND hrel.relationship_code = 'CONTACT_OF'
384: AND hrel.directional_flag = 'F'
385: AND supplier_contact.party_relationship_id =hrel.relationship_id
386: AND supplier_contact.party_site_id = hps.party_site_id
387: AND phone_record.owner_table_name(+) = 'HZ_PARTIES'
388: AND phone_record.owner_table_id(+) = hrel.party_id
389: AND phone_record.contact_point_type(+) = 'PHONE'
390: AND email_record.owner_table_name = 'HZ_PARTIES'
391: AND email_record.owner_table_id = hrel.party_id

Line 390: AND email_record.owner_table_name = 'HZ_PARTIES'

386: AND supplier_contact.party_site_id = hps.party_site_id
387: AND phone_record.owner_table_name(+) = 'HZ_PARTIES'
388: AND phone_record.owner_table_id(+) = hrel.party_id
389: AND phone_record.contact_point_type(+) = 'PHONE'
390: AND email_record.owner_table_name = 'HZ_PARTIES'
391: AND email_record.owner_table_id = hrel.party_id
392: AND email_record.contact_point_type = 'EMAIL'
393: AND hps.party_site_id =p_party_site_id
394: AND hps.party_id = p_party_id;