[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT grp.group_id, jts.resource_id
FROM JTF_RS_GROUP_MEMBERS mem,
JTF_RS_ROLE_RELATIONS rrel,
JTF_RS_ROLES_B role,
JTF_RS_GROUP_USAGES u,
JTF_RS_GROUPS_B grp,
JTF_RS_RESOURCE_EXTNS jts
WHERE mem.group_member_id = rrel.role_resource_id
AND rrel.role_resource_type = 'RS_GROUP_MEMBER'
AND rrel.role_id = role.role_id
AND role.role_type_code in ('SALES','TELESALES','FIELDSALES','PRM')
AND mem.delete_flag <> 'Y'
AND rrel.delete_flag <> 'Y'
AND SYSDATE BETWEEN rrel.start_date_active AND
NVL(rrel.end_date_active,SYSDATE)
AND mem.resource_id = jts.resource_id
AND jts.user_id = c_resource_id -- changed to support iStore.
AND mem.group_id = u.group_id
AND u.usage = 'SALES'
AND mem.group_id = grp.group_id
AND SYSDATE BETWEEN grp.start_date_active AND
NVL(grp.end_date_active,SYSDATE)
AND ROWNUM < 2;
SELECT 'X' -- scorecard_id
FROM AS_SALES_LEAD_SCORECARDS
WHERE start_date_active <= trunc(SYSDATE)
AND nvl(end_date_active,SYSDATE) >= trunc(SYSDATE)
AND scorecard_id = x_scorecard_id;
select card_rule_id CARD_RULE_ID,
score SCORE,
high_value_number HIGH_VALUE_NUMBER,
low_value_number LOW_VALUE_NUMBER,
high_value_char HIGH_VALUE_CHAR,
low_value_char LOW_VALUE_CHAR,
qual_value_id QUAL_VALUE_ID,
seed_qual_id SEED_QUAL_ID,
source_table_name SOURCE_TABLE_NAME,
source_column_name SOURCE_COLUMN_NAME,
substr(data_type,1,8) DATA_TYPE,
range_flag RANGE_FLAG,
meaning MEANING
from AS_SCORECARD_RULES_V
where scorecard_id = IN_SCORECARD_ID;
select a.LAST_UPDATE_DATE,
party.party_name CUSTOMER_NAME, --a.CUSTOMER_NAME,
c.CONTACT_ROLE_CODE,
a.CHANNEL_CODE,
a.BUDGET_AMOUNT,
a.CURRENCY_CODE,
a.DECISION_TIMEFRAME_CODE,
a.BUDGET_STATUS_CODE,
AMSCT.CAMPAIGN_NAME SOURCE_PROMOTION_NAME,
-- a.SOURCE_PROMOTION_NAME,
a.LEAD_RANK_ID
from as_sales_leads a, -- as_sales_leads_v a,
as_sales_lead_contacts c,
AMS_CAMPAIGNS_ALL_B AMSCB,AMS_CAMPAIGNS_ALL_TL AMSCT,
AMS_SOURCE_CODES AMSS,
hz_parties party
where a.sales_lead_id = IN_SALES_LEAD_ID
and a.sales_lead_id = c.sales_lead_id
and c.primary_contact_flag = 'Y'
and AMSS.SOURCE_CODE = AMSCB.SOURCE_CODE(+)
AND AMSCB.CAMPAIGN_ID = AMSCT.CAMPAIGN_ID(+)
and AMSCT.LANGUAGE(+) = USERENV('LANG')
and AMSS.SOURCE_CODE_ID(+) = a.source_promotion_id
and party.party_id=a.customer_id;
select a.LAST_UPDATE_DATE,
party.party_name CUSTOMER_NAME, -- a.CUSTOMER_NAME,
a.CHANNEL_CODE,
a.BUDGET_AMOUNT,
a.CURRENCY_CODE,
a.DECISION_TIMEFRAME_CODE,
a.BUDGET_STATUS_CODE,
AMSCT.CAMPAIGN_NAME SOURCE_PROMOTION_NAME,
-- a.SOURCE_PROMOTION_NAME,
a.LEAD_RANK_ID
from as_sales_leads a, -- as_sales_leads_v a
hz_parties party,
AMS_CAMPAIGNS_ALL_B AMSCB,AMS_CAMPAIGNS_ALL_TL AMSCT,
AMS_SOURCE_CODES AMSS
where a.sales_lead_id = IN_SALES_LEAD_ID
and party.party_id = a.customer_id
and AMSS.SOURCE_CODE = AMSCB.SOURCE_CODE(+)
AND AMSCB.CAMPAIGN_ID = AMSCT.CAMPAIGN_ID(+)
and AMSCT.LANGUAGE(+) = USERENV('LANG')
and AMSS.SOURCE_CODE_ID(+) = a.source_promotion_id;
select count(1)
from as_sales_Lead_contacts
where sales_lead_id = IN_SALES_LEAD_ID AND
primary_contact_flag = 'Y';
Select Rank_id
from AS_SALES_LEAD_RANKS_B
where min_score <= IN_SCORE AND
max_score >= IN_SCORE
-- kmahajan 03/26/01 line below added for re-opened Bug 1687132
AND enabled_flag = 'Y';
Select Lead_Rank_ID,
ASSIGN_TO_SALESFORCE_ID,
ASSIGN_TO_PERSON_ID,
ASSIGN_SALES_GROUP_ID,
last_update_date
from AS_SALES_LEADS
Where sales_lead_id = IN_SALES_LEAD_ID;
l_last_update_date DATE;
l_sales_lead_info_contact.LAST_UPDATE_DATE,
l_sales_lead_info_contact.CUSTOMER_NAME,
l_sales_lead_info_contact.CONTACT_ROLE_CODE,
l_sales_lead_info_contact.CHANNEL_CODE,
l_sales_lead_info_contact.BUDGET_AMOUNT,
l_sales_lead_info_contact.CURRENCY_CODE,
l_sales_lead_info_contact.DECISION_TIMEFRAME_CODE,
l_sales_lead_info_contact.BUDGET_STATUS_CODE,
l_sales_lead_info_contact.SOURCE_PROMOTION_NAME,
l_sales_lead_info_contact.LEAD_RANK_ID;
l_LAST_UPDATE_DATE := l_sales_lead_info_contact.LAST_UPDATE_DATE;
l_sales_lead_info.LAST_UPDATE_DATE,
l_sales_lead_info.CUSTOMER_NAME,
l_sales_lead_info.CHANNEL_CODE,
l_sales_lead_info.BUDGET_AMOUNT,
l_sales_lead_info.CURRENCY_CODE,
l_sales_lead_info.DECISION_TIMEFRAME_CODE,
l_sales_lead_info.BUDGET_STATUS_CODE,
l_sales_lead_info.SOURCE_PROMOTION_NAME,
l_sales_lead_info.LEAD_RANK_ID;
l_LAST_UPDATE_DATE := l_sales_lead_info.LAST_UPDATE_DATE;
'LAST_UPDATE_DATE ' || l_LAST_UPDATE_DATE);
l_last_update_date;
l_sales_lead_rec.last_update_date := l_LAST_UPDATE_DATE;
AS_SALES_LEADS_PUB.update_sales_lead(
p_api_version_number => 2.0
,p_init_msg_list => fnd_api.g_false
,p_commit => fnd_api.g_false
,p_validation_level => l_valid_level_full
,p_check_access_flag => p_check_access_flag -- 'Y'
,p_admin_flag => p_admin_flag
,p_admin_group_id => p_admin_group_id
,p_identity_salesforce_id => p_identity_salesforce_id
,p_sales_lead_rec => l_sales_lead_rec
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
);
'update_lead status = ' || l_return_status);