VIEW: MSC.MSC_ST_RESOURCE_REQUIREMENTS#

Source

View Text - Preformatted

select DEPARTMENT_ID DEPARTMENT_ID, RESOURCE_ID RESOURCE_ID, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SUPPLY_ID SUPPLY_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM, START_DATE START_DATE, OPERATION_HOURS_REQUIRED OPERATION_HOURS_REQUIRED, HOURS_EXPENDED HOURS_EXPENDED, DEMAND_CLASS DEMAND_CLASS, BASIS_TYPE BASIS_TYPE, ASSIGNED_UNITS ASSIGNED_UNITS, END_DATE END_DATE, WIP_JOB_TYPE WIP_JOB_TYPE, SCHEDULED_COMPLETION_DATE SCHEDULED_COMPLETION_DATE, SCHEDULED_QUANTITY SCHEDULED_QUANTITY, QUANTITY_COMPLETED QUANTITY_COMPLETED, DELETED_FLAG DELETED_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, 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, SR_INSTANCE_ID SR_INSTANCE_ID, REFRESH_ID REFRESH_ID, WIP_ENTITY_ID WIP_ENTITY_ID, STD_OP_CODE STD_OP_CODE, SUPPLY_TYPE SUPPLY_TYPE, CUMMULATIVE_QAUNTITY CUMMULATIVE_QAUNTITY, MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY, FIRM_FLAG FIRM_FLAG, COMPANY_ID COMPANY_ID, COMPANY_NAME COMPANY_NAME, WIP_ENTITY_NAME WIP_ENTITY_NAME, ITEM_NAME ITEM_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, SR_INSTANCE_CODE SR_INSTANCE_CODE, OPERATION_SEQ_CODE OPERATION_SEQ_CODE, RESOURCE_SEQ_CODE RESOURCE_SEQ_CODE, DEPARTMENT_CODE DEPARTMENT_CODE, RESOURCE_CODE RESOURCE_CODE, ROUTING_NAME ROUTING_NAME, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, OPERATION_EFFECTIVITY_DATE OPERATION_EFFECTIVITY_DATE, ALTERNATE_NUMBER ALTERNATE_NUMBER, ERROR_TEXT ERROR_TEXT, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, BATCH_ID BATCH_ID, PARENT_SEQ_NUM PARENT_SEQ_NUM, SETUP_ID SETUP_ID, SCHEDULE_FLAG SCHEDULE_FLAG, QUANTITY_IN_QUEUE QUANTITY_IN_QUEUE, QUANTITY_RUNNING QUANTITY_RUNNING, QUANTITY_WAITING_TO_MOVE QUANTITY_WAITING_TO_MOVE, YIELD YIELD, USAGE_RATE USAGE_RATE, ACTIVITY_GROUP_ID ACTIVITY_GROUP_ID, PRINCIPAL_FLAG PRINCIPAL_FLAG, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_DEPARTMENT_ID SOURCE_DEPARTMENT_ID, SOURCE_RESOURCE_ID SOURCE_RESOURCE_ID, SOURCE_RESOURCE_SEQ_NUM SOURCE_RESOURCE_SEQ_NUM, SOURCE_OPERATION_SEQUENCE_ID SOURCE_OPERATION_SEQUENCE_ID, SOURCE_WIP_ENTITY_ID SOURCE_WIP_ENTITY_ID, SOURCE_OPERATION_SEQ_NUM SOURCE_OPERATION_SEQ_NUM, ORIG_RESOURCE_SEQ_NUM ORIG_RESOURCE_SEQ_NUM, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID, GROUP_SEQUENCE_ID GROUP_SEQUENCE_ID, GROUP_SEQUENCE_NUMBER GROUP_SEQUENCE_NUMBER, BATCH_NUMBER BATCH_NUMBER, MAXIMUM_ASSIGNED_UNITS MAXIMUM_ASSIGNED_UNITS, MINIMUM_CAPACITY MINIMUM_CAPACITY, MAXIMUM_CAPACITY MAXIMUM_CAPACITY, BREAKABLE_ACTIVITY_FLAG BREAKABLE_ACTIVITY_FLAG, STEP_QUANTITY STEP_QUANTITY, STEP_QUANTITY_UOM STEP_QUANTITY_UOM, UNADJUSTED_RESOURCE_HOURS UNADJUSTED_RESOURCE_HOURS, TOUCH_TIME TOUCH_TIME, ACTUAL_START_DATE ACTUAL_START_DATE, ACTIVITY_NAME ACTIVITY_NAME, OPERATION_NAME OPERATION_NAME, OPERATION_STATUS OPERATION_STATUS, SHUTDOWN_TYPE SHUTDOWN_TYPE, SCHEDULE_DESIGNATOR_ID SCHEDULE_DESIGNATOR_ID, OBJECT_TYPE OBJECT_TYPE, DISPOSITION_ID DISPOSITION_ID, MAINTENANCE_OBJECT_SOURCE MAINTENANCE_OBJECT_SOURCE, OPERATING_FLEET OPERATING_FLEET, MAINTENANCE_REQUIREMENT MAINTENANCE_REQUIREMENT, OPERATION_CODE OPERATION_CODE, ACTUAL_END_DATE ACTUAL_END_DATE, CLASS_CODE CLASS_CODE from "MSC"."MSC_ST_RESOURCE_REQUIREMENTS"

View Text - HTML Formatted

