BOM Routings

Description
Categories: Enginatics, Toolkit - Setup & Support
Repository: Github Columns: Org Name, Org Code, Type, Cfm Routing, Line Code, Item, Item Desc, Alternate, Sequence, Code ...
Master data report showing bill of material routings with item codes and sequences.
select
haouv.name org_name,
mp.organization_code,
xxen_util.meaning(bor.routing_type,'BOM_ASSEMBLY_TYPE',700) type,
decode(bor.cfm_routing_flag,1,'Flow',2,'Discrete Job',bor.cfm_routing_flag) cfm_routing,
wl.line_code,
msiv.concatenated_segments item,
msiv.description item_desc,
bor.alternate_routing_designator alternate,
bos.operation_seq_num sequence,
bso.operation_code code,
bos.operation_description description,
decode(bos.reference_flag,1,'Y') referenced,
bd.department_code department,
bd.description department_desc,
bos.operation_type,
bos.effectivity_date
from
hr_all_organization_units_vl haouv,
mtl_parameters mp,
bom_operational_routings bor,
mtl_system_items_vl msiv,
wip_lines wl,
bom_operation_sequences bos,
bom_standard_operations bso,
bom_departments bd
where
1=1 and
haouv.organization_id=bor.organization_id and
mp.organization_id=bor.organization_id and
bor.assembly_item_id=msiv.inventory_item_id and
bor.organization_id=msiv.organization_id and
bor.line_id=wl.line_id(+) and
bor.organization_id=wl.organization_id(+) and
bor.routing_sequence_id=bos.routing_sequence_id(+) and
bos.department_id=bd.department_id and
bos.standard_operation_id=bso.standard_operation_id(+)
order by
haouv.name,
mp.organization_code,
msiv.concatenated_segments,
bor.alternate_routing_designator nulls first,
bos.operation_seq_num
Parameter Name SQL text Validation
Organization
mp.organization_code=:organization_code
LOV
Item
msiv.concatenated_segments=:item
LOV
Item Description
lower(msiv.description) like lower(:item_descr)