select 
wdj.ORGANIZATION_ID AS "ORG",
WE.WIP_ENTITY_NAME "JOB",
(ASSY.SEGMENT1||'-'||ASSY.SEGMENT2||'-'||ASSY.SEGMENT3) AS "ASSEMBLY",
ASSY.DESCRIPTION AS "ASSEMBLY DESC",
paa.NAME||'.'||pat.TASK_NUMBER as "PROJECT",
ML1.MEANING STATUS,
WDJ.DATE_RELEASED,
WE.CREATION_DATE,
ROUND(SYSDATE - WE.CREATION_DATE) AS AGING,
ROUND(SYSDATE - WE.CREATION_DATE) AS AGING2,
WDJ.ATTRIBUTE1 AS "REMARKS",
WDJ.ATTRIBUTE2 AS "SO NUM", 
WDJ.ATTRIBUTE3 AS "S0 LN"
from
WIP_ENTITIES WE,
MFG_LOOKUPS ML1,
MTL_SYSTEM_ITEMS ASSY,
WIP_DISCRETE_JOBS WDJ,
PA_PROJECTS_ALL PAA,
PA_TASKS PAT
Where ML1.LOOKUP_TYPE = 'WIP_JOB_STATUS'
and we.ORGANIZATION_ID = wdj.ORGANIZATION_ID
and we.WIP_ENTITY_ID = wdj.WIP_ENTITY_ID
AND ML1.LOOKUP_CODE = WDJ.STATUS_TYPE
AND WE.PRIMARY_ITEM_ID = ASSY.INVENTORY_ITEM_ID
AND WE.ORGANIZATION_ID = ASSY.ORGANIZATION_ID
and wdj.PROJECT_ID = paa.PROJECT_ID
and wdj.TASK_ID = pat.TASK_ID
and wdj.ORGANIZATION_ID not in (124,125,126,127,101,128,106,105,135,109,108,110,102,103,111,112)
and WDJ.STATUS_TYPE not in (4,5,7,12,14,15)
group by 
WE.WIP_ENTITY_NAME,
(ASSY.SEGMENT1||'-'||ASSY.SEGMENT2||'-'||ASSY.SEGMENT3),
ASSY.DESCRIPTION,
ML1.MEANING,
WDJ.DATE_RELEASED,
WE.CREATION_DATE,
ROUND(SYSDATE - WE.CREATION_DATE),
wdj.ORGANIZATION_ID,
WDJ.ATTRIBUTE1,
WDJ.ATTRIBUTE2, 
WDJ.ATTRIBUTE3,
paa.NAME,
pat.TASK_NUMBER
order by wdj.ORGANIZATION_ID asc, (ASSY.SEGMENT1||'-'||ASSY.SEGMENT2||'-'||ASSY.SEGMENT3) asc;/*--============ table fields listing===============
--
--1= unreleased 
--3= released 
--4= complete 
--5= complete- No Charges 
--6= On hold 
--7= cancelled
--8= pending Bill Load 
--9= failed bill load 
--10=Pending routing load 
--11=Failed routing load 
--12=Closed 
--13=Pending-Mass Loaded
--14=Pending Close 
--15=Failed Close 
--16=Pending Scheduling 
--================================================================