WIP Query

SELECT   we.wip_entity_name job, ood.organization_name organization_name,
         msib1.segment1 fg_item,
         (SELECT stragg (DISTINCT c.item_cost)
            FROM apps.cst_item_costs c
           WHERE c.inventory_item_id = msib1.inventory_item_id
             AND c.organization_id = msib1.organization_id
             ) fg_cost,
         wro.operation_seq_num operation, bso.operation_code,
         bso.operation_description, wro.quantity_issued qty_completed,
         msib.segment1 rm_item, msib.description rm_desc,
         cic.item_cost rm_cost,
         (wro.quantity_issued * cic.item_cost) consumed_rm_cost
    FROM apps.wip_entities we,
         apps.org_organization_definitions ood,
         apps.wip_requirement_operations wro,
         apps.mtl_system_items_b msib,
         apps.mtl_system_items_b msib1,
         apps.cst_item_costs cic,
         apps.wip_operations wo,
         apps.bom_standard_operations bso
   WHERE 1 = 1
     AND we.organization_id = ood.organization_id
     AND wro.wip_entity_id = we.wip_entity_id
     AND wro.organization_id = we.organization_id
     AND msib.inventory_item_id = wro.inventory_item_id
     AND msib.organization_id = wro.organization_id
     AND msib1.inventory_item_id = we.primary_item_id
     AND msib1.organization_id = we.organization_id
     AND cic.inventory_item_id = msib.inventory_item_id
     AND cic.organization_id = msib.organization_id
     AND bso.standard_operation_id(+) = wo.standard_operation_id
     AND wo.wip_entity_id = wro.wip_entity_id
     AND we.wip_entity_name = NVL (:p_job, we.wip_entity_name)
     AND ood.organization_id = NVL (:orga, ood.organization_id)
ORDER BY wro.operation_seq_num