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

Line 272: , hz_parties c

268: , a.org_id
269: --Bug# 8208686 fixed by ateotia(-)
270: from ozf_request_headers_all_vl a
271: , pv_partner_profiles b
272: , hz_parties c
273: , jtf_rs_resource_extns pt_cont
274: , jtf_rs_resource_extns creator
275: , ozf_lookups lkup
276: -- BUG 4460277 (+)

Line 278: , hz_parties cont

274: , jtf_rs_resource_extns creator
275: , ozf_lookups lkup
276: -- BUG 4460277 (+)
277: , hz_relationships hz_cont_rel
278: , hz_parties cont
279: , pv_partner_profiles pvpp
280: -- BUG 4460277 (-)
281: where a.request_header_id = pc_request_id
282: and a.partner_id = b.partner_id

Line 290: and hz_cont_rel.object_table_name = 'HZ_PARTIES'

286: and lkup.lookup_type = 'OZF_REQUEST_STATUS'
287: -- BUG 4460277 (+)
288: and pvpp.partner_id = a.partner_id
289: and hz_cont_rel.object_id = pvpp.partner_party_id
290: and hz_cont_rel.object_table_name = 'HZ_PARTIES'
291: and hz_cont_rel.subject_id = cont.party_id
292: and hz_cont_rel.subject_table_name = 'HZ_PARTIES'
293: and hz_cont_rel.relationship_type = 'EMPLOYMENT'
294: and cont.party_type = 'PERSON'

Line 292: and hz_cont_rel.subject_table_name = 'HZ_PARTIES'

288: and pvpp.partner_id = a.partner_id
289: and hz_cont_rel.object_id = pvpp.partner_party_id
290: and hz_cont_rel.object_table_name = 'HZ_PARTIES'
291: and hz_cont_rel.subject_id = cont.party_id
292: and hz_cont_rel.subject_table_name = 'HZ_PARTIES'
293: and hz_cont_rel.relationship_type = 'EMPLOYMENT'
294: and cont.party_type = 'PERSON'
295: and hz_cont_rel.party_id = pt_cont.source_id
296: and pt_cont.category = 'PARTY'

Line 329: hz_parties vendor

325: select vendor.party_name vendor_name
326: from ozf_request_headers_all_vl enrl_req,
327: pv_partner_profiles prtnr_profile,
328: hz_relationships rel_ship,
329: hz_parties vendor
330: where enrl_req.request_header_id = pc_entity_id
331: and enrl_req.partner_id= prtnr_profile.partner_id
332: and prtnr_profile.partner_id = rel_ship.party_id
333: and prtnr_profile.partner_party_id = rel_ship.object_id

Line 800: and pr2.subject_table_name = 'HZ_PARTIES'

796: fnd_user usr
797: WHERE
798: prof.partner_id = pc_partner_id
799: and prof.partner_party_id = pr2.object_id
800: and pr2.subject_table_name = 'HZ_PARTIES'
801: and pr2.object_table_name = 'HZ_PARTIES'
802: and pr2.directional_flag = 'F'
803: and pr2.relationship_code = 'EMPLOYEE_OF'
804: and pr2.relationship_type = 'EMPLOYMENT'

Line 801: and pr2.object_table_name = 'HZ_PARTIES'

797: WHERE
798: prof.partner_id = pc_partner_id
799: and prof.partner_party_id = pr2.object_id
800: and pr2.subject_table_name = 'HZ_PARTIES'
801: and pr2.object_table_name = 'HZ_PARTIES'
802: and pr2.directional_flag = 'F'
803: and pr2.relationship_code = 'EMPLOYEE_OF'
804: and pr2.relationship_type = 'EMPLOYMENT'
805: and (pr2.end_date is null or pr2.end_date > sysdate)