eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: MSD.MSD_SPF_CMRO_BOM#

Source

View Text - Preformatted


select SPF_CODE SPF_CODE, BASE_MODEL_CODE BASE_MODEL_CODE, CHILD_CODE CHILD_CODE, PARENT_CODE PARENT_CODE, PARENT_ITEM_CODE PARENT_ITEM_CODE, DEMAND_TYPE DEMAND_TYPE, MAINTENANCE_TYPE_CODE MAINTENANCE_TYPE_CODE, MAINTENANCE_TYPE_DESC MAINTENANCE_TYPE_DESC, VISIT_TYPE VISIT_TYPE, VISIT_STAGE_TYPE VISIT_STAGE_TYPE, TRANSIT_VISIT TRANSIT_VISIT, ASSET_GROUP ASSET_GROUP, CLASS_CODE CLASS_CODE, ORGANIZATION_CODE ORGANIZATION_CODE, EFFECTIVITY_DATE EFFECTIVITY_DATE from "MSD"."MSD_SPF_CMRO_BOM"

View Text - HTML Formatted

SELECT SPF_CODE SPF_CODE
, BASE_MODEL_CODE BASE_MODEL_CODE
, CHILD_CODE CHILD_CODE
, PARENT_CODE PARENT_CODE
, PARENT_ITEM_CODE PARENT_ITEM_CODE
, DEMAND_TYPE DEMAND_TYPE
, MAINTENANCE_TYPE_CODE MAINTENANCE_TYPE_CODE
, MAINTENANCE_TYPE_DESC MAINTENANCE_TYPE_DESC
, VISIT_TYPE VISIT_TYPE
, VISIT_STAGE_TYPE VISIT_STAGE_TYPE
, TRANSIT_VISIT TRANSIT_VISIT
, ASSET_GROUP ASSET_GROUP
, CLASS_CODE CLASS_CODE
, ORGANIZATION_CODE ORGANIZATION_CODE
, EFFECTIVITY_DATE EFFECTIVITY_DATE
FROM "MSD"."MSD_SPF_CMRO_BOM"