SELECT WWOB.WORK_ORDER_NUMBER WO_NUMBER
,WWOT.WORK_ORDER_DESCRIPTION WO_DESCRIPTION
,WWST.WO_STATUS_NAME WO_STATUS
,HOU.NAME ORG_NAME
,CASE
WHEN ROW_NUMBER() OVER (PARTITION BY HOU.NAME ORDER BY HOU.NAME) = 1
THEN HOU.NAME
ELSE NULL
END AS ORG_PARAMETER,
CASE
WHEN ROW_NUMBER() OVER (PARTITION BY HOU.NAME ORDER BY HOU.NAME) = 1
THEN TO_CHAR(SYSDATE,’MM-DD-YYYY HH24:MI:SS’,’NLS_DATE_LANGUAGE=ENGLISH’)
ELSE NULL
END AS EXECUTION_DATE,
ITEM.ITEM_NUMBER,
ITEM_TL.DESCRIPTION AS ITEM_DESCRIPTION
FROM WIE_WORK_ORDERS_B WWOB
,WIE_WORK_ORDERS_TL WWOT
,WIE_WO_STATUSES_TL WWST
,HR_ALL_ORGANIZATION_UNITS_X HOU
,EGP_SYSTEM_ITEMS_B ITEM
,EGP_SYSTEM_ITEMS_TL ITEM_TL
WHERE 1=1
AND WWOB.WORK_ORDER_ID=WWOT.WORK_ORDER_ID
AND WWOB.WORK_ORDER_STATUS_ID=WWST.WO_STATUS_ID
AND WWST.LANGUAGE = USERENV(‘LANG’)
AND WWOB.ORGANIZATION_ID=HOU.ORGANIZATION_ID
AND WWOB.PJC_PROJECT_NUMBER IS NULL
AND WWST.WO_STATUS_NAME<>’Canceled’
AND WWOB.INVENTORY_ITEM_ID=ITEM.INVENTORY_ITEM_ID
AND WWOB.ORGANIZATION_ID=ITEM.ORGANIZATION_ID
AND WWOB.INVENTORY_ITEM_ID=ITEM_TL.INVENTORY_ITEM_ID
AND WWOB.ORGANIZATION_ID=ITEM_TL.ORGANIZATION_ID
ORDER BY ORG_NAME
Recent Posts