Product: | EAM - Enterprise Asset Management |
---|---|
Description: | View based on the table eam_work_order_details to display user defined statuses based on pending flag and also displays material shortage description |
Implementation/DBA Data: | APPS.EAM_WORK_ORDER_DETAILS_V |
SELECT EWOD.ROWID
, EWOD.WIP_ENTITY_ID
, EWOD.ORGANIZATION_ID
, EWOD.USER_DEFINED_STATUS_ID
, EWOD.PENDING_FLAG
, EWOD.MATERIAL_SHORTAGE_CHECK_DATE
, EWOD.MATERIAL_SHORTAGE_FLAG
, ML.MEANING AS MATERIAL_SHORTAGE_DISP
, EWOD.WORKFLOW_TYPE
, EWOD.WARRANTY_CLAIM_STATUS
, EWOD.CYCLE_ID
, EWOD.SEQ_ID
, EWOD.DS_SCHEDULED_FLAG
, EWOD.REQUEST_ID
, EWOD.PROGRAM_ID
, EWOD.PROGRAM_APPLICATION_ID
, EWOD.LAST_UPDATE_DATE
, EWOD.LAST_UPDATED_BY
, EWOD.CREATION_DATE
, EWOD.CREATED_BY
, EWOD.LAST_UPDATE_LOGIN
, EWSV.WORK_ORDER_STATUS
, DECODE(EWOD.PENDING_FLAG
, 'Y'
, EWSV.WORK_ORDER_STATUS || ' - ' || FND_MESSAGE.GET_STRING('EAM'
, 'EAM_PENDING_TEXT')
, EWSV.WORK_ORDER_STATUS)
, EWOD.PM_SUGGESTED_START_DATE
, EWOD.PM_SUGGESTED_END_DATE
, EWOD.FAILURE_CODE_REQUIRED
, EWOD.WARRANTY_ACTIVE
, ECE.ESTIMATE_ID
, ECE.ESTIMATE_NUMBER
FROM EAM_WORK_ORDER_DETAILS EWOD
, EAM_WO_STATUSES_V EWSV
, MFG_LOOKUPS ML
, EAM_CONSTRUCTION_ESTIMATES ECE
WHERE EWSV.STATUS_ID = EWOD.USER_DEFINED_STATUS_ID
AND ML.ENABLED_FLAG(+) = 'Y'
AND ML.LOOKUP_TYPE(+) ='EAM_MATERIAL_SHORTAGE'
AND EWOD.MATERIAL_SHORTAGE_FLAG = ML.LOOKUP_CODE(+)
AND ECE.ESTIMATE_ID(+) = EWOD.ESTIMATE_ID