`Query to findout the cancelled WIP Jobs

select
hou.name "OPERATING_UNIT",
ood.ORGANIZATION_CODE,
wdj.WIP_ENTITY_NAME "JOB",
wdj.JOB_TYPE_MEANING "JOB_TYPE", 
msi.segment1 "ASSEMBLY",
msi.DESCRIPTION "ASSEMBLY_DESCRIPTION",
wdj.CLASS_CODE,
wdj.NET_QUANTITY,
wdj.STATUS_TYPE_DISP,
wdj.ATTRIBUTE_CATEGORY "CONTEXT",
wdj.ATTRIBUTE1 "SCHEDULE_GROUP",
wdj.ATTRIBUTE2 "PRODUCTION_LINE",
wdj.ATTRIBUTE3 "Printed",
wdj.ATTRIBUTE10 "SALES_ORDER",
wdj.ATTRIBUTE11 "SALES_ORDER",
wdj.ATTRIBUTE12 "CUSTOMER_NAME",
wdj.ATTRIBUTE15 "ENVS_OPEN_QUANTITY"
 from WIP_DISCRETE_JOBS_V wdj,
 mtl_system_items_b msi,
 org_organization_definitions ood,
 hr_operating_units hou
  where wdj.PRIMARY_ITEM_ID  = msi.INVENTORY_ITEM_ID
  and wdj.ORGANIZATION_ID = msi.ORGANIZATION_ID
  and wdj.ORGANIZATION_ID = ood.ORGANIZATION_ID
  and msi.ORGANIZATION_ID = ood.ORGANIZATION_ID
   and ood.OPERATING_UNIT = hou.ORGANIZATION_ID
 -- and wdj.WIP_ENTITY_NAME ='100476'    
  and wdj.STATUS_TYPE =7