DBA Data[Home] [Help]

APPS.OZF_REQUEST_STATUS_PVT dependencies on OZF_REQUEST_HEADERS_ALL_VL

Line 262: from ozf_request_headers_all_vl a

258: , a.end_date
259: , a.activity_media_id
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

Line 318: from ozf_request_headers_all_vl enrl_req,

314: where media_id = pc_media_id;
315:
316: cursor lc_vendor_name ( pc_entity_id number) is
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