VIEW: MSC.MSC_ST_RESOURCE_INSTANCE_REQS#

Source

View Text - Preformatted

select RESOURCE_ID RESOURCE_ID, RES_INSTANCE_ID RES_INSTANCE_ID, ORGANIZATION_ID ORGANIZATION_ID, DEPARTMENT_ID DEPARTMENT_ID, SUPPLY_ID SUPPLY_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM, WIP_ENTITY_ID WIP_ENTITY_ID, SR_INSTANCE_ID SR_INSTANCE_ID, START_DATE START_DATE, END_DATE END_DATE, SERIAL_NUMBER SERIAL_NUMBER, EQUIPMENT_ITEM_ID EQUIPMENT_ITEM_ID, ORIG_RESOURCE_SEQ_NUM ORIG_RESOURCE_SEQ_NUM, PARENT_ID PARENT_ID, RESOURCE_INSTANCE_HOURS RESOURCE_INSTANCE_HOURS, BATCH_NUMBER BATCH_NUMBER, PARENT_SEQ_NUM PARENT_SEQ_NUM, SETUP_SEQUENCE_NUM SETUP_SEQUENCE_NUM, DELETED_FLAG DELETED_FLAG, WIP_ENTITY_NAME WIP_ENTITY_NAME, OPERATION_SEQ_CODE OPERATION_SEQ_CODE, ORGAINZATION_CODE ORGAINZATION_CODE, DEPARTMENT_CODE DEPARTMENT_CODE, RESOURCE_CODE RESOURCE_CODE, RES_INSTANCE_CODE RES_INSTANCE_CODE, REFRESH_ID REFRESH_ID, COMPANY_ID COMPANY_ID, COMPANY_NAME COMPANY_NAME, SR_INSTANCE_CODE SR_INSTANCE_CODE, MESSAGE_ID MESSAGE_ID, PROCESS_FLAG PROCESS_FLAG, ERROR_TEXT ERROR_TEXT, ST_TRANSACTION_ID ST_TRANSACTION_ID, BATCH_ID BATCH_ID, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, 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 from "MSC"."MSC_ST_RESOURCE_INSTANCE_REQS"

View Text - HTML Formatted

SELECT RESOURCE_ID RESOURCE_ID
, RES_INSTANCE_ID RES_INSTANCE_ID
, ORGANIZATION_ID ORGANIZATION_ID
, DEPARTMENT_ID DEPARTMENT_ID
, SUPPLY_ID SUPPLY_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM
, WIP_ENTITY_ID WIP_ENTITY_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, START_DATE START_DATE
, END_DATE END_DATE
, SERIAL_NUMBER SERIAL_NUMBER
, EQUIPMENT_ITEM_ID EQUIPMENT_ITEM_ID
, ORIG_RESOURCE_SEQ_NUM ORIG_RESOURCE_SEQ_NUM
, PARENT_ID PARENT_ID
, RESOURCE_INSTANCE_HOURS RESOURCE_INSTANCE_HOURS
, BATCH_NUMBER BATCH_NUMBER
, PARENT_SEQ_NUM PARENT_SEQ_NUM
, SETUP_SEQUENCE_NUM SETUP_SEQUENCE_NUM
, DELETED_FLAG DELETED_FLAG
, WIP_ENTITY_NAME WIP_ENTITY_NAME
, OPERATION_SEQ_CODE OPERATION_SEQ_CODE
, ORGAINZATION_CODE ORGAINZATION_CODE
, DEPARTMENT_CODE DEPARTMENT_CODE
, RESOURCE_CODE RESOURCE_CODE
, RES_INSTANCE_CODE RES_INSTANCE_CODE
, REFRESH_ID REFRESH_ID
, COMPANY_ID COMPANY_ID
, COMPANY_NAME COMPANY_NAME
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, MESSAGE_ID MESSAGE_ID
, PROCESS_FLAG PROCESS_FLAG
, ERROR_TEXT ERROR_TEXT
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, BATCH_ID BATCH_ID
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, 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
FROM "MSC"."MSC_ST_RESOURCE_INSTANCE_REQS"