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_PARTIES

Line 122: from hz_parties hz

118: --
119: if p_contact_type = 'PERSON' then
120: select hz.party_name
121: into l_contact_name
122: from hz_parties hz
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

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 569: decode(contact.party_source_table, 'HZ_PARTIES', 'PARTY_RELATIONSHIP', 'EMPLOYEE') contact_type,

565: incident_type_id = p_inc_type_id;
566: --
567: cursor c_contact is
568: select
569: decode(contact.party_source_table, 'HZ_PARTIES', 'PARTY_RELATIONSHIP', 'EMPLOYEE') contact_type,
570: contact.party_id contact_id,
571: owner.party_id
572: from
573: csi_i_parties contact,

Line 1220: from hz_parties hz

1216: --hz.primary_phone_area_code||' '||
1217: --hz.primary_phone_number||' '||
1218: --hz.primary_phone_extension,
1219: --hz.email_address
1220: from hz_parties hz
1221: where hz.party_id = p_customer_id;
1222:
1223: cursor c_rel(param_contact_party_id NUMBER) is
1224: select --hz.party_number,

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 1411: from hz_parties hz

1407: if p_assc_party_type = 'PERSON' or p_assc_party_type ='PARTY_RELATIONSHIP' OR
1408: p_assc_party_type ='ORGANIZATION' then
1409: select hz.party_name
1410: into l_assc_party_name
1411: from hz_parties hz
1412: where hz.party_id = p_assc_party_id;
1413: elsif p_assc_party_type = 'EMPLOYEE' then
1414: OPEN c1(p_assc_party_id);
1415: LOOP