BOM QUERY

SELECT
MSI.SEGMENT1||'.'||MSI.SEGMENT2 STYLE,MSI.SEGMENT2,MSI.CREATION_DATE,BOR.ASSEMBLY_ITEM_ID,MSI.INVENTORY_ITEM_ID ITEMID,BOS.DEPARTMENT_ID,BD.DEPARTMENT_CODE
,BR.RESOURCE_SEQ_NUM,BRS.RESOURCE_CODE,BR.USAGE_RATE_OR_AMOUNT,
BR.USAGE_RATE_OR_AMOUNT_INVERSE,
BOR.routing_sequence_id , BOS.operation_seq_num,-- BR.resource_seq_num,
--BRS.resource_code ,
BR.assigned_units, BR.basis_type,BR.schedule_flag,to_char(BOS.effectivity_date,'DD-MON-YYYY HH24:MI:SS') edate--BOS.effectivity_date--,BR.USAGE_RATE_OR_AMOUNT_INVERSE
    
    FROM BOM_OPERATIONAL_ROUTINGS BOR,
    BOM_OPERATION_SEQUENCES BOS,
    BOM_DEPARTMENTS BD,
    BOM_OPERATION_RESOURCES BR,
    BOM_RESOURCES BRS,
    BOM_STANDARD_OPERATIONS BSO,
    BOM_BILL_OF_MATERIALS BOM,
    BOM_INVENTORY_COMPONENTS BIC
  
   
    WHERE BOM.ASSEMBLY_ITEM_ID=22445
    AND BOR.ORGANIZATION_ID=42
    AND BOR.ASSEMBLY_ITEM_ID = BOM.ASSEMBLY_ITEM_ID
    AND BOM.ORGANIZATION_ID = BOR.ORGANIZATION_ID
    AND BOM.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
    and bos.ROUTING_SEQUENCE_ID = bor.ROUTING_SEQUENCE_ID
    AND BOS.STANDARD_OPERATION_ID=BSO.STANDARD_OPERATION_ID
    AND BOS.DISABLE_DATE is null
    AND BD.DEPARTMENT_ID = BOS.DEPARTMENT_ID
    AND BRS.ORGANIZATION_ID=BOR.ORGANIZATION_ID
    AND BRS.ORGANIZATION_ID=BOM.ORGANIZATION_ID
    AND BD.ORGANIZATION_ID = BRS.ORGANIZATION_ID
    AND BOS.OPERATION_SEQUENCE_ID  = BR.OPERATION_SEQUENCE_ID
    AND BR.RESOURCE_ID  = BRS.RESOURCE_ID;