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 JTF_RS_RESOURCE_EXTNS

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 129: jtf_rs_resource_extns c

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
133: AND c.source_id = a.incumbent_partner_party_id) x,

Line 431: jtf_rs_resource_extns ext

427: AND acc2.sales_lead_id is null)
428: AND ACC.partner_cont_party_id = hz1.party_id
429: AND hz1.object_id = pvp.partner_party_id
430: ) x,
431: jtf_rs_resource_extns ext
432: WHERE x.partner_id = ext.source_id
433: AND ext.category = 'PARTNER');
434: printLog('No of Partners inserted into customer external sales team :'||SQL%ROWCOUNT ||'- insert into access');
435:

Line 601: jtf_rs_resource_extns ext

597: AND acc2.sales_lead_id is not null)
598: AND ACC.partner_cont_party_id = hz1.party_id
599: AND hz1.object_id = pvp.partner_party_id
600: ) x,
601: jtf_rs_resource_extns ext
602: WHERE x.partner_id = ext.source_id
603: AND ext.category = 'PARTNER');
604:
605: printLog('No of Partners inserted into lead external sales team :'||SQL%ROWCOUNT ||'- insert into access');

Line 792: jtf_rs_resource_extns ext

788: AND hz1.object_id = pvp.partner_party_id
789: AND asl.lead_id = ass.lead_id(+)
790: AND asl.lead_id = pvw.lead_ID(+)
791: AND pvw.latest_routing_flag(+) = 'Y') x,
792: jtf_rs_resource_extns ext
793: WHERE x.partner_id = ext.source_id
794: AND ext.category = 'PARTNER'
795: AND x.partner_id is not null);
796:

Line 939: jtf_rs_resource_extns c

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
943: MINUS

Line 952: jtf_rs_resource_extns c

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
956: AND c.category = 'PARTNER'

Line 1100: jtf_rs_resource_extns y

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
1104: WHERE a.partner_id = b.partner_customer_id

Line 1250: jtf_rs_resource_extns y

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
1254: WHERE c.lead_id = b.lead_id