Hi, I have a query which retrieves the WO which have WO status= Released and system status!= rele

select DISC.ORGANIZATION_ID, we.wip_entity_name WO,  we.creation_date, disc.date_released, stat1.system_status_desc, stat2.system_status_desc WO_status

From

APPS.EAM_WORK_ORDER_DETAILS WOD,apps.wip_entities we, APPS.EAM_WO_STATUSES_VL STAT1, APPS.EAM_WO_STATUSES_VL STAT2 ,

     Apps.Wip_Discrete_Jobs Disc

Where Disc.Status_Type != 3

and disc.wip_entity_id = wod.wip_entity_id

And Wod.User_Defined_Status_Id = 3

and DISC.MAINTENANCE_OBJECT_ID is not null

and disc.wip_entity_id = we.wip_entity_id

and disc.organization_id = we.organization_id

and  disc.status_type=stat1.status_id