[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT v.PROFILE_OPTION_VALUE
FROM FND_PROFILE_OPTIONS b, FND_PROFILE_OPTION_VALUES v
WHERE b.APPLICATION_ID=279
AND b.PROFILE_OPTION_NAME=p_name
AND v.PROFILE_OPTION_ID=b.PROFILE_OPTION_ID
AND v.level_id=10001;
SELECT v.PROFILE_OPTION_VALUE
FROM FND_PROFILE_OPTIONS b, FND_PROFILE_OPTION_VALUES v
WHERE b.APPLICATION_ID=690
AND b.PROFILE_OPTION_NAME=p_name
AND v.PROFILE_OPTION_ID=b.PROFILE_OPTION_ID
AND v.level_id=10001;
SELECT nvl(min_win_probability, 0), nvl(max_win_probability, 100)
FROM as_sales_stages_all_b
WHERE sales_stage_id = c_Sales_Stage_Id;
select rtrim(ltrim(value)) from v$parameter
where upper(name) = 'UTL_FILE_DIR';
SELECT OPP.CURRENCY_CODE
FROM AS_LEADS_ALL OPP
WHERE OPP.CURRENCY_CODE NOT IN (
SELECT LOOKUP.LOOKUP_CODE
FROM FND_LOOKUP_VALUES LOOKUP
WHERE LOOKUP.LOOKUP_TYPE = 'REPORTING_CURRENCY'
AND LOOKUP.ENABLED_FLAG = 'Y');
l_mgr_update VARCHAR2(240) := Get_Profile_Site_Value('AS_MGR_UPDATE');
l_admin_update VARCHAR2(240) := Get_Profile_Site_Value('AS_ADMIN_UPDATE');
IF l_mgr_update IS NULL THEN
l_err_num := l_err_num+1;
'): Default value is missing in profile ''OS: Manager Update Access''');
||'''OS: Manager Update Access'' has value <'
||l_mgr_update||'> at site level.');
IF l_admin_update IS NULL THEN
l_err_num := l_err_num+1;
'): Default value is missing in profile ''OS: Sales Admin Update Access''');
||'''OS: Sales Admin Update Access'' has value <'
||l_admin_update||'> at site level.');
SELECT count(*) INTO l_count
FROM AS_CONTACT_FAMILY cf
WHERE not exists
( select aslkp.lookup_code
, arlkp.lookup_code
from AS_LOOKUPS aslkp
,AR_LOOKUPS arlkp
,AS_CONTACT_FAMILY acf
where aslkp.lookup_type = 'CONTACT_RELATION'
and upper(ltrim(rtrim(aslkp.meaning))) =
upper(ltrim(rtrim(acf.relation)))
and arlkp.lookup_type = 'PARTY_RELATIONS_TYPE'
and instr(arlkp.lookup_code , aslkp.lookup_code) > 0
and cf.family_id = acf.family_id );
SELECT count(*) INTO l_count FROM RA_SALESREPS_ALL rrep
WHERE not exists
(select 1 from OE_SALES_CREDIT_TYPES osct
where rrep.sales_credit_type_id = osct.sales_credit_type_id);
SELECT count(*) INTO l_count FROM RA_SALESREPS_ALL
WHERE (start_date_active > end_date_active
AND start_date_active is not null
AND end_date_active is not null)
OR (start_date_active is null
AND end_date_active is not null);
SELECT count(*) INTO l_count FROM (select salesrep_number
from RA_SALESREPS_ALL
group by salesrep_number having count(1) > 1);
SELECT count(*) INTO l_count
FROM AS_SALES_GROUPS a, AS_SALESFORCE b
WHERE a.manager_person_id = b.employee_person_id
and a.manager_salesforce_id <> b.salesforce_id
and b.type = 'EMPLOYEE';
SELECT count(*) INTO l_count
FROM AS_SALES_GRP_ADMIN sga
WHERE not exists
( select 1 from PER_ALL_PEOPLE_F per
where per.person_id = sga.person_id )
and not exists
( select 1 from AS_SALESFORCE sf
where sf.salesforce_id = sga.salesforce_id );
SELECT count(*) INTO l_count
FROM AS_SALES_GRP_ADMIN a, AS_SALESFORCE b
WHERE a.salesforce_id <> b.salesforce_id
and a.person_id = b.employee_person_id
and b.type = 'EMPLOYEE';
SELECT count(*) INTO l_count
FROM AS_SALES_GRP_ADMIN sga
WHERE not exists
( select 1 from AS_SALES_GROUPS sg
where sga.sales_group_id = sg.sales_group_id );
SELECT count(*) INTO l_count
FROM AS_LOOKUPS aslkp
WHERE aslkp.lookup_type = 'TODO'
and not exists
( select 1 from JTF_TASK_TYPES_VL
where upper(rtrim(ltrim(aslkp.meaning))) =
upper(rtrim(ltrim(name))));
SELECT count(*) INTO l_count
FROM AS_LOOKUPS aslkp
WHERE aslkp.lookup_type = 'TODO_PRIORITY'
and not exists
( select 1 from JTF_TASK_PRIORITIES_VL
where upper(rtrim(ltrim(aslkp.meaning))) =
upper(rtrim(ltrim(name))));
SELECT count(*) INTO l_count
FROM AS_LOOKUPS aslkp
WHERE aslkp.lookup_type = 'INTERACTION_TYPE'
and aslkp.lookup_code not in ('MAIL_BLITZ','MAILED_IN_RESPONSE'
,'INBOUND','OUTBOUND','VISIT')
and not exists
( select 1 from FND_LOOKUP_VALUES flv
where flv.lookup_code = aslkp.lookup_code
and flv.lookup_type = 'JTF_MEDIA_TYPE' );
SELECT count(*) INTO l_count
FROM AS_MC_TYPE_MAPPINGS
WHERE PERIOD_SET_NAME=l_fst_calendar;
SELECT count(*) INTO l_count
FROM ASO_I_SALES_CHANNELS_V
WHERE ENABLED_FLAG='Y'
AND NVL(START_DATE_ACTIVE, sysdate) <= sysdate
AND NVL(END_DATE_ACTIVE, sysdate) >= sysdate;
SELECT count(*) INTO l_count
FROM ASO_I_SALES_CREDIT_TYPES_V
WHERE ENABLED_FLAG='Y'
AND QUOTA_FLAG='N';
SELECT count(*) INTO l_count
FROM ASO_I_SALES_CREDIT_TYPES_V
WHERE ENABLED_FLAG='Y'
AND QUOTA_FLAG='Y';
SELECT count(*) INTO l_count
FROM FND_LOOKUP_VALUES
WHERE ENABLED_FLAG = 'Y'
AND LOOKUP_TYPE = 'REPORTING_CURRENCY';
SELECT count(*) INTO l_count
FROM AS_SALES_CREDITS
WHERE (REVENUE_PERCENT IS NOT NULL AND REVENUE_AMOUNT IS NOT NULL)
OR (QUOTA_CREDIT_PERCENT IS NOT NULL AND QUOTA_CREDIT_AMOUNT IS NOT NULL)
OR (REVENUE_PERCENT IS NULL AND REVENUE_AMOUNT IS NULL AND
QUOTA_CREDIT_PERCENT IS NULL AND QUOTA_CREDIT_AMOUNT IS NULL);
SELECT count(*) INTO l_count
FROM as_sales_stages_all_b stg
WHERE not exists (Select 'E' From as_sales_stages_all_b istg
Where istg.name = stg.name
And istg.org_id = 0);
SELECT count(*) INTO l_count
FROM as_forecast_prob_all_b fp
WHERE not exists (Select 'E' From as_forecast_prob_all_b ifp
Where ifp.probability_value = fp.probability_value
And ifp.org_id = 0);
SELECT count(*) INTO l_count
FROM AS_LEADS_ALL
WHERE SALES_STAGE_ID IS NULL
OR DECISION_DATE IS NULL
OR WIN_PROBABILITY IS NULL
OR CHANNEL_CODE IS NULL;
SELECT count(*) INTO l_count
FROM as_fst_sales_categories
WHERE product_category_id is not null
and ROWID NOT IN ( SELECT MIN(ROWID)
FROM as_fst_sales_categories
GROUP BY product_category_id);
SELECT count(*) INTO l_count
FROM as_pe_int_categories
WHERE product_category_id is not null
and ROWID NOT IN ( SELECT MIN(ROWID)
FROM as_pe_int_categories
GROUP BY quota_id, product_category_id );
SELECT count(*) INTO l_count
FROM AS_TERR_TYPE_QUALIFIERS C, AS_TERRITORIES_ALL A
WHERE A.TERRITORY_TYPE_ID = C.TERRITORY_TYPE_ID
AND C.seeded_qualifier_id not in (
select B.seeded_qualifier_id
from AS_TERRITORY_VALUES_ALL B
where A.TERRITORY_ID =B.TERRITORY_ID);