APPS.PV_OPPTY_ROUTING_LOG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 50

	SELECT
		party.party_name,
		decode (logs.BYPASS_CM_FLAG,
		'N',fnd_message.get_string('PV','PV_ASSIGN_CM_APPRVL_REQ'),
		'Y',fnd_message.get_string('PV','PV_ASSIGN_CM_APPRVL_NOT_REQ'),
		fnd_message.get_string('PV','PV_ASSIGN_CM_APPRVL_NOTREQ')) bypass_message,
		plkp1.meaning routing_type_meaning
	FROM
		pv_lead_assignments assgn,
		pv_lead_workflows ldwf,
		pv_partner_profiles partprof,
		hz_parties party,
		pv_oppty_routing_logs logs,
		pv_lookups plkp1
	WHERE
		logs.oppty_routing_log_id= pc_oppty_routing_log_id
		and ldwf.lead_workflow_id= logs.lead_workflow_id
		--and ldwf.WF_ITEM_TYPE <> 'PVLEADAS'
		and ldwf.WF_ITEM_TYPE = assgn.WF_ITEM_TYPE
		and ldwf.WF_ITEM_KEY = assgn.WF_ITEM_KEY
		and assgn.partner_id = partprof.partner_id
		and partprof.partner_party_id = party.party_id
		and plkp1.lookup_type (+)='PV_ASSIGNMENT_TYPE'
		and plkp1.lookup_code (+) = logs.routing_type
	;

Line: 77

	SELECT
		party.party_name
	FROM
		pv_lead_assignments assgn,
		pv_partner_profiles partprof,
		hz_parties party
	WHERE
		assgn.lead_assignment_id = pc_lead_assignment_id --10569
		and assgn.partner_id = partprof.partner_id
		and partprof.partner_party_id = party.party_id
	;

Line: 90

	SELECT
		party.party_name
	FROM
		pv_lead_assignments assgn,
		pv_partner_profiles partprof,
		hz_parties party
	WHERE
		assgn.lead_assignment_id = pc_lead_assignment_id --10569
		and assgn.partner_id = partprof.partner_id
		and partprof.partner_party_id = party.party_id
	;

Line: 103

	SELECT
		party.party_name
	FROM
		pv_lead_assignments assgn,
		pv_partner_profiles partprof,
		hz_parties party
	WHERE
		assgn.lead_assignment_id = pc_lead_assignment_id --10569
		and assgn.partner_id = partprof.partner_id
		and partprof.partner_party_id = party.party_id
	;

Line: 116

	SELECT
		party.party_name
	FROM
		pv_lead_assignments assgn,
		pv_partner_profiles partprof,
		hz_parties party
	WHERE
		assgn.lead_assignment_id = pc_lead_assignment_id --10569
		and assgn.partner_id = partprof.partner_id
		and partprof.partner_party_id = party.party_id
	;

Line: 129

	select
		logs.user_response,
		logs.reason_code,
		plkp1.meaning response_meaning,
		plkp2.meaning reason_meaning

	from
		pv_oppty_routing_logs logs,
		pv_lookups plkp1,
		pv_lookups plkp2

	where
		logs.oppty_routing_log_id= pc_oppty_routing_log_id
		and plkp1.lookup_type (+) = 'PV_ASSIGNMENT_STATUS'
		and plkp1.lookup_code (+) = logs.user_response
		and plkp2.lookup_type (+) = 'PV_REASON_CODES'
		and plkp2.lookup_code (+) = logs.reason_code
	;

Line: 149

	select
		logs.user_response,
		logs.reason_code,
		plkp1.meaning response_meaning,
		plkp2.meaning reason_meaning

	from
		pv_oppty_routing_logs logs,
		pv_lookups plkp1,
		pv_lookups plkp2

	where
		logs.oppty_routing_log_id= pc_oppty_routing_log_id
		and plkp1.lookup_type (+) = 'PV_ASSIGNMENT_STATUS'
		and plkp1.lookup_code (+) = logs.user_response
		and plkp2.lookup_type (+) = 'PV_REASON_CODES'
		and plkp2.lookup_code (+) = logs.reason_code
	;

Line: 169

	select
		ldwf.failure_code,
		ldwf.failure_message
	from
		pv_lead_workflows ldwf
	where
		ldwf.lead_workflow_id= pc_lead_workflow_id
	;

Line: 180

	select resource_response
	    from pv_party_notifications
	    where lead_assignment_id=pc_lead_assignment_id
	    and notification_type='MATCHED_TO';

Line: 225

				select ldall.description
				into l_lead_description
				from as_leads_all ldall,
				pv_lead_assignments ldass
				where ldass.lead_id=ldall.lead_id and
				ldass.lead_assignment_id=p_lead_assignment_id;