Enterprise Asset Management - EBS (MOSC)

MOSC Banner

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center