CST_WO_UPDATE_EVENTS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name

CST_WO_UPDATE_EVENT_ID CST_WORK_ORDER_ID EVENT_DATE PRIOR_EVENT_DATE TRANSACTION_DATE PRIOR_TRANSACTION_DATE WORK_ORDER_STATUS_ID WO_SYSTEM_STATUS_CODE PRIOR_WORK_ORDER_STATUS_ID PRIOR_WO_SYSTEM_STATUS_CODE LATEST_STATUS_FLAG REASON PROCESSED_BY_CA_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE INVENTORY_ORGANIZATION_ID

Query

SQL_Statement

SELECT cst_wo_update_event_id, cst_work_order_id, event_date, NVL(lag(event_date, 1) over(partition BY cst_work_order_id order by event_date), to_date('1900-01-01', 'yyyy-mm-dd')) prior_event_date, transaction_date, NVL(lag(transaction_date, 1) over(partition BY cst_work_order_id order by transaction_date), to_date('1900-01-01', 'yyyy-mm-dd')) prior_transaction_date, work_order_status_id, wo_system_status_code, prior_work_order_status_id, prior_wo_system_status_code, latest_status_flag, reason, processed_by_ca_flag, created_by, creation_date, last_updated_by, last_update_date, last_update_login, request_id, job_definition_name, job_definition_package, inventory_organization_id FROM cst_wo_update_events