VIEW: MSD.MSD_SPF_ST_CMRO_RES_USG#

Source

View Text - Preformatted

select OPERATING_FLEET OPERATING_FLEET, OPERATING_ORG OPERATING_ORG, OPERATING_ORG_DESC OPERATING_ORG_DESC, OPERATIONS_TYPE_CODE OPERATIONS_TYPE_CODE, OPERATIONS_TYPE_DESC OPERATIONS_TYPE_DESC, ORIGINATING_MR ORIGINATING_MR, VISIT_TYPE VISIT_TYPE, TRANSIT_VISIT TRANSIT_VISIT, VISIT_STAGE_TYPE VISIT_STAGE_TYPE, MAINTENANCE_TYPE_CODE MAINTENANCE_TYPE_CODE, MAINTENANCE_TYPE_DESC MAINTENANCE_TYPE_DESC, RESOURCE_SR_PK RESOURCE_SR_PK, BOM_RESOURCE_CODE BOM_RESOURCE_CODE, CMRO_RESOURCE_CODE CMRO_RESOURCE_CODE, SR_ORG_PK SR_ORG_PK, ORG_CODE ORG_CODE, USG_DATE USG_DATE, QUANTITY QUANTITY, 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, PROCESS_FLAG PROCESS_FLAG, ERROR_TEXT ERROR_TEXT from "MSD"."MSD_SPF_ST_CMRO_RES_USG"

View Text - HTML Formatted

SELECT OPERATING_FLEET OPERATING_FLEET
, OPERATING_ORG OPERATING_ORG
, OPERATING_ORG_DESC OPERATING_ORG_DESC
, OPERATIONS_TYPE_CODE OPERATIONS_TYPE_CODE
, OPERATIONS_TYPE_DESC OPERATIONS_TYPE_DESC
, ORIGINATING_MR ORIGINATING_MR
, VISIT_TYPE VISIT_TYPE
, TRANSIT_VISIT TRANSIT_VISIT
, VISIT_STAGE_TYPE VISIT_STAGE_TYPE
, MAINTENANCE_TYPE_CODE MAINTENANCE_TYPE_CODE
, MAINTENANCE_TYPE_DESC MAINTENANCE_TYPE_DESC
, RESOURCE_SR_PK RESOURCE_SR_PK
, BOM_RESOURCE_CODE BOM_RESOURCE_CODE
, CMRO_RESOURCE_CODE CMRO_RESOURCE_CODE
, SR_ORG_PK SR_ORG_PK
, ORG_CODE ORG_CODE
, USG_DATE USG_DATE
, QUANTITY QUANTITY
, 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
, PROCESS_FLAG PROCESS_FLAG
, ERROR_TEXT ERROR_TEXT
FROM "MSD"."MSD_SPF_ST_CMRO_RES_USG"