VIEW: MSC.MSC_RESOURCE_REQUIREMENTS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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