[Home] [Help]
99: -- Checks if the opportunity is "open".
100: -- --------------------------------------------------------------------------------
101: CURSOR lc_check_open_status IS
102: SELECT b.opp_open_status_flag
103: FROM as_leads_all a,
104: as_statuses_b b
105: WHERE a.lead_id = p_lead_id AND
106: a.status = b.status_code AND
107: b.opp_flag = 'Y';
135: ld.description,
136: ld.total_amount||' '||ld.currency_code,
137: pt.party_name,
138: lc.lead_contact_id
139: from as_leads_all ld,
140: hz_parties pt,
141: as_lead_contacts lc
142: where ld.lead_id = pc_lead_id
143: and ld.customer_id = pt.party_id (+)
798: end if;
799:
800: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
801: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
802: fnd_message.Set_token('TEXT', 'Update as_leads_all table with auto_assignment_type = PRM, prm_assignment_type = p_assignment_type' );
803: fnd_msg_pub.Add;
804: end if;
805:
806: update as_leads_all
802: fnd_message.Set_token('TEXT', 'Update as_leads_all table with auto_assignment_type = PRM, prm_assignment_type = p_assignment_type' );
803: fnd_msg_pub.Add;
804: end if;
805:
806: update as_leads_all
807: set auto_assignment_type = 'PRM', prm_assignment_type = p_assignment_type
808: where lead_id = p_lead_id;
809:
810: -- Added part of Rivendell Changes
2815: b.description,
2816: b.total_amount||' '||b.currency_code,
2817: c.party_name
2818: from pv_lead_workflows a
2819: , as_leads_all b
2820: , hz_parties c
2821: where a.lead_id = pc_lead_id
2822: and b.customer_id = c.party_id
2823: and a.latest_routing_flag = 'Y'
3487: , a.lead_number
3488: , a.description
3489: , a.total_amount||' '||a.currency_code
3490: , b.party_name
3491: FROM as_leads_all a, hz_parties b
3492: WHERE a.lead_id = pc_lead_id
3493: AND a.customer_id = b.party_id
3494: and b.status in ('A', 'I');
3495: