MSC_RESOURCE_REQUIREMENTSRC

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
TRANSACTION_ID PLAN_ID SUPPLY_ID ORGANIZATION_ID ROUTING_SEQUENCE_ID OPERATION_SEQUENCE_ID RESOURCE_SEQ_NUM RESOURCE_ID DEPARTMENT_ID ALTERNATE_NUM START_DATE END_DATE BKT_START_DATE RESOURCE_HOURS SET_UP BKT_END_DATE TEAR_DOWN AGGREGATE_RESOURCE_ID SCHEDULE_FLAG PARENT_ID STD_OP_CODE WIP_ENTITY_ID ASSIGNED_UNITS BASIS_TYPE OPERATION_SEQ_NUM LOAD_RATE DAILY_RESOURCE_HOURS STATUS APPLIED UPDATED SUBST_RES_FLAG REFRESH_NUMBER LAST_UPDATED_BY LAST_UPDATE_DATE CREATED_BY CREATION_DATE LAST_UPDATE_LOGIN SOURCE_ITEM_ID ASSEMBLY_ITEM_ID SUPPLY_TYPE FIRM_START_DATE FIRM_END_DATE FIRM_FLAG CUMMULATIVE_QUANTITY YIELD REVERSE_CUMULATIVE_YIELD BATCH_NUMBER MINIMUM_TRANSFER_QUANTITY REMAINING_CAPACITY OVERLOADED_CAPACITY EARLIEST_START_DATE EARLIEST_COMPLETION_DATE SCHEDULED_DEMAND_ID PARENT_SEQ_NUM SETUP_ID ULPSD ULPCD UEPSD UEPCD EACD QUANTITY_IN_QUEUE QUANTITY_RUNNING QUANTITY_WAITING_TO_MOVE QUANTITY_COMPLETED USAGE_RATE HOURS_EXPENDED RECORD_SOURCE ACTIVITY_GROUP_ID PRINCIPAL_FLAG ORIG_RESOURCE_SEQ_NUM GROUP_SEQUENCE_ID GROUP_SEQUENCE_NUMBER MAXIMUM_ASSIGNED_UNITS MINIMUM_CAPACITY MAXIMUM_CAPACITY BREAKABLE_ACTIVITY_FLAG CAPACITY_CONSUMED_RATIO FROM_SETUP_ID STEP_QUANTITY STEP_QUANTITY_UOM UNADJUSTED_RESOURCE_HOURS TOUCH_TIME JIT_END_DATE UNBUCKETED_START_DATE UNBUCKETED_END_DATE ACTUAL_START_DATE TOTAL_RESOURCE_HOURS ACTIVITY_NAME OPERATION_NAME

Name

TRANSACTION_ID

PLAN_ID

SUPPLY_ID

ORGANIZATION_ID

ROUTING_SEQUENCE_ID

OPERATION_SEQUENCE_ID

RESOURCE_SEQ_NUM

RESOURCE_ID

DEPARTMENT_ID

ALTERNATE_NUM

START_DATE

END_DATE

BKT_START_DATE

RESOURCE_HOURS

SET_UP

BKT_END_DATE

TEAR_DOWN

AGGREGATE_RESOURCE_ID

SCHEDULE_FLAG

PARENT_ID

STD_OP_CODE

WIP_ENTITY_ID

ASSIGNED_UNITS

BASIS_TYPE

OPERATION_SEQ_NUM

LOAD_RATE

DAILY_RESOURCE_HOURS

STATUS

APPLIED

UPDATED

SUBST_RES_FLAG

REFRESH_NUMBER

LAST_UPDATED_BY

LAST_UPDATE_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATE_LOGIN

SOURCE_ITEM_ID

ASSEMBLY_ITEM_ID

SUPPLY_TYPE

FIRM_START_DATE

FIRM_END_DATE

FIRM_FLAG

CUMMULATIVE_QUANTITY

YIELD

REVERSE_CUMULATIVE_YIELD

BATCH_NUMBER

MINIMUM_TRANSFER_QUANTITY

REMAINING_CAPACITY

OVERLOADED_CAPACITY

EARLIEST_START_DATE

EARLIEST_COMPLETION_DATE

SCHEDULED_DEMAND_ID

PARENT_SEQ_NUM

SETUP_ID

ULPSD

ULPCD

UEPSD

UEPCD

EACD

QUANTITY_IN_QUEUE

QUANTITY_RUNNING

QUANTITY_WAITING_TO_MOVE

QUANTITY_COMPLETED

USAGE_RATE

HOURS_EXPENDED

RECORD_SOURCE

ACTIVITY_GROUP_ID

PRINCIPAL_FLAG

ORIG_RESOURCE_SEQ_NUM

GROUP_SEQUENCE_ID

GROUP_SEQUENCE_NUMBER

MAXIMUM_ASSIGNED_UNITS

MINIMUM_CAPACITY

MAXIMUM_CAPACITY

BREAKABLE_ACTIVITY_FLAG

CAPACITY_CONSUMED_RATIO

FROM_SETUP_ID

STEP_QUANTITY

STEP_QUANTITY_UOM

UNADJUSTED_RESOURCE_HOURS

TOUCH_TIME

JIT_END_DATE

UNBUCKETED_START_DATE

UNBUCKETED_END_DATE

ACTUAL_START_DATE

TOTAL_RESOURCE_HOURS

ACTIVITY_NAME

OPERATION_NAME

Query

SQL_Statement
select "TRANSACTION_ID","PLAN_ID","SUPPLY_ID","ORGANIZATION_ID","ROUTING_SEQUENCE_ID","OPERATION_SEQUENCE_ID","RESOURCE_SEQ_NUM","RESOURCE_ID","DEPARTMENT_ID","ALTERNATE_NUM","START_DATE","END_DATE","BKT_START_DATE","RESOURCE_HOURS","SET_UP","BKT_END_DATE","TEAR_DOWN","AGGREGATE_RESOURCE_ID","SCHEDULE_FLAG","PARENT_ID","STD_OP_CODE","WIP_ENTITY_ID","ASSIGNED_UNITS","BASIS_TYPE","OPERATION_SEQ_NUM","LOAD_RATE","DAILY_RESOURCE_HOURS","STATUS","APPLIED","UPDATED","SUBST_RES_FLAG","REFRESH_NUMBER","LAST_UPDATED_BY","LAST_UPDATE_DATE","CREATED_BY","CREATION_DATE","LAST_UPDATE_LOGIN","SOURCE_ITEM_ID","ASSEMBLY_ITEM_ID","SUPPLY_TYPE","FIRM_START_DATE","FIRM_END_DATE","FIRM_FLAG","CUMMULATIVE_QUANTITY","YIELD","REVERSE_CUMULATIVE_YIELD","BATCH_NUMBER","MINIMUM_TRANSFER_QUANTITY","REMAINING_CAPACITY","OVERLOADED_CAPACITY","EARLIEST_START_DATE","EARLIEST_COMPLETION_DATE","SCHEDULED_DEMAND_ID","PARENT_SEQ_NUM","SETUP_ID","ULPSD","ULPCD","UEPSD","UEPCD","EACD","QUANTITY_IN_QUEUE","QUANTITY_RUNNING","QUANTITY_WAITING_TO_MOVE","QUANTITY_COMPLETED","USAGE_RATE","HOURS_EXPENDED","RECORD_SOURCE","ACTIVITY_GROUP_ID","PRINCIPAL_FLAG","ORIG_RESOURCE_SEQ_NUM","GROUP_SEQUENCE_ID","GROUP_SEQUENCE_NUMBER","MAXIMUM_ASSIGNED_UNITS","MINIMUM_CAPACITY","MAXIMUM_CAPACITY","BREAKABLE_ACTIVITY_FLAG","CAPACITY_CONSUMED_RATIO","FROM_SETUP_ID","STEP_QUANTITY","STEP_QUANTITY_UOM","UNADJUSTED_RESOURCE_HOURS","TOUCH_TIME","JIT_END_DATE","UNBUCKETED_START_DATE","UNBUCKETED_END_DATE","ACTUAL_START_DATE","TOTAL_RESOURCE_HOURS","ACTIVITY_NAME","OPERATION_NAME" from msc_resource_requirements as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))

SQL_Statement

select "TRANSACTION_ID","PLAN_ID","SUPPLY_ID","ORGANIZATION_ID","ROUTING_SEQUENCE_ID","OPERATION_SEQUENCE_ID","RESOURCE_SEQ_NUM","RESOURCE_ID","DEPARTMENT_ID","ALTERNATE_NUM","START_DATE","END_DATE","BKT_START_DATE","RESOURCE_HOURS","SET_UP","BKT_END_DATE","TEAR_DOWN","AGGREGATE_RESOURCE_ID","SCHEDULE_FLAG","PARENT_ID","STD_OP_CODE","WIP_ENTITY_ID","ASSIGNED_UNITS","BASIS_TYPE","OPERATION_SEQ_NUM","LOAD_RATE","DAILY_RESOURCE_HOURS","STATUS","APPLIED","UPDATED","SUBST_RES_FLAG","REFRESH_NUMBER","LAST_UPDATED_BY","LAST_UPDATE_DATE","CREATED_BY","CREATION_DATE","LAST_UPDATE_LOGIN","SOURCE_ITEM_ID","ASSEMBLY_ITEM_ID","SUPPLY_TYPE","FIRM_START_DATE","FIRM_END_DATE","FIRM_FLAG","CUMMULATIVE_QUANTITY","YIELD","REVERSE_CUMULATIVE_YIELD","BATCH_NUMBER","MINIMUM_TRANSFER_QUANTITY","REMAINING_CAPACITY","OVERLOADED_CAPACITY","EARLIEST_START_DATE","EARLIEST_COMPLETION_DATE","SCHEDULED_DEMAND_ID","PARENT_SEQ_NUM","SETUP_ID","ULPSD","ULPCD","UEPSD","UEPCD","EACD","QUANTITY_IN_QUEUE","QUANTITY_RUNNING","QUANTITY_WAITING_TO_MOVE","QUANTITY_COMPLETED","USAGE_RATE","HOURS_EXPENDED","RECORD_SOURCE","ACTIVITY_GROUP_ID","PRINCIPAL_FLAG","ORIG_RESOURCE_SEQ_NUM","GROUP_SEQUENCE_ID","GROUP_SEQUENCE_NUMBER","MAXIMUM_ASSIGNED_UNITS","MINIMUM_CAPACITY","MAXIMUM_CAPACITY","BREAKABLE_ACTIVITY_FLAG","CAPACITY_CONSUMED_RATIO","FROM_SETUP_ID","STEP_QUANTITY","STEP_QUANTITY_UOM","UNADJUSTED_RESOURCE_HOURS","TOUCH_TIME","JIT_END_DATE","UNBUCKETED_START_DATE","UNBUCKETED_END_DATE","ACTUAL_START_DATE","TOTAL_RESOURCE_HOURS","ACTIVITY_NAME","OPERATION_NAME" from msc_resource_requirements as of scn msc_coll_utils.get_last_read_cons_SCN(SYS_CONTEXT ('MSC', 'readscn'))