VIEW: APPS.EAM_WORK_ORDER_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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