[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select count(*)
from fnd_user_resp_groups
where user_id = p_user
and responsibility_id= p_resp
and responsibility_application_id = p_app ;
SELECT count(*)
FROM msc_designators d,
msc_plans p,
msc_item_suppliers mis
WHERE p.organization_id = d.organization_id
AND p.sr_instance_id = d.sr_instance_id
AND p.compile_designator = d.designator
AND p.plan_completion_date IS NOT NULL
AND p.data_completion_date IS NOT NULL
AND p.plan_id <> -1
AND nvl(d.production,2) = 1
AND p.curr_plan_type in (1,2,3)
AND p.plan_id = mis.plan_id
AND p.sr_instance_id = mis.sr_instance_id
AND p.organization_id = mis.organization_id
AND mis.supplier_id = l_supplier_id;
select count(*)
from fnd_user fu,
msc_company_users mcu,
msc_trading_partner_maps map,
msc_company_relationships mcrs,
msc_trading_partners mtp
where fu.user_id = mcu.user_id
and mcu.company_id = mcrs.object_id
and mcrs.subject_id = 1
and mcrs.relationship_type = 2
and mcrs.relationship_id = map.company_key
and map.map_type = 1
and map.tp_key = mtp.modeled_supplier_id
and mtp.partner_type = 3
and fu.user_id = fnd_global.user_id;
select mtp.sr_instance_id, mtp.partner_id
from fnd_user fu,
msc_company_users mcu,
msc_trading_partner_maps map,
msc_company_relationships mcrs,
msc_trading_partners mtp
where fu.user_id = mcu.user_id
and mcu.company_id = mcrs.object_id
and mcrs.subject_id = 1
and mcrs.relationship_type = 2
and mcrs.relationship_id = map.company_key
and map.map_type = 1
and map.tp_key = mtp.partner_id
and fu.user_id = fnd_global.user_id ;