The following lines contain the word 'select', 'insert', 'update' or 'delete':
select ltrim(rtrim(substr(value, instr(value,',',-1,1)+1)))
into DEBUG_LOC_SRC
from v$parameter where name= 'utl_file_dir';
SELECT spid
INTO SPID_SRC
FROM v$process
WHERE addr = (SELECT paddr FROM v$session
WHERE audsid=userenv('SESSIONID'));
SELECT value
INTO TRACE_LOC_SRC
FROM v$parameter
WHERE name = 'user_dump_dest';
select p_session_id ||':'||mrp_atp_schedule_temp_s.nextval
into l_itemkey
from mrp_atp_details_temp
where rownum = 1;
SELECT distinct pl.user_name, p.compile_designator
FROM msc_planners pl,
msc_system_items sys,
msc_plans p
WHERE sys.plan_id = p_plan_id
AND sys.organization_id = p_organization_id
AND sys.sr_instance_id = p_instance_id
AND sys.sr_inventory_item_id = p_inventory_item_id
AND sys.plan_id = p.plan_id
--AND pl.organization_id = sys.organization_id
AND pl.sr_instance_id = sys.sr_instance_id
AND pl.planner_code = sys.planner_code;
SELECT tp.customer_class_code, tp.partner_name,
tps.location, tps.partner_address
INTO l_customer_class, l_customer, l_location, l_address
FROM msc_tp_id_lid tplid,
msc_trading_partners tp,
msc_tp_site_id_lid tpslid,
msc_trading_partner_sites tps
WHERE tplid.sr_tp_id = p_customer_id
AND tplid.sr_instance_id = p_instance_id
AND tplid.partner_type = 2
AND tpslid.sr_tp_site_id = p_customer_site_id
AND tpslid.sr_instance_id = p_instance_id
AND tpslid.partner_type = 2
AND tp.partner_id = tplid.tp_id
AND tps.partner_site_id = tpslid.tp_site_id ;
SELECT distinct pl.user_name, p.compile_designator
FROM msc_planners pl,
msc_system_items sys,
msc_plans p
WHERE sys.plan_id = p_plan_id
AND sys.organization_id = p_organization_id
AND sys.sr_instance_id = p_instance_id
AND sys.sr_inventory_item_id = p_inventory_item_id
AND sys.plan_id = p.plan_id
--AND pl.organization_id = sys.organization_id
AND pl.sr_instance_id = sys.sr_instance_id
AND pl.planner_code = sys.planner_code;
SELECT tp.customer_class_code, tp.partner_name,
tps.location, tps.partner_address
INTO l_customer_class, l_customer, l_location, l_address
FROM msc_tp_id_lid tplid,
msc_trading_partners tp,
msc_tp_site_id_lid tpslid,
msc_trading_partner_sites tps
WHERE tplid.sr_tp_id = p_customer_id
AND tplid.sr_instance_id = p_instance_id
AND tplid.partner_type = 2
AND tpslid.sr_tp_site_id = p_customer_site_id
AND tpslid.sr_instance_id = p_instance_id
AND tpslid.partner_type = 2
AND tp.partner_id = tplid.tp_id
AND tps.partner_site_id = tpslid.tp_site_id ;