Reports2017-11-18T12:27:27+00:00

INV Safety Stocks

Description
Categories: Enginatics, Logistics, Manufacturing
Inventory safety stocks

select
haou.name organization,
mp.organization_code,
msiv.concatenated_segments item,
msiv.description,
ppa.project_number project,
pt.task_number,
mss.effectivity_date,
muot.unit_of_measure_tl uom,
msiv.primary_uom_code,
mss.safety_stock_quantity quantity,
xxen_util.meaning(mss.safety_stock_code,'MTL_SAFETY_STOCK',700) safety_stock_method,
mss.forecast_designator forecast,
mss.safety_stock_percent,
mss.service_level,
xxen_util.user_name(mss.created_by) created_by,
xxen_util.client_time(mss.creation_date) creation_date,
xxen_util.user_name(mss.last_updated_by) last_updated_by,
xxen_util.client_time(mss.last_update_date) last_update_date
from
hr_all_organization_units haou,
mtl_parameters mp,
mtl_safety_stocks mss,
mtl_system_items_vl msiv,
mtl_units_of_measure_tl muot,
(
select ppa.project_id, ppa.segment1 project_number from pa_projects_all ppa union
select psm.project_id, psm.project_number from pjm_seiban_numbers psm
) ppa,
pa_tasks pt
where
1=1 and
haou.organization_id=mss.organization_id and
mp.organization_id=mss.organization_id and
mss.organization_id=msiv.organization_id and
mss.inventory_item_id=msiv.inventory_item_id and
msiv.primary_uom_code=muot.uom_code and
muot.language=userenv('lang') and
mss.project_id=ppa.project_id(+) and
mss.task_id=pt.task_id(+)
order by
mp.organization_code,
msiv.concatenated_segments

Parameter Name SQL text Validation
Organization Code
mp.organization_code=:organization_code
LOV
Item
msiv.concatenated_segments like :item
LOV

By continuing to use the site, you agree to the use of cookies. Accept