[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select organization_id,sr_instance_id,compile_designator
from msc_plans
where plan_id=p_plan_id;
select nvl(mai.st_status,0)
from msc_apps_instances mai,
msc_coll_parameters mcp
where mai.instance_id = p_plan_inst_id
and mai.instance_id = mcp.instance_id
and nvl(mai.st_status,0) > 0
and ( mai.lrtype in ('C','P')
or ( mai.lrtype in ('T')
and ( ( (nvl(mcp.item,0) = 1 and nvl(mcp.item_sn_flag,0) in (1,4))
or ( nvl(mcp.customer,0) = 1 or nvl(mcp.supplier,0) = 1 ) )))) ;
SELECT msc_form_query_s.nextval
INTO l_query_id
FROM dual;
INSERT INTO msc_form_query(
query_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
number1,
number2,
number3)
VALUES(
l_query_id,
sysdate,
1,
sysdate,
1,
1,
102,
103,
104);
select organization_id,sr_instance_id,compile_designator
from msc_plans
where plan_id=p_plan_id;
select nvl(mai.st_status,0)
from msc_apps_instances mai,
msc_coll_parameters mcp
where mai.instance_id = p_plan_inst_id
and mai.instance_id = mcp.instance_id
and nvl(mai.st_status,0) > 0
and ( mai.lrtype in ('C','P')
or ( mai.lrtype in ('T')
and ( ( (nvl(mcp.item,0) = 1 and nvl(mcp.item_sn_flag,0) in
(1,4))
or ( nvl(mcp.customer,0) = 1 or nvl(mcp.supplier,0) = 1 ) ))
)) ;
SELECT sum(decode(ms.load_type,20,0,1)),
sum(decode(ms.load_type,20,1,0))
FROM msc_supplies ms,
msc_apps_instances mai
where ms.plan_id = pid
and ms.release_errors is null
and ms.load_type is not null
and ms.sr_instance_id = mai.instance_id
and ms.last_updated_by = decode(p_release_by_user,'Y', user_id,
ms.last_updated_by)
and ms.status = 0
and ms.applied =2;
select 1 from dual
where exists ( SELECT /*+ first_rows */ 1
FROM msc_demands md
where md.plan_id = p_plan_id
and md.release_errors is null
and md.load_type =30
and MD.ORIGINATION_TYPE = 30
and md.last_updated_by = decode(p_release_by_user,'Y', user_id,
md.last_updated_by)
and md.status = 0
and md.applied =2
);
SELECT unique sr_instance_id
from MSC_PLAN_ORGANIZATIONS
where plan_id = p_plan_id;
SELECT msc_form_query_s.nextval
INTO l_query_id
FROM dual;
INSERT INTO msc_form_query(
query_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
number1,
number2,
number3,
number4,
number5,
number6,
number7,
number8,
number9,
number12,
char1,
char2,
char3,
char4,
char5,
char6,
char7,
char8,
number17,
number18,
number19,
number20,
char10,
char11)
VALUES(
l_query_id,
sysdate,
1,
sysdate,
1,
1,
loaded_jobs(i) + loaded_lot_jobs(i),
loaded_reqs(i),
loaded_scheds(i),
resched_jobs(i) + resched_lot_jobs(i),
resched_reqs(i),
wip_req_id(i),
po_req_load_id(i),
po_req_resched_id(i),
release_instance(i),
osfm_req_id(i),
loaded_int_reqs(i),
resched_int_reqs(i),
int_req_load_id(i),
int_req_resched_id(i),
loaded_int_repair_orders(i),
int_repair_orders_id(i),
loaded_ext_repair_orders(i),
ext_repair_orders_id(i),
eam_loaded_jobs(i),
eam_loaded_jobs_req_id(i),
resched_cmro_jobs(i),
resched_cmro_jobs_req_id(i),
cmro_loaded_jobs(i),
cmro_loaded_jobs_req_id(i));
INSERT INTO msc_form_query(
query_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
number13,
number11,
number10,
number9)
VALUES(
l_query_id,
sysdate,
1,
sysdate,
1,
1,
p_po_pwb_count(i),
p_po_res_count(i),
p_po_res_id(i),
p_released_inst(i));
INSERT INTO msc_form_query(
query_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
number16,
number15,
number14,
number9)
VALUES(
l_query_id,
sysdate,
1,
sysdate,
1,
1,
p_so_pwb_count(i),
p_so_rel_count(i),
p_so_rel_id(i),
p_so_released_inst(i));
else -- no data is selected for release
p_return_status := 3; -- no data is selected for release
p_return_msg := 'No data has been selected for release, nothing to release';
select decode(apps_ver,3,nvl(allow_release_flag ,2)
,4,nvl(allow_release_flag ,2)
,1) allow_release_flag,
instance_code
from msc_apps_instances
where instance_id = nvl(p_sr_instance_id,-1);
SELECT nvl(postprocessing_lead_time, 0)
FROM msc_system_items
WHERE plan_id = p_plan_id
AND sr_instance_id = p_inst_id
AND ORGANIZATION_ID = p_org_id
AND INVENTORY_ITEM_ID = p_item_id;
SELECT MRP.mrp_atp_schedule_temp_s.nextval
INTO l_session_id
FROM dual;
SELECT employee_id
FROM msc_planners
WHERE planner_code = p_planner_code
AND organization_id = p_org_id
AND sr_instance_id = p_inst_id
AND current_employee_flag = 1;
SELECT employee_id
FROM msc_planners mp,
msc_system_items msi
WHERE mp.planner_code = msi.planner_code
AND mp.organization_id = msi.organization_id
AND mp.sr_instance_id = msi.sr_instance_id
AND mp.current_employee_flag = 1
AND msi.plan_id = p_plan_id
AND msi.organization_id = p_org_id
AND msi.sr_instance_id = p_inst_id
AND msi.inventory_item_id = p_item_id;
SELECT count(1)
FROM msc_trading_partners
WHERE sr_tp_id = p_org_id
AND sr_instance_id = p_inst_id
AND (modeled_customer_id is not null
OR modeled_supplier_id is not null);
SELECT mp.employee_id
FROM msc_planners mp
WHERE mp.planner_code = p_planner_code
AND mp.organization_id = p_org_id
AND mp.sr_instance_id = p_inst_id
AND mp.current_employee_flag = 1;
select mtps.sr_tp_site_id
from msc_trading_partners mtp,
msc_trading_partner_sites mtps
where mtp.sr_tp_id = p_org_id
AND mtp.sr_instance_id = p_inst_id
AND mtp.partner_type =3
AND mtps.partner_id = mtp.partner_id;
select nvl(sales_order_line_split, 2) from msc_demands dem
where dem.demand_id=p_transaction_id
and p_source_table='MSC_DEMANDS'
and dem.plan_id=p_plan_id
and dem.sr_instance_id=p_inst_id
and dem.organization_id=P_org_id;
p_valid := MSC_SELECT_ALL_FOR_RELEASE_PUB.child_supplies_onhand(
p_plan_id, p_transaction_id);
select critical_component_flag
from msc_system_items
where plan_id = arg_plan_id
and inventory_item_id = arg_item_id
and organization_id = arg_org_id
and sr_instance_id = arg_sr_instance_id;
SELECT partner_id
FROM msc_trading_partners
WHERE partner_type = 3
AND sr_tp_id = p_org_id
AND sr_instance_id = p_inst_id;
SELECT s.sr_tp_site_id, s.location
FROM msc_trading_partner_sites s
where s.partner_id = l_partner_id;
select sr_inventory_item_id
from msc_system_items
where plan_id = p_plan_id
and organization_id = p_org_id
and sr_instance_id = p_instance_id
and inventory_item_id = p_item_id;
select profile_value
from msc_plan_profiles
where plan_id=p_plan_id
and profile_code=p_profile_code;