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 AS_ACCESSES_ALL

Line 75: /* Deleting records in as_accesses_all where partner_customer_id has partner's organization id */

71: IS
72:
73: BEGIN
74:
75: /* Deleting records in as_accesses_all where partner_customer_id has partner's organization id */
76:
77: INSERT INTO pv_access_migration_log
78: (
79: access_migration_log_id

Line 128: as_accesses_all b,

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
132: AND a.incumbent_partner_party_id is not null

Line 134: as_accesses_all d

130: WHERE a.incumbent_partner_party_id = b.partner_customer_id
131: AND a.lead_id = b.lead_id
132: AND a.incumbent_partner_party_id is not null
133: AND c.source_id = a.incumbent_partner_party_id) x,
134: as_accesses_all d
135: WHERE x.lead_id = d.lead_id
136: AND d.salesforce_id = x.resource_id
137: AND x.customer_id = d.customer_id
138: AND x.address_id = d.address_id

Line 144: DELETE FROM as_accesses_all

140:
141: -- ----------------------------------------------------------
142: -- Deleting the corrupted preferred partners
143: -- ----------------------------------------------------------
144: DELETE FROM as_accesses_all
145: WHERE access_id IN ( SELECT access_id
146: FROM pv_access_migration_log
147: WHERE action = 'DELTE_CORRUPT_PF_PARTNER');
148: /*

Line 189: FROM as_accesses_all a ,

185: partner_address_id,
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,

Line 193: FROM as_accesses_all acc,

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
195: WHERE sales_lead_id IS NULL
196: AND lead_id IS NOT NULL
197: AND a.customer_id = acc.customer_id

Line 242: FROM as_accesses_all a ,

238: partner_address_id,
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,

Line 246: FROM as_accesses_all acc,

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
248: WHERE sales_lead_id IS NOT NULL
249: AND lead_id IS NULL
250: AND a.customer_id = acc.customer_id

Line 292: FROM as_accesses_all a ,

288: partner_customer_id,
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,

Line 296: FROM as_accesses_all acc,

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
298: WHERE sales_lead_id IS NULL
299: AND lead_id IS NULL
300: AND a.customer_id = acc.customer_id

Line 311: DELETE FROM as_accesses_all

307:
308: -- ----------------------------------------------------------
309: -- Deleting the corrupted partners
310: -- ----------------------------------------------------------
311: DELETE FROM as_accesses_all
312: WHERE access_id IN ( SELECT access_id
313: FROM pv_access_migration_log
314: WHERE action IN ('DELETE_CORRUPT_CUST_PARTNER','DELETE_CORRUPT_LEAD_PARTNER','DELETE_CORRUPT_OPP_PARTNER'));
315: EXCEPTION

Line 409: FROM as_accesses_all ACC,

405: first_value(pvp.partner_id) over ( partition by ACC.lead_id, hz1.object_id order by pvp.status ASC,pvp.partner_id desc) partner_id,
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

Line 417: FROM as_accesses_all acc2,

413: AND ACC.person_id IS NULL
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

Line 444: INSERT INTO as_accesses_all

440: g_ret_code := 2;
441: RAISE;
442: END;
443:
444: INSERT INTO as_accesses_all
445: ( access_id,
446: last_update_date,
447: last_updated_by,
448: creation_date,

Line 578: FROM as_accesses_all ACC,

574: FIRST_VALUE(pvp.partner_id) OVER ( PARTITION BY ACC.lead_id, hz1.object_id ORDER BY pvp.status ASC, pvp.partner_id DESC) partner_id,
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

Line 587: FROM as_accesses_all ACC2,

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

Line 615: INSERT INTO as_accesses_all

611: g_ret_code := 2;
612: RAISE;
613: END;
614:
615: INSERT INTO as_accesses_all
616: ( access_id,
617: last_update_date,
618: last_updated_by,
619: creation_date,

Line 761: FROM as_accesses_all ACC,

757: END partner_id,
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,

Line 772: FROM as_accesses_all acc2,

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

Line 784: FROM as_accesses_all acc3

780: AND acc2.person_id IS NULL
781: AND acc2.lead_id is not null
782: AND acc2.sales_lead_id is null)
783: AND not exists ( SELECT NULL
784: FROM as_accesses_all acc3
785: WHERE acc3.partner_customer_id = ass.partner_id
786: AND acc3.lead_id = ass.lead_id)
787: AND ACC.partner_cont_party_id = hz1.party_id
788: AND hz1.object_id = pvp.partner_party_id

Line 807: INSERT INTO as_accesses_all

803: g_ret_code := 2;
804: RAISE;
805: END;
806:
807: INSERT INTO as_accesses_all
808: ( access_id,
809: last_update_date,
810: last_updated_by,
811: creation_date,

Line 951: as_accesses_all b,

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
955: AND a.incumbent_partner_party_id is not null

Line 958: WHERE NOT EXISTS ( SELECT NULL FROM as_accesses_all

954: AND a.lead_id = b.lead_id
955: AND a.incumbent_partner_party_id is not null
956: AND c.category = 'PARTNER'
957: AND c.source_id = a.incumbent_partner_party_id ) x
958: WHERE NOT EXISTS ( SELECT NULL FROM as_accesses_all
959: where partner_customer_id = x.incumbent_partner_party_id
960: and lead_id = x.lead_id
961: and salesforce_id = x.resource_id);
962: EXCEPTION

Line 970: INSERT INTO as_accesses_all

966: g_ret_code := 2;
967: RAISE;
968: END;
969:
970: INSERT INTO as_accesses_all
971: ( access_id,
972: last_update_date,
973: last_updated_by,
974: creation_date,

Line 1103: FROM pv_lead_assignments a, as_accesses_all b

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
1104: WHERE a.partner_id = b.partner_customer_id
1105: AND a.lead_id = b.lead_id
1106: AND c.lead_id = a.lead_id
1107: AND c.partner_id = b.partner_customer_id

Line 1122: INSERT INTO as_accesses_all

1118: g_ret_code := 2;
1119: RAISE;
1120: END;
1121:
1122: INSERT INTO as_accesses_all
1123: ( access_id,
1124: last_update_date,
1125: last_updated_by,
1126: creation_date,

Line 1253: FROM as_accesses_all b

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
1254: WHERE c.lead_id = b.lead_id
1255: AND c.partner_id = b.partner_customer_id
1256: AND b.salesforce_id = y.resource_id)
1257: AND x.lead_id = c.lead_id

Line 1269: INSERT INTO as_accesses_all

1265: g_ret_code := 2;
1266: RAISE;
1267: END;
1268:
1269: INSERT INTO as_accesses_all
1270: ( access_id,
1271: last_update_date,
1272: last_updated_by,
1273: creation_date,