APPS.PV_SLSTEAM_MIGRTN_PVT dependencies on AS_LEADS_ALL

Line 117: FROM as_leads_all a, jtf_rs_resource_extns b

113: a.customer_id,
114: a.ADDRESS_ID,
115: a.org_id ,
116: a.incumbent_partner_party_id
117: FROM as_leads_all a, jtf_rs_resource_extns b
118: WHERE a.incumbent_partner_resource_id IS NOT NULL
119: AND b.source_id = a.incumbent_partner_party_id
120: MINUS
121: SELECT distinct a.lead_id,

Line 127: FROM as_leads_all a,

123: a.customer_id,
124: a.ADDRESS_ID,
125: a.org_id,
126: a.incumbent_partner_party_id
127: FROM as_leads_all a,
128: as_accesses_all b,
129: jtf_rs_resource_extns c
130: WHERE a.incumbent_partner_party_id = b.partner_customer_id
131: AND a.lead_id = b.lead_id

Line 764: as_leads_all asl,

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
768: AND ACC.partner_cont_party_id is not null

Line 872: -- Inserting preferred partners from as_leads_all into opportunity External Sales team

868: RAISE;
869: END insert_opp_partner;
870:
871: -- --
872: -- Inserting preferred partners from as_leads_all into opportunity External Sales team
873: -- --
874:
875: PROCEDURE insert_prefrd_partner
876: IS

Line 938: FROM as_leads_all a,

934: c.resource_id ,
935: a.customer_id ,
936: a.address_id ,
937: a.org_id
938: FROM as_leads_all a,
939: jtf_rs_resource_extns c
940: WHERE a.incumbent_partner_party_id is not null
941: AND c.category = 'PARTNER'
942: AND c.source_id = a.incumbent_partner_party_id

Line 950: FROM as_leads_all a,

946: c.resource_id ,
947: a.customer_id ,
948: a.address_id ,
949: a.org_id
950: FROM as_leads_all a,
951: as_accesses_all b,
952: jtf_rs_resource_extns c
953: WHERE a.incumbent_partner_party_id = b.partner_customer_id
954: AND a.lead_id = b.lead_id

Line 1099: as_leads_all x,

1095: c.partner_id,
1096: x.lead_id,
1097: x.org_id
1098: FROM pv_lead_assignments c,
1099: as_leads_all x,
1100: jtf_rs_resource_extns y
1101: WHERE wf_item_type IS NULL
1102: AND NOT EXISTS ( SELECT NULL
1103: FROM pv_lead_assignments a, as_accesses_all b

Line 1249: as_leads_all x,

1245: c.partner_id,
1246: x.lead_id,
1247: x.org_id
1248: FROM pv_lead_assignments c,
1249: as_leads_all x,
1250: jtf_rs_resource_extns y
1251: WHERE c.status = 'ASSIGNED'
1252: AND NOT EXISTS ( SELECT NULL
1253: FROM as_accesses_all b

Line 1391: as_leads_all asl

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
1395: and a.action = 'DELTE_CORRUPT_PF_PARTNER' )

Line 1575: as_leads_all asl

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
1579: and a.action = 'DELETE_CORRUPT_OPP_PARTNER')

Line 1762: as_leads_all asl

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
1766: and a.action IN ('INSERT_OPP_PARTY','INSERT_OPP_PRFRD_PT','INSERT_OPP_SAVED_PT','INSERT_OPP_ASSIGNED_PT'))