WIS_COMMON_WD_OPERATIONS_V

Details

• Schema: FUSION

• Object owner: WIS

• Object type: VIEW

Columns

Name
WD_OPERATION_ID OPERATION_SEQ_NUMBER WORK_DEFINITION_ID VERSION_NUMBER

Query

SQL_Statement

SELECT wdo.wd_operation_id, wdo.operation_seq_number, wdo.work_definition_id, wdv.version_number FROM wis_wd_operations_b wdo, wis_wd_versions wdv WHERE wdv.work_definition_id = wdo.work_definition_id AND wdv.effective_from_date between wdo.effective_from_date and nvl(wdo.effective_to_date, wdv.effective_from_date) AND (systimestamp between wdv.effective_from_date and nvl(wdv.effective_to_date,sysdate+1) OR wdv.effective_from_date >= systimestamp) AND wdo.referenced_flag = 'N'