query
Hello,
assistance for below query
select distinct EWO.WIP_ENTITY_ID,
--WER.WORK_REQUEST_ID,
--WER.WORK_REQUEST_NUMBER,
WOV.OPERATION_SEQ_NUM,WOV.DEPARTMENT_CODE,WOV.DESCRIPTION,
WOR.OPERATION_SEQ_NUM,WOR.RESOURCE_SEQ_NUM,WOR.RESOURCE_CODE,WOR.DEPARTMENT_CODE,---WOR.PURCHASE_ITEM_ID,
EWO.WIP_ENTITY_NAME,
EWO.DESCRIPTION,
EWO.ORGANIZATION_ID,
EWO.CREATION_DATE,
EWO.CREATED_BY,
EWO.ACTUAL_START_DATE,
EWO.ASSET_NUMBER,
EWO.ASSET_DESCRIPTION,
EWO.CLASS_CODE,
EWO.WORK_ORDER_TYPE_DISP,
EWO.SCHEDULED_START_DATE,
EWO.SCHEDULED_COMPLETION_DATE,
EWO.DATE_RELEASED,
EWO.DATE_COMPLETED,
EWO.DATE_CLOSED,
EWO.OWNING_DEPARTMENT_CODE,