BOM Routings Query

SELECT MSI.SEGMENT1 ITEM_NAME,
MSI.DESCRIPTION,
MSI.primary_uom_code uom,
MIRB.REVISION,
BOR.CREATION_DATE START_DATE,
-------------------------
----------------------------
 bos.operation_seq_num,
  bd.department_code,
  DECODE (bos.count_point_type, 1, 1, 2) count_point_flag
FROM BOM_OPERATIONAL_ROUTINGS BOR,
MTL_SYSTEM_ITEMS MSI,
MTL_ITEM_REVISIONS_B MIRB,
----------------------
 bom_operation_sequences bos,
  bom_departments bd
WHERE BOR.ASSEMBLY_ITEM_ID='222955'
AND bor.assembly_item_id = MSI.inventory_item_id
AND bor.organization_id = MSI.organization_id
-----------------------------------------------
AND BOR.ASSEMBLY_ITEM_ID=MIRB.INVENTORY_ITEM_ID
AND BOR.ORGANIZATION_ID=MIRB.ORGANIZATION_ID
-----------------------------------------
AND BOR.ROUTING_SEQUENCE_ID=BOS.ROUTING_SEQUENCE_ID
AND bos.department_id = bd.department_id