[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select bso.operation_code,
bd.department_code,
wo.department_id,
wo.previous_operation_seq_num,
wo.next_operation_seq_num
into p_operation_code,
p_department_code,
p_department_id,
p_prev_op_seq_num,
p_next_op_seq_num
from bom_standard_operations bso,
bom_departments bd,
wip_operations wo
where wo.organization_id = p_org_id
/* %cfm Ignore cfm ops. */
and nvl(bso.operation_type, 1) = 1
and bso.line_id is null
/* %/cfm */
and wo.wip_entity_id = p_wip_entity_id
and wo.operation_seq_num = p_operation_seq_num
and (wo.repetitive_schedule_id is null
or
wo.repetitive_schedule_id = p_first_schedule_id)
and bso.organization_id (+) = wo.organization_id
and bso.standard_operation_id (+) = wo.standard_operation_id
and bd.organization_id = wo.organization_id
and bd.department_id = wo.department_id;
select max(wo1.operation_seq_num),
min(wo2.operation_seq_num)
into p_prev_op_seq_num,
p_next_op_seq_num
from dual sd,
wip_operations wo1,
wip_operations wo2
where wo1.organization_id(+) = p_org_id
and wo1.wip_entity_id(+) = decode(1, 1, p_wip_entity_id, sd.dummy)
and wo1.operation_seq_num(+) < p_operation_seq_num
and wo2.organization_id(+) = p_org_id
and wo2.wip_entity_id(+) = decode(1, 1, p_wip_entity_id, sd.dummy)
and wo2.operation_seq_num(+) > p_operation_seq_num;
select distinct
wo.operation_seq_num,
bso.operation_code,
wo.department_id,
bd.department_code,
wo.minimum_transfer_quantity,
wo.quantity_waiting_to_move,
WIP_CONSTANTS.YES allow_moves
from bom_standard_operations bso,
bom_departments bd,
wip_operations wo
where wo.operation_seq_num =
(select max(operation_seq_num)
from wip_operations wo1
where wo1.organization_id = wo.organization_id
and wo1.wip_entity_id = wo.wip_entity_id
and (wo1.repetitive_schedule_id is NULL
or
wo1.repetitive_schedule_id = c_first_schedule_id))
/* %cfm Ignore cfm ops. */
and nvl(bso.operation_type, 1) = 1
and bso.line_id is null
/* %/cfm */
and wo.department_id = bd.department_id
and wo.standard_operation_id = bso.standard_operation_id (+)
and wo.organization_id = c_org_id
and wo.wip_entity_id = c_wip_entity_id
and (wo.repetitive_schedule_id is NULL
or
wo.repetitive_schedule_id = c_first_schedule_id)
and not exists
(select 'No move status exists'
from wip_shop_floor_statuses ws,
wip_shop_floor_status_codes wsc
where wsc.organization_id = wo.organization_id
and ws.organization_id = wo.organization_id
and ws.wip_entity_id = wo.wip_entity_id
and (ws.line_id is NULL
or
ws.line_id = c_line_id)
and ws.operation_seq_num = wo.operation_seq_num
and ws.intraoperation_step_type = WIP_CONSTANTS.TOMOVE
and ws.shop_floor_status_code = wsc.shop_floor_status_code
and wsc.status_move_flag = WIP_CONSTANTS.NO
and nvl(wsc.disable_date, SYSDATE + 1) > SYSDATE);
select distinct
wo.operation_seq_num,
bso.operation_code,
wo.department_id,
bd.department_code,
wo.minimum_transfer_quantity,
wo.quantity_waiting_to_move,
WIP_CONSTANTS.NO allow_moves
from bom_standard_operations bso,
bom_departments bd,
wip_operations wo
where wo.operation_seq_num =
(select max(operation_seq_num)
from wip_operations wo1
where wo1.organization_id = wo.organization_id
and wo1.wip_entity_id = wo.wip_entity_id
and (wo1.repetitive_schedule_id is NULL
or
wo1.repetitive_schedule_id = c_first_schedule_id))
/* %cfm Ignore cfm ops. */
and nvl(bso.operation_type, 1) = 1
and bso.line_id is null
/* %/cfm */
and wo.department_id = bd.department_id
and wo.standard_operation_id = bso.standard_operation_id (+)
and wo.organization_id = c_org_id
and wo.wip_entity_id = c_wip_entity_id
and (wo.repetitive_schedule_id is NULL
or
wo.repetitive_schedule_id = c_first_schedule_id)
and exists
(select 'Move status exists'
from wip_shop_floor_statuses ws,
wip_shop_floor_status_codes wsc
where wsc.organization_id = wo.organization_id
and ws.organization_id = wo.organization_id
and ws.wip_entity_id = wo.wip_entity_id
and (ws.line_id is NULL
or
ws.line_id = c_line_id)
and ws.operation_seq_num = wo.operation_seq_num
and ws.intraoperation_step_type = WIP_CONSTANTS.TOMOVE
and ws.shop_floor_status_code = wsc.shop_floor_status_code
and wsc.status_move_flag = WIP_CONSTANTS.NO
and nvl(wsc.disable_date, SYSDATE + 1) > SYSDATE);
select distinct
wo.operation_seq_num,
bso.operation_code,
wo.department_id,
bd.department_code
from bom_standard_operations bso,
bom_departments bd,
wip_operations wo
where wo.operation_seq_num =
(select min(operation_seq_num)
from wip_operations wo1
where wo1.organization_id = wo.organization_id
and wo1.wip_entity_id = wo.wip_entity_id
and (wo1.repetitive_schedule_id is NULL
or
wo1.repetitive_schedule_id = c_first_schedule_id))
/* %cfm Ignore cfm ops. */
and nvl(bso.operation_type, 1) = 1
and bso.line_id is null
/* %/cfm */
and wo.department_id = bd.department_id
and wo.standard_operation_id = bso.standard_operation_id (+)
and wo.organization_id = c_org_id
and wo.wip_entity_id = c_wip_entity_id
and (wo.repetitive_schedule_id is NULL
or
wo.repetitive_schedule_id = c_first_schedule_id);