[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select project_id, task_id into l_project_id, l_task_id
from wip_discrete_jobs
where wip_entity_id = p_wip_entity_id;
select sum(quantity_detailed) into l_partial_qty
from mtl_txn_request_lines
where header_id = (select header_id from mtl_txn_request_headers
where request_number = x_request_number
and organization_id = p_organization_id);
select we.wip_entity_id,
we.wip_entity_name,
wro.OPERATION_SEQ_NUM,
wro.INVENTORY_ITEM_ID,
wdj.project_id,
wdj.task_id,
wro.date_required date_required,
(wro.required_quantity - wro.quantity_issued
- nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)
- Nvl(wo.CUMULATIVE_SCRAP_QUANTITY*wro.QUANTITY_PER_ASSEMBLY,0) ) AS requested_quantity
from wip_entities we,
wip_discrete_jobs wdj,
wip_parameters wp,
wip_requirement_operations wro,
wip_operations wo,
mtl_system_items msi
where we.wip_entity_id = wdj.wip_entity_id
and we.organization_id = wdj.organization_id
and wp.organization_id = wdj.organization_id
and wp.organization_id = we.organization_id
AND we.wip_entity_id = wo.wip_entity_id
and wro.organization_id = wo.organization_id
and wro.wip_entity_id = wo.wip_entity_id
and wro.operation_seq_num = wo.operation_seq_num
AND wro.inventory_item_id = msi.inventory_item_id
AND wro.organization_id = msi.organization_id
AND msi.INVENTORY_ITEM_FLAG LIKE 'Y'
and we.entity_type = 6 --only for non-closed workorders
and wdj.status_type = 3
AND wro.AUTO_REQUEST_MATERIAL = l_auto_req_param
--and wdj.MATERIAL_ISSUE_BY_MO LIKE 'Y' --only for workorders that have Enable Material Request as Yes
and we.organization_id = p_organization_id
and (wo.count_point_type in (1,2) or wo.count_point_type is null)
and wro.required_quantity > (wro.quantity_issued +
nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)+ Nvl(wo.CUMULATIVE_SCRAP_QUANTITY*wro.QUANTITY_PER_ASSEMBLY,0))
and wro.date_required < sysdate + p_days_forward
order by date_required, we.wip_entity_id;
select 1
from wip_requirement_operations wro,
wip_operations wo
where we.wip_entity_id = wro.wip_entity_id
and we.organization_id = wro.organization_id
and wro.wip_entity_id = wo.wip_entity_id(+)
and wro.operation_seq_num = wo.operation_seq_num(+)
and (wo.count_point_type in (1,2) or wo.count_point_type is null)
and wro.required_quantity > (wro.quantity_issued +
nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)+ Nvl(wo.CUMULATIVE_SCRAP_QUANTITY*wro.QUANTITY_PER_ASSEMBLY,0))
and wro.date_required < sysdate + p_days_forward)
order by date_required, we.wip_entity_id;
select meaning
into l_outBuffer
from mfg_lookups
where lookup_type = 'SYS_YES_NO'
and lookup_code = p_use_pickset_indicator;
select meaning
into l_outBuffer
from mfg_lookups
where lookup_type = 'SYS_YES_NO'
and lookup_code = p_print_pickslips;
select name
into l_outBuffer
from wsh_pick_grouping_rules
where pick_grouping_rule_id = p_pick_grouping_rule_id;
select meaning
into l_outBuffer
from mfg_lookups
where lookup_type = 'SYS_YES_NO'
and lookup_code = p_plan_tasks;
select organization_code
into l_outBuffer
from MTL_PARAMETERS
where organization_id = p_organization_id;
select meaning
into l_outBuffer
from mfg_lookups
where lookup_type = 'WIP_ENTITY'
and lookup_code = p_wip_entity_type;
select meaning
into l_outBuffer
from mfg_lookups
where lookup_type = 'WIP_ENTITIES'
and lookup_code = p_job_type ;