49: IS
50: SELECT
51: party.party_name,
52: decode (logs.BYPASS_CM_FLAG,
53: 'N',fnd_message.get_string('PV','PV_ASSIGN_CM_APPRVL_REQ'),
54: 'Y',fnd_message.get_string('PV','PV_ASSIGN_CM_APPRVL_NOT_REQ'),
55: fnd_message.get_string('PV','PV_ASSIGN_CM_APPRVL_NOTREQ')) bypass_message,
56: plkp1.meaning routing_type_meaning
57: FROM
50: SELECT
51: party.party_name,
52: decode (logs.BYPASS_CM_FLAG,
53: 'N',fnd_message.get_string('PV','PV_ASSIGN_CM_APPRVL_REQ'),
54: 'Y',fnd_message.get_string('PV','PV_ASSIGN_CM_APPRVL_NOT_REQ'),
55: fnd_message.get_string('PV','PV_ASSIGN_CM_APPRVL_NOTREQ')) bypass_message,
56: plkp1.meaning routing_type_meaning
57: FROM
58: pv_lead_assignments assgn,
51: party.party_name,
52: decode (logs.BYPASS_CM_FLAG,
53: 'N',fnd_message.get_string('PV','PV_ASSIGN_CM_APPRVL_REQ'),
54: 'Y',fnd_message.get_string('PV','PV_ASSIGN_CM_APPRVL_NOT_REQ'),
55: fnd_message.get_string('PV','PV_ASSIGN_CM_APPRVL_NOTREQ')) bypass_message,
56: plkp1.meaning routing_type_meaning
57: FROM
58: pv_lead_assignments assgn,
59: pv_lead_workflows ldwf,