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' |