[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT wl.line_code,
wsg.schedule_group_name schedule_group,
NVL(wfs.schedule_group_id,-1),
wfs.primary_item_id,
trunc(wfs.scheduled_completion_date),
sum(nvl(wfs.planned_quantity,0)),
sum(nvl(wfs.quantity_completed,0))
FROM wip_flow_schedules wfs, wip_lines wl, wip_schedule_groups wsg
WHERE wfs.organization_id = p_org_id
AND trunc(wfs.scheduled_completion_date) between trunc(l_week_start_date) and trunc(l_week_start_date+6)
AND wl.line_id = wfs.line_id
AND wl.organization_id = wfs.organization_id
AND (p_line_from IS NULL or (wl.line_code >= p_line_from AND wl.line_code <= p_line_to))
AND wsg.schedule_group_id(+) = wfs.schedule_group_id
AND wsg.organization_id(+) = wfs.organization_id
AND (p_sch_group IS NULL or p_sch_group = wsg.schedule_group_name)
GROUP BY wl.line_code, wsg.schedule_group_name, wfs.schedule_group_id, wfs.primary_item_id,
trunc(wfs.scheduled_completion_date);
INSERT INTO mrp_form_query(
query_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
number15,
date1,
char1,
char2,
number1,
number2,
number3,
number4,
number5,
number6,
number7,
number8,
number9,
number10,
number11,
number12,
number13,
number14 )
VALUES (
p_query_id,
sysdate,
1,
sysdate,
1,
weekly_flow_schedule.item_id,
weekly_flow_schedule.week_start_date,
weekly_flow_schedule.line_code,
weekly_flow_schedule.schedule_group,
weekly_flow_schedule.planned_qty(1),
weekly_flow_schedule.planned_qty(2),
weekly_flow_schedule.planned_qty(3),
weekly_flow_schedule.planned_qty(4),
weekly_flow_schedule.planned_qty(5),
weekly_flow_schedule.planned_qty(6),
weekly_flow_schedule.planned_qty(7),
weekly_flow_schedule.actual_qty(1),
weekly_flow_schedule.actual_qty(2),
weekly_flow_schedule.actual_qty(3),
weekly_flow_schedule.actual_qty(4),
weekly_flow_schedule.actual_qty(5),
weekly_flow_schedule.actual_qty(6),
weekly_flow_schedule.actual_qty(7)
);