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.

[Home] [Help]

APPS.OZF_REQUEST_STATUS_PVT dependencies on HZ_PARTIES

Line 264: , hz_parties c

260: , a.request_type_code
261: , NVL(a.offer_id,-1)
262: from ozf_request_headers_all_vl a
263: , pv_partner_profiles b
264: , hz_parties c
265: , jtf_rs_resource_extns pt_cont
266: , jtf_rs_resource_extns creator
267: , ozf_lookups lkup
268: -- BUG 4460277 (+)

Line 270: , hz_parties cont

266: , jtf_rs_resource_extns creator
267: , ozf_lookups lkup
268: -- BUG 4460277 (+)
269: , hz_relationships hz_cont_rel
270: , hz_parties cont
271: , pv_partner_profiles pvpp
272: -- BUG 4460277 (-)
273: where a.request_header_id = pc_request_id
274: and a.partner_id = b.partner_id

Line 282: and hz_cont_rel.object_table_name = 'HZ_PARTIES'

278: and lkup.lookup_type = 'OZF_REQUEST_STATUS'
279: -- BUG 4460277 (+)
280: and pvpp.partner_id = a.partner_id
281: and hz_cont_rel.object_id = pvpp.partner_party_id
282: and hz_cont_rel.object_table_name = 'HZ_PARTIES'
283: and hz_cont_rel.subject_id = cont.party_id
284: and hz_cont_rel.subject_table_name = 'HZ_PARTIES'
285: and hz_cont_rel.relationship_type = 'EMPLOYMENT'
286: and cont.party_type = 'PERSON'

Line 284: and hz_cont_rel.subject_table_name = 'HZ_PARTIES'

280: and pvpp.partner_id = a.partner_id
281: and hz_cont_rel.object_id = pvpp.partner_party_id
282: and hz_cont_rel.object_table_name = 'HZ_PARTIES'
283: and hz_cont_rel.subject_id = cont.party_id
284: and hz_cont_rel.subject_table_name = 'HZ_PARTIES'
285: and hz_cont_rel.relationship_type = 'EMPLOYMENT'
286: and cont.party_type = 'PERSON'
287: and hz_cont_rel.party_id = pt_cont.source_id
288: and pt_cont.category = 'PARTY'

Line 321: hz_parties vendor

317: select vendor.party_name vendor_name
318: from ozf_request_headers_all_vl enrl_req,
319: pv_partner_profiles prtnr_profile,
320: hz_relationships rel_ship,
321: hz_parties vendor
322: where enrl_req.request_header_id = pc_entity_id
323: and enrl_req.partner_id= prtnr_profile.partner_id
324: and prtnr_profile.partner_id = rel_ship.party_id
325: and prtnr_profile.partner_party_id = rel_ship.object_id

Line 787: and pr2.subject_table_name = 'HZ_PARTIES'

783: fnd_user usr
784: WHERE
785: prof.partner_id = pc_partner_id
786: and prof.partner_party_id = pr2.object_id
787: and pr2.subject_table_name = 'HZ_PARTIES'
788: and pr2.object_table_name = 'HZ_PARTIES'
789: and pr2.directional_flag = 'F'
790: and pr2.relationship_code = 'EMPLOYEE_OF'
791: and pr2.relationship_type = 'EMPLOYMENT'

Line 788: and pr2.object_table_name = 'HZ_PARTIES'

784: WHERE
785: prof.partner_id = pc_partner_id
786: and prof.partner_party_id = pr2.object_id
787: and pr2.subject_table_name = 'HZ_PARTIES'
788: and pr2.object_table_name = 'HZ_PARTIES'
789: and pr2.directional_flag = 'F'
790: and pr2.relationship_code = 'EMPLOYEE_OF'
791: and pr2.relationship_type = 'EMPLOYMENT'
792: and (pr2.end_date is null or pr2.end_date > sysdate)