MSC_OPERATION_RES_SEQSRC_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
PLAN_ID ROUTING_SEQUENCE_ID OPERATION_SEQUENCE_ID RESOURCE_SEQ_NUM DEPARTMENT_ID REFRESH_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN CUMMULATIVE_PCT ACTIVITY_GROUP_ID ORGANIZATION_ID

Query

SQL_Statement
select "PLAN_ID","ROUTING_SEQUENCE_ID","OPERATION_SEQUENCE_ID","RESOURCE_SEQ_NUM","DEPARTMENT_ID","REFRESH_NUMBER","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","CUMMULATIVE_PCT","ACTIVITY_GROUP_ID","ORGANIZATION_ID" from msc_operation_resource_seqs as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))