VIEW: MSC.MSC_ST_JOB_OP_RESOURCES#

Source

View Text - Preformatted

select WIP_ENTITY_ID WIP_ENTITY_ID, SR_INSTANCE_ID SR_INSTANCE_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM, ORGANIZATION_ID ORGANIZATION_ID, ALTERNATE_NUM ALTERNATE_NUM, RECOMMENDED RECOMMENDED, RECO_START_DATE RECO_START_DATE, RECO_COMPLETION_DATE RECO_COMPLETION_DATE, RESOURCE_ID RESOURCE_ID, ASSIGNED_UNITS ASSIGNED_UNITS, USAGE_RATE_OR_AMOUNT USAGE_RATE_OR_AMOUNT, UOM_CODE UOM_CODE, BASIS_TYPE BASIS_TYPE, SCHEDULE_FLAG SCHEDULE_FLAG, RESOURCE_OFFSET_PERCENT RESOURCE_OFFSET_PERCENT, SCHEDULE_SEQ_NUM SCHEDULE_SEQ_NUM, PRINCIPAL_FLAG PRINCIPAL_FLAG, DEPARTMENT_ID DEPARTMENT_ID, ACTIVITY_GROUP_ID ACTIVITY_GROUP_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REFRESH_ID REFRESH_ID, DELETED_FLAG DELETED_FLAG, SR_INSTANCE_CODE SR_INSTANCE_CODE, COMPANY_NAME COMPANY_NAME, WIP_ENTITY_NAME WIP_ENTITY_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, OPERATION_SEQ_CODE OPERATION_SEQ_CODE, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, BATCH_ID BATCH_ID, ST_TRANSACTION_ID ST_TRANSACTION_ID, MESSAGE_ID MESSAGE_ID, ERROR_TEXT ERROR_TEXT, PROCESS_FLAG PROCESS_FLAG, RESOURCE_SEQ_CODE RESOURCE_SEQ_CODE, OPERATION_EFFECTIVITY_DATE OPERATION_EFFECTIVITY_DATE, DEPARTMENT_CODE DEPARTMENT_CODE, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR, ITEM_NAME ITEM_NAME, ROUTING_NAME ROUTING_NAME, RESOURCE_CODE RESOURCE_CODE, SETUP_ID SETUP_ID, GROUP_SEQUENCE_ID GROUP_SEQUENCE_ID, GROUP_SEQUENCE_NUMBER GROUP_SEQUENCE_NUMBER, MAXIMUM_ASSIGNED_UNITS MAXIMUM_ASSIGNED_UNITS, BATCH_NUMBER BATCH_NUMBER, PARENT_SEQ_NUM PARENT_SEQ_NUM, FIRM_FLAG FIRM_FLAG from "MSC"."MSC_ST_JOB_OP_RESOURCES"

View Text - HTML Formatted

SELECT WIP_ENTITY_ID WIP_ENTITY_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM
, ORGANIZATION_ID ORGANIZATION_ID
, ALTERNATE_NUM ALTERNATE_NUM
, RECOMMENDED RECOMMENDED
, RECO_START_DATE RECO_START_DATE
, RECO_COMPLETION_DATE RECO_COMPLETION_DATE
, RESOURCE_ID RESOURCE_ID
, ASSIGNED_UNITS ASSIGNED_UNITS
, USAGE_RATE_OR_AMOUNT USAGE_RATE_OR_AMOUNT
, UOM_CODE UOM_CODE
, BASIS_TYPE BASIS_TYPE
, SCHEDULE_FLAG SCHEDULE_FLAG
, RESOURCE_OFFSET_PERCENT RESOURCE_OFFSET_PERCENT
, SCHEDULE_SEQ_NUM SCHEDULE_SEQ_NUM
, PRINCIPAL_FLAG PRINCIPAL_FLAG
, DEPARTMENT_ID DEPARTMENT_ID
, ACTIVITY_GROUP_ID ACTIVITY_GROUP_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REFRESH_ID REFRESH_ID
, DELETED_FLAG DELETED_FLAG
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, COMPANY_NAME COMPANY_NAME
, WIP_ENTITY_NAME WIP_ENTITY_NAME
, ORGANIZATION_CODE ORGANIZATION_CODE
, OPERATION_SEQ_CODE OPERATION_SEQ_CODE
, ROUTING_SEQUENCE_ID ROUTING_SEQUENCE_ID
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, BATCH_ID BATCH_ID
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, MESSAGE_ID MESSAGE_ID
, ERROR_TEXT ERROR_TEXT
, PROCESS_FLAG PROCESS_FLAG
, RESOURCE_SEQ_CODE RESOURCE_SEQ_CODE
, OPERATION_EFFECTIVITY_DATE OPERATION_EFFECTIVITY_DATE
, DEPARTMENT_CODE DEPARTMENT_CODE
, ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_DESIGNATOR
, ITEM_NAME ITEM_NAME
, ROUTING_NAME ROUTING_NAME
, RESOURCE_CODE RESOURCE_CODE
, SETUP_ID SETUP_ID
, GROUP_SEQUENCE_ID GROUP_SEQUENCE_ID
, GROUP_SEQUENCE_NUMBER GROUP_SEQUENCE_NUMBER
, MAXIMUM_ASSIGNED_UNITS MAXIMUM_ASSIGNED_UNITS
, BATCH_NUMBER BATCH_NUMBER
, PARENT_SEQ_NUM PARENT_SEQ_NUM
, FIRM_FLAG FIRM_FLAG
FROM "MSC"."MSC_ST_JOB_OP_RESOURCES"