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.PV_SLSTEAM_MIGRTN_PVT dependencies on PV_PARTNER_PROFILES

Line 190: pv_partner_profiles pvp

186: lead_id,
187: org_id,
188: open_flag
189: FROM as_accesses_all a ,
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

Line 243: pv_partner_profiles pvp

239: sales_lead_id,
240: org_id,
241: open_flag
242: FROM as_accesses_all a ,
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

Line 293: pv_partner_profiles pvp

289: partner_address_id,
290: org_id,
291: open_flag
292: FROM as_accesses_all a ,
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

Line 411: pv_partner_profiles pvp

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
415: AND acc.sales_lead_id is null

Line 418: pv_partner_profiles PVPP,

414: AND ACC.lead_id is null
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

Line 580: pv_partner_profiles pvp,

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
584: AND ACC.person_id is null

Line 588: pv_partner_profiles PVPP,

584: AND ACC.person_id is null
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

Line 763: pv_partner_profiles pvp,

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
767: WHERE ACC.lead_id is not null

Line 773: pv_partner_profiles PVPP,

769: AND ACC.person_id is null
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

Line 1390: pv_partner_profiles pvpp ,

1386: b.party_name ,
1387: a.salesforce_id
1388: from pv_access_migration_log a,
1389: hz_parties b,
1390: pv_partner_profiles pvpp ,
1391: as_leads_all asl
1392: where a.partner_customer_id = pvpp.partner_id
1393: and pvpp.partner_party_id = b.party_id
1394: and asl.lead_id = a.lead_id

Line 1448: pv_partner_profiles pvpp ,

1444: ( select d.party_name entity, d.party_number entity_id,
1445: b.party_name , a.salesforce_id
1446: from pv_access_migration_log a,
1447: hz_parties b,
1448: pv_partner_profiles pvpp ,
1449: hz_parties d
1450: where a.partner_customer_id = pvpp.partner_party_id
1451: and pvpp.partner_party_id = b.party_id
1452: and a.customer_id = d.party_id

Line 1508: pv_partner_profiles pvpp ,

1504: ( select asl.description entity, asl.lead_number entity_id,
1505: b.party_name , a.salesforce_id
1506: from pv_access_migration_log a,
1507: hz_parties b,
1508: pv_partner_profiles pvpp ,
1509: as_sales_leads asl
1510: where a.partner_customer_id = pvpp.partner_party_id
1511: and pvpp.partner_party_id = b.party_id
1512: and asl.sales_lead_id = a.sales_lead_id

Line 1574: pv_partner_profiles pvpp ,

1570: b.party_name ,
1571: a.salesforce_id
1572: from pv_access_migration_log a,
1573: hz_parties b,
1574: pv_partner_profiles pvpp ,
1575: as_leads_all asl
1576: where a.partner_customer_id = pvpp.partner_party_id
1577: and pvpp.partner_party_id = b.party_id
1578: and asl.lead_id = a.lead_id

Line 1635: pv_partner_profiles pvpp ,

1631: ( select d.party_name entity, d.party_number entity_id,
1632: b.party_name , a.salesforce_id
1633: from pv_access_migration_log a,
1634: hz_parties b,
1635: pv_partner_profiles pvpp ,
1636: hz_parties d
1637: where a.partner_customer_id = pvpp.partner_id
1638: and pvpp.partner_party_id = b.party_id
1639: and a.customer_id = d.party_id

Line 1695: pv_partner_profiles pvpp ,

1691: ( select asl.description entity, asl.lead_number entity_id,
1692: b.party_name , a.salesforce_id
1693: from pv_access_migration_log a,
1694: hz_parties b,
1695: pv_partner_profiles pvpp ,
1696: as_sales_leads asl
1697: where a.partner_customer_id = pvpp.partner_id
1698: and pvpp.partner_party_id = b.party_id
1699: and asl.sales_lead_id = a.sales_lead_id

Line 1761: pv_partner_profiles pvpp ,

1757: b.party_name ,
1758: a.salesforce_id
1759: from pv_access_migration_log a,
1760: hz_parties b,
1761: pv_partner_profiles pvpp ,
1762: as_leads_all asl
1763: where a.partner_customer_id = pvpp.partner_id
1764: and pvpp.partner_party_id = b.party_id
1765: and asl.lead_id = a.lead_id