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_BG_PARTNER_MATCHING_PUB dependencies on AS_LEADS_ALL

Line 265: FROM as_leads_all

261: WHERE resource_id = c_resource_id;
262:
263: CURSOR c_get_lead_name(c_lead_id NUMBER) IS
264: SELECT description
265: FROM as_leads_all
266: WHERE lead_id = c_lead_id;
267:
268: CURSOR c_get_lead_rule_name(c_lead_id NUMBER, c_process_rule_id NUMBER) IS
269: SELECT opp.description, rule.process_rule_name

Line 270: FROM as_leads_all opp, pv_process_rules_vl rule

266: WHERE lead_id = c_lead_id;
267:
268: CURSOR c_get_lead_rule_name(c_lead_id NUMBER, c_process_rule_id NUMBER) IS
269: SELECT opp.description, rule.process_rule_name
270: FROM as_leads_all opp, pv_process_rules_vl rule
271: WHERE opp.lead_id = c_lead_id
272: AND rule.process_rule_id = c_process_rule_id;
273:
274: CURSOR c_get_lead_info(c_lead_id NUMBER) IS

Line 276: FROM as_leads_all

272: AND rule.process_rule_id = c_process_rule_id;
273:
274: CURSOR c_get_lead_info(c_lead_id NUMBER) IS
275: SELECT customer_id, address_id
276: FROM as_leads_all
277: WHERE lead_id = c_lead_id;
278:
279: CURSOR c_get_group_id (c_resource_id NUMBER) IS
280: SELECT grp.group_id

Line 352: FROM as_leads_all a,

348: l_routing_exist_flag := FALSE;
349:
350: FOR x IN (
351: SELECT b.opp_open_status_flag, c.lead_id
352: FROM as_leads_all a,
353: as_statuses_b b,
354: pv_lead_workflows c
355: WHERE a.lead_id = l_lead_id AND
356: a.status = b.status_code AND

Line 367: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP

363: -- -----------------------------------------------------------------------
364: IF (x.opp_open_status_flag <> 'Y') THEN
365: l_open_opportunity_flag := FALSE;
366:
367: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
368: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_CLOSED_OPP');
369: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
370: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
371: fnd_msg_pub.ADD;

Line 379: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP

375: -- -----------------------------------------------------------------------
376: -- This opportunity has already been routed.
377: -- -----------------------------------------------------------------------
378: IF (x.lead_id IS NOT NULL) THEN
379: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
380: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_ALREADY_EXISTS');
381: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
382: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
383: fnd_msg_pub.ADD;

Line 912: select customer_id, address_id, source_promotion_id from as_leads_all where lead_id = pc_lead_id;

908: AND ac.arc_source_code_for in ('CAMP', 'CSCH') AND ac.source_code_for_id = acp.act_partner_used_by_id
909: AND acp.arc_act_partner_used_by = ac.arc_source_code_for AND acp.partner_id = pp.partner_id;
910:
911: cursor lc_get_lead_detail (pc_lead_id number) is
912: select customer_id, address_id, source_promotion_id from as_leads_all where lead_id = pc_lead_id;
913:
914: l_partner_id_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
915: l_partner_rank_tbl JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
916: l_partner_source_tbl JTF_VARCHAR2_TABLE_100 := JTF_VARCHAR2_TABLE_100();

Line 958: FROM as_leads_all a,

954: l_routing_exist_flag := FALSE;
955:
956: FOR x IN (
957: SELECT b.opp_open_status_flag, c.lead_id , c.routing_status
958: FROM as_leads_all a,
959: as_statuses_b b,
960: pv_lead_workflows c
961: WHERE a.lead_id = l_lead_id AND a.status = b.status_code AND
962: b.opp_flag = 'Y' AND a.lead_id = c.lead_id (+) and c.latest_routing_flag (+) = 'Y')

Line 970: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP

966: -- -----------------------------------------------------------------------
967: IF (x.opp_open_status_flag <> 'Y') THEN
968: l_open_opportunity_flag := FALSE;
969:
970: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
971: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_CLOSED_OPP');
972: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
973: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
974: fnd_msg_pub.ADD;

Line 982: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP

978: -- -----------------------------------------------------------------------
979: -- This opportunity has already been routed.
980: -- -----------------------------------------------------------------------
981: IF (x.lead_id IS NOT NULL AND x.routing_status IN ('ACTIVE','MATCHED','OFFERED')) THEN
982: FOR x IN (SELECT description FROM as_leads_all WHERE lead_id = l_lead_id) LOOP
983: fnd_message.SET_NAME('PV', 'PV_OPP_ROUTING_ALREADY_EXISTS');
984: fnd_message.SET_TOKEN('OPPORTUNITY_NAME', x.description);
985: fnd_message.SET_TOKEN('LEAD_ID' , l_lead_id);
986: fnd_msg_pub.ADD;