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_ATTR_VALIDATION_PUB dependencies on HZ_RELATIONSHIPS

Line 45: from hz_relationships pr,

41:
42:
43: cursor lc_get_pt_details (pc_partner_id number) is
44: select pt.party_name party_name
45: from hz_relationships pr,
46: hz_organization_profiles op,
47: hz_parties pt
48: where pr.party_id = pc_partner_id
49: and pr.subject_table_name = 'HZ_PARTIES'

Line 70: from hz_relationships b,

66:
67: cursor lc_get_pt_contact (pc_pt_contact_id NUMBER)
68: is
69: select d.party_name
70: from hz_relationships b,
71: hz_relationships c,
72: hz_organization_profiles po,
73: hz_parties d
74: where b.party_id = pc_pt_contact_id

Line 71: hz_relationships c,

67: cursor lc_get_pt_contact (pc_pt_contact_id NUMBER)
68: is
69: select d.party_name
70: from hz_relationships b,
71: hz_relationships c,
72: hz_organization_profiles po,
73: hz_parties d
74: where b.party_id = pc_pt_contact_id
75: and b.subject_table_name = 'HZ_PARTIES'