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 365: hz_parties contact_person,

361: SELECT contact_person.party_name shipper_name,
362: phone_record.phone_number phone_number,
363: email_record.email_address email_address
364: FROM hz_party_sites hps,
365: hz_parties contact_person,
366: hz_org_contacts supplier_contact,
367: hz_contact_points phone_record,
368: hz_contact_points email_record,
369: hz_relationships hrel

Line 371: AND hrel.subject_table_name = 'HZ_PARTIES'

367: hz_contact_points phone_record,
368: hz_contact_points email_record,
369: hz_relationships hrel
370: WHERE hrel.subject_id = contact_person.party_id
371: AND hrel.subject_table_name = 'HZ_PARTIES'
372: AND hrel.subject_type = 'PERSON'
373: AND hrel.object_id = hps.party_id
374: AND hrel.object_table_name = 'HZ_PARTIES'
375: AND hrel.object_type = 'ORGANIZATION'

Line 374: AND hrel.object_table_name = 'HZ_PARTIES'

370: WHERE hrel.subject_id = contact_person.party_id
371: AND hrel.subject_table_name = 'HZ_PARTIES'
372: AND hrel.subject_type = 'PERSON'
373: AND hrel.object_id = hps.party_id
374: AND hrel.object_table_name = 'HZ_PARTIES'
375: AND hrel.object_type = 'ORGANIZATION'
376: AND hrel.relationship_code = 'CONTACT_OF'
377: AND hrel.directional_flag = 'F'
378: AND supplier_contact.party_relationship_id =hrel.relationship_id

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

376: AND hrel.relationship_code = 'CONTACT_OF'
377: AND hrel.directional_flag = 'F'
378: AND supplier_contact.party_relationship_id =hrel.relationship_id
379: AND supplier_contact.party_site_id = hps.party_site_id
380: AND phone_record.owner_table_name(+) = 'HZ_PARTIES'
381: AND phone_record.owner_table_id(+) = hrel.party_id
382: AND phone_record.contact_point_type(+) = 'PHONE'
383: AND email_record.owner_table_name = 'HZ_PARTIES'
384: AND email_record.owner_table_id = hrel.party_id

Line 383: AND email_record.owner_table_name = 'HZ_PARTIES'

379: AND supplier_contact.party_site_id = hps.party_site_id
380: AND phone_record.owner_table_name(+) = 'HZ_PARTIES'
381: AND phone_record.owner_table_id(+) = hrel.party_id
382: AND phone_record.contact_point_type(+) = 'PHONE'
383: AND email_record.owner_table_name = 'HZ_PARTIES'
384: AND email_record.owner_table_id = hrel.party_id
385: AND email_record.contact_point_type = 'EMAIL'
386: AND hps.party_site_id =p_party_site_id
387: AND hps.party_id = p_party_id;