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.CSZ_SERVICEREQUEST_UTIL_PVT dependencies on HZ_RELATIONSHIPS

Line 127: from hz_parties hz, hz_relationships rel

123: where hz.party_id = p_party_id;
124: elsif p_contact_type = 'PARTY_RELATIONSHIP' then
125: select hz.party_name
126: into l_contact_name
127: from hz_parties hz, hz_relationships rel
128: where rel.party_id = p_contact_party_id
129: and rel.object_id = p_party_id
130: and rel.subject_id = hz.party_id
131: and rel.subject_type = 'PERSON';

Line 587: hz_relationships

583: cursor c_party_relation(l_object_id in number, l_subject_id in number) is
584: select
585: party_id
586: from
587: hz_relationships
588: where
589: object_id = l_object_id
590: and subject_id = l_subject_id;
591: --

Line 1231: from hz_parties hz, hz_relationships rel

1227: --hz.primary_phone_area_code||' '||
1228: --hz.primary_phone_number||' '||
1229: --hz.primary_phone_extension,
1230: --hz.email_address
1231: from hz_parties hz, hz_relationships rel
1232: where rel.party_id = param_contact_party_id
1233: and rel.object_id = p_customer_id
1234: and rel.subject_id = hz.party_id
1235: and rel.subject_type = 'PERSON';

Line 1463: from hz_relationships

1459: and cp.party_id = p_party_id)
1460: or
1461: (cp.contact_type = 'PARTY_RELATIONSHIP'
1462: and cp.party_id in ( select party_id
1463: from hz_relationships
1464: where subject_id = p_party_id
1465: and subject_type = 'PERSON')
1466: )
1467: );