MSC_NET_RESOURCE_AVAILRC

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
TRANSACTION_ID PARENT_ID PLAN_ID ORGANIZATION_ID RESOURCE_ID DEPARTMENT_ID SIMULATION_SET SHIFT_NUM SHIFT_DATE FROM_TIME TO_TIME CAPACITY_UNITS AGGREGATE_RESOURCE_ID STATUS APPLIED UPDATED 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 REFRESH_NUMBER

Name

TRANSACTION_ID

PARENT_ID

PLAN_ID

ORGANIZATION_ID

RESOURCE_ID

DEPARTMENT_ID

SIMULATION_SET

SHIFT_NUM

SHIFT_DATE

FROM_TIME

TO_TIME

CAPACITY_UNITS

AGGREGATE_RESOURCE_ID

STATUS

APPLIED

UPDATED

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

REFRESH_NUMBER

Query

SQL_Statement
select "TRANSACTION_ID","PARENT_ID","PLAN_ID","ORGANIZATION_ID","RESOURCE_ID","DEPARTMENT_ID","SIMULATION_SET","SHIFT_NUM","SHIFT_DATE","FROM_TIME","TO_TIME","CAPACITY_UNITS","AGGREGATE_RESOURCE_ID","STATUS","APPLIED","UPDATED","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","REFRESH_NUMBER" from msc_net_resource_avail as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))

SQL_Statement

select "TRANSACTION_ID","PARENT_ID","PLAN_ID","ORGANIZATION_ID","RESOURCE_ID","DEPARTMENT_ID","SIMULATION_SET","SHIFT_NUM","SHIFT_DATE","FROM_TIME","TO_TIME","CAPACITY_UNITS","AGGREGATE_RESOURCE_ID","STATUS","APPLIED","UPDATED","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","REFRESH_NUMBER" from msc_net_resource_avail as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))