Work Order Status query

select 
       we.WIP_ENTITY_NAME work_order_no,
       flv.meaning work_order_status,
       msib.SEGMENT1 item_code,
       msib.DESCRIPTION short_desc,
       msib.ATTRIBUTE4 long_desc ,
       wdj.start_quantity Wo_quantity,
       wdj.QUANTITY_COMPLETED,
       ood.ORGANIZATION_CODE planned_org,
       wdj.COMPLETION_SUBINVENTORY stage
from wip_entities we,
     wip_discrete_jobs wdj,
     fnd_lookup_values flv, 
     mtl_system_items_b msib,
     org_organization_definitions ood
where we.WIP_ENTITY_ID=wdj.WIP_ENTITY_ID
    and we.ORGANIZATION_ID=wdj.ORGANIZATION_ID
    and to_char(wdj.STATUS_TYPE)=flv.LOOKUP_CODE
    and flv.ENABLED_FLAG='Y'
    and wdj.status_type in (4,5,12)
    and wdj.ORGANIZATION_ID in (104)
    and trunc(wdj.CREATION_DATE) between trunc(:p_from) and trunc(:p_to)
    and wdj.PRIMARY_ITEM_ID=msib.INVENTORY_ITEM_ID
    and wdj.ORGANIZATION_ID=msib.ORGANIZATION_ID
    and wdj.ORGANIZATION_ID=ood.ORGANIZATION_ID

--------------------------------------------------------------------

SELECT 
       WE.WIP_ENTITY_NAME WORK_ORDER,
       OOD.ORGANIZATION_CODE ORGANIZATION,
       MSIB.SEGMENT1 PRIMARY_ITEM,
       WDJ.CREATION_DATE WO_CREATION_DTAE,
       WDJ.STATUS_TYPE_DISP WO_STATUS,
       WOV.OPERATION_SEQ_NUM ,
       WOV.DEPARTMENT_CODE DEPARTMENT
FROM WIP_ENTITIES WE,
WIP_DISCRETE_JOBS_V WDJ,
WIP_OPERATIONS_V WOV,
ORG_ORGANIZATION_DEFINITIONS OOD,
MTL_SYSTEM_ITEMS_B MSIB
WHERE 1=1
--AND WE.WIP_ENTITY_NAME='2035608'
AND WE.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
AND WE.ORGANIZATION_ID=WDJ.ORGANIZATION_ID
AND WE.WIP_ENTITY_ID=WOV.WIP_ENTITY_ID
AND WE.ORGANIZATION_ID=WOV.ORGANIZATION_ID
AND WE.ORGANIZATION_ID=OOD.ORGANIZATION_ID
AND WE.PRIMARY_ITEM_ID=MSIB.INVENTORY_ITEM_ID
AND WE.ORGANIZATION_ID=MSIB.ORGANIZATION_ID
AND WDJ.STATUS_TYPE_DISP='Released'
AND WOV.DEPARTMENT_CODE='OSP'
AND TRUNC(WE.CREATION_DATE)<TRUNC(:P_DATE)

order by 1