APPS.PV_SLSTEAM_MIGRTN_PVT dependencies on HZ_RELATIONSHIPS

Line 194: hz_relationships b

190: pv_partner_profiles pvp
191: WHERE a.partner_customer_id = pvp.partner_party_id
192: AND EXISTS ( SELECT partner_customer_id
193: FROM as_accesses_all acc,
194: hz_relationships b
195: WHERE sales_lead_id IS NULL
196: AND lead_id IS NOT NULL
197: AND a.customer_id = acc.customer_id
198: AND b.object_id = pvp.partner_party_id

Line 247: hz_relationships b

243: pv_partner_profiles pvp
244: WHERE a.partner_customer_id = pvp.partner_party_id
245: AND EXISTS ( SELECT partner_customer_id
246: FROM as_accesses_all acc,
247: hz_relationships b
248: WHERE sales_lead_id IS NOT NULL
249: AND lead_id IS NULL
250: AND a.customer_id = acc.customer_id
251: AND b.object_id = pvp.partner_party_id

Line 297: hz_relationships b

293: pv_partner_profiles pvp
294: WHERE a.partner_customer_id = pvp.partner_party_id
295: AND EXISTS ( SELECT partner_customer_id
296: FROM as_accesses_all acc,
297: hz_relationships b
298: WHERE sales_lead_id IS NULL
299: AND lead_id IS NULL
300: AND a.customer_id = acc.customer_id
301: AND b.object_id = pvp.partner_party_id

Line 410: hz_relationships hz1,

406: acc.customer_id,
407: acc.address_id,
408: acc.org_id
409: FROM as_accesses_all ACC,
410: hz_relationships hz1,
411: pv_partner_profiles pvp
412: WHERE ACC.partner_cont_party_id IS NOT NULL
413: AND ACC.person_id IS NULL
414: AND ACC.lead_id is null

Line 419: hz_relationships hz

415: AND acc.sales_lead_id is null
416: AND not exists (SELECT NULL
417: FROM as_accesses_all acc2,
418: pv_partner_profiles PVPP,
419: hz_relationships hz
420: WHERE acc2.customer_id = acc.customer_id
421: AND acc2.partner_customer_id = PVPP.partner_id
422: AND hz.object_id = pvpp.partner_party_id
423: AND pvp.partner_party_id = pvpp.partner_party_id

Line 579: hz_relationships hz1,

575: asl.customer_id,
576: asl.address_id,
577: acc.org_id
578: FROM as_accesses_all ACC,
579: hz_relationships hz1,
580: pv_partner_profiles pvp,
581: as_sales_leads asl
582: WHERE ACC.sales_lead_id is not null
583: AND ACC.partner_cont_party_id is not null

Line 589: hz_relationships HZ

585: AND ASL.sales_lead_id = ACC.sales_lead_id
586: AND not exists (SELECT NULL
587: FROM as_accesses_all ACC2,
588: pv_partner_profiles PVPP,
589: hz_relationships HZ
590: WHERE ACC2.sales_lead_id = ACC.sales_lead_id
591: AND ACC2.partner_customer_id = PVPP.partner_id
592: AND HZ.object_id = PVPP.partner_party_id
593: AND PVP.partner_party_id = PVPP.partner_party_id

Line 762: hz_relationships hz1,

758: asl.customer_id,
759: asl.address_id,
760: asl.org_id
761: FROM as_accesses_all ACC,
762: hz_relationships hz1,
763: pv_partner_profiles pvp,
764: as_leads_all asl,
765: pv_lead_assignments ass,
766: pv_lead_workflows pvw

Line 774: hz_relationships hz

770: AND asl.lead_id = acc.lead_id
771: AND not exists (SELECT NULL
772: FROM as_accesses_all acc2,
773: pv_partner_profiles PVPP,
774: hz_relationships hz
775: WHERE acc2.lead_id = acc.lead_id
776: AND acc2.partner_customer_id = PVPP.partner_id
777: AND hz.object_id = pvpp.partner_party_id
778: AND pvp.partner_party_id = pvpp.partner_party_id