SELECT DEPARTMENT_ID DEPARTMENT_ID
, RESOURCE_ID RESOURCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SUPPLY_ID SUPPLY_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, OPERATION_SEQUENCE_ID OPERATION_SEQUENCE_ID
, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM
, START_DATE START_DATE
, OPERATION_HOURS_REQUIRED OPERATION_HOURS_REQUIRED
, HOURS_EXPENDED HOURS_EXPENDED
, DEMAND_CLASS DEMAND_CLASS
, BASIS_TYPE BASIS_TYPE
, ASSIGNED_UNITS ASSIGNED_UNITS
, END_DATE END_DATE
, WIP_JOB_TYPE WIP_JOB_TYPE
, SCHEDULED_COMPLETION_DATE SCHEDULED_COMPLETION_DATE
, SCHEDULED_QUANTITY SCHEDULED_QUANTITY
, QUANTITY_COMPLETED QUANTITY_COMPLETED
, DELETED_FLAG DELETED_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, 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
, SR_INSTANCE_ID SR_INSTANCE_ID
, REFRESH_ID REFRESH_ID
, WIP_ENTITY_ID WIP_ENTITY_ID
, STD_OP_CODE STD_OP_CODE
, SUPPLY_TYPE SUPPLY_TYPE
, CUMMULATIVE_QAUNTITY CUMMULATIVE_QAUNTITY
, MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY
, FIRM_FLAG FIRM_FLAG
, COMPANY_ID COMPANY_ID
, COMPANY_NAME COMPANY_NAME
, WIP_ENTITY_NAME WIP_ENTITY_NAME
, ITEM_NAME ITEM_NAME
, ORGANIZATION_CODE ORGANIZATION_CODE
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, OPERATION_SEQ_CODE OPERATION_SEQ_CODE
, RESOURCE_SEQ_CODE RESOURCE_SEQ_CODE
, DEPARTMENT_CODE DEPARTMENT_CODE
, RESOURCE_CODE RESOURCE_CODE
, ROUTING_NAME ROUTING_NAME
, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, OPERATION_EFFECTIVITY_DATE OPERATION_EFFECTIVITY_DATE
, ALTERNATE_NUMBER ALTERNATE_NUMBER
, ERROR_TEXT ERROR_TEXT
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, BATCH_ID BATCH_ID
, PARENT_SEQ_NUM PARENT_SEQ_NUM
, SETUP_ID SETUP_ID
, SCHEDULE_FLAG SCHEDULE_FLAG
, QUANTITY_IN_QUEUE QUANTITY_IN_QUEUE
, QUANTITY_RUNNING QUANTITY_RUNNING
, QUANTITY_WAITING_TO_MOVE QUANTITY_WAITING_TO_MOVE
, YIELD YIELD
, USAGE_RATE USAGE_RATE
, ACTIVITY_GROUP_ID ACTIVITY_GROUP_ID
, PRINCIPAL_FLAG PRINCIPAL_FLAG
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_DEPARTMENT_ID SOURCE_DEPARTMENT_ID
, SOURCE_RESOURCE_ID SOURCE_RESOURCE_ID
, SOURCE_RESOURCE_SEQ_NUM SOURCE_RESOURCE_SEQ_NUM
, SOURCE_OPERATION_SEQUENCE_ID SOURCE_OPERATION_SEQUENCE_ID
, SOURCE_WIP_ENTITY_ID SOURCE_WIP_ENTITY_ID
, SOURCE_OPERATION_SEQ_NUM SOURCE_OPERATION_SEQ_NUM
, ORIG_RESOURCE_SEQ_NUM ORIG_RESOURCE_SEQ_NUM
, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID
, GROUP_SEQUENCE_ID GROUP_SEQUENCE_ID
, GROUP_SEQUENCE_NUMBER GROUP_SEQUENCE_NUMBER
, BATCH_NUMBER BATCH_NUMBER
, MAXIMUM_ASSIGNED_UNITS MAXIMUM_ASSIGNED_UNITS
, MINIMUM_CAPACITY MINIMUM_CAPACITY
, MAXIMUM_CAPACITY MAXIMUM_CAPACITY
, BREAKABLE_ACTIVITY_FLAG BREAKABLE_ACTIVITY_FLAG
, STEP_QUANTITY STEP_QUANTITY
, STEP_QUANTITY_UOM STEP_QUANTITY_UOM
, UNADJUSTED_RESOURCE_HOURS UNADJUSTED_RESOURCE_HOURS
, TOUCH_TIME TOUCH_TIME
, ACTUAL_START_DATE ACTUAL_START_DATE
, ACTIVITY_NAME ACTIVITY_NAME
, OPERATION_NAME OPERATION_NAME
, OPERATION_STATUS OPERATION_STATUS
, SHUTDOWN_TYPE SHUTDOWN_TYPE
, SCHEDULE_DESIGNATOR_ID SCHEDULE_DESIGNATOR_ID
, OBJECT_TYPE OBJECT_TYPE
, DISPOSITION_ID DISPOSITION_ID
, MAINTENANCE_OBJECT_SOURCE MAINTENANCE_OBJECT_SOURCE
, OPERATING_FLEET OPERATING_FLEET
, MAINTENANCE_REQUIREMENT MAINTENANCE_REQUIREMENT
, OPERATION_CODE OPERATION_CODE
, ACTUAL_END_DATE ACTUAL_END_DATE
, CLASS_CODE CLASS_CODE
FROM "MSC"."MSC_ST_RESOURCE_REQUIREMENTS"