MSC_OPERATION_RESOURCESRC

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
PLAN_ID ROUTING_SEQUENCE_ID OPERATION_SEQUENCE_ID RESOURCE_SEQ_NUM RESOURCE_ID ALTERNATE_NUMBER PRINCIPAL_FLAG BASIS_TYPE RESOURCE_USAGE MAX_RESOURCE_UNITS RESOURCE_UNITS UOM_CODE REFRESH_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 RESOURCE_TYPE ORGANIZATION_ID SETUP_ID MINIMUM_CAPACITY MAXIMUM_CAPACITY ORIG_RESOURCE_SEQ_NUM BREAKABLE_ACTIVITY_FLAG

Name

PLAN_ID

ROUTING_SEQUENCE_ID

OPERATION_SEQUENCE_ID

RESOURCE_SEQ_NUM

RESOURCE_ID

ALTERNATE_NUMBER

PRINCIPAL_FLAG

BASIS_TYPE

RESOURCE_USAGE

MAX_RESOURCE_UNITS

RESOURCE_UNITS

UOM_CODE

REFRESH_NUMBER

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

RESOURCE_TYPE

ORGANIZATION_ID

SETUP_ID

MINIMUM_CAPACITY

MAXIMUM_CAPACITY

ORIG_RESOURCE_SEQ_NUM

BREAKABLE_ACTIVITY_FLAG

Query

SQL_Statement
select "PLAN_ID","ROUTING_SEQUENCE_ID","OPERATION_SEQUENCE_ID","RESOURCE_SEQ_NUM","RESOURCE_ID","ALTERNATE_NUMBER","PRINCIPAL_FLAG","BASIS_TYPE","RESOURCE_USAGE","MAX_RESOURCE_UNITS","RESOURCE_UNITS","UOM_CODE","REFRESH_NUMBER","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","RESOURCE_TYPE","ORGANIZATION_ID","SETUP_ID","MINIMUM_CAPACITY","MAXIMUM_CAPACITY","ORIG_RESOURCE_SEQ_NUM","BREAKABLE_ACTIVITY_FLAG" from msc_operation_resources as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))

SQL_Statement

select "PLAN_ID","ROUTING_SEQUENCE_ID","OPERATION_SEQUENCE_ID","RESOURCE_SEQ_NUM","RESOURCE_ID","ALTERNATE_NUMBER","PRINCIPAL_FLAG","BASIS_TYPE","RESOURCE_USAGE","MAX_RESOURCE_UNITS","RESOURCE_UNITS","UOM_CODE","REFRESH_NUMBER","LAST_UPDATE_DATE","LAST_UPDATED_BY","CREATION_DATE","CREATED_BY","LAST_UPDATE_LOGIN","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","RESOURCE_TYPE","ORGANIZATION_ID","SETUP_ID","MINIMUM_CAPACITY","MAXIMUM_CAPACITY","ORIG_RESOURCE_SEQ_NUM","BREAKABLE_ACTIVITY_FLAG" from msc_operation_resources as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))