Introduction:
Routing is a set of operations that will be performed in sequence to manufacture an assembly Item.
The below query will give the operation sequence details.
Query to fetch Routing Details:
SELECT
msi.concatenated_segments item,
br.description,
br.uom,
bs.operation_seq_num,
bs.department_code,
bor.resource_seq_num,
bor.resource_code resource_code,
bor.uom,
bor.usage_rate_or_amount usage,
bor.usage_rate_or_amount_inverse inverse,
bor.activity,
decode(bor.schedule_flag,4,’Next’,1,’Yes’,2,’No’,3,’Prior’,’NA’) Schedule
FROM
apps.bom_operational_routings_v br,
apps.mtl_system_items_kfv msi,
apps.bom_operation_sequences_v bs,
apps.bom_operation_resources_v bor
WHERE
br.organization_id = <org_id>
AND br.organization_id = msi.organization_id
AND msi.inventory_item_id = br.assembly_item_id
AND bs.routing_sequence_id = br.routing_sequence_id
AND bs.disable_date IS NULL
AND bor.operation_sequence_id = bs.operation_sequence_id
ORDER BY
br.routing_sequence_id
