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.

VIEW: APPS.MSD_SPF_CMRO_BOM_V

Source

View Text - Preformatted


SELECT /* Base model members */ OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE || decode(pval.value, 1, '::' || ORG_CODE, '') SPF_CODE, OPERATING_FLEET || '::' || ORIGINATING_MR BASE_MODEL_CODE, OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE CHILD_CODE, OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE PARENT_CODE, MSD_DEM_COMMON_UTILITIES.get_workorder_item PARENT_ITEM_CODE, MSD_DEM_COMMON_UTILITIES.GET_DEM_SPF_BASE_MODEL DEMAND_TYPE, MAINTENANCE_TYPE_CODE, MAINTENANCE_TYPE_DESC, VISIT_TYPE, VISIT_STAGE_TYPE, TRANSIT_VISIT, OPERATING_FLEET ASSET_GROUP, ORIGINATING_MR CLASS_CODE, decode(pval.value, 1, ORG_CODE, du.default_code) ORGANIZATION_CODE, MIN(SDATE) EFFECTIVITY_DATE FROM MSD_SPF_ST_CMRO_WO_HIST, (SELECT msd_dem_sr_util.get_null_code default_code FROM DUAL) du, (select fnd_profile.value('MSD_DEM_INCLUDE_ORG_CMRO_DATA') value from dual) pval GROUP BY OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE || decode(pval.value, 1, '::' || ORG_CODE, ''), OPERATING_FLEET || '::' || ORIGINATING_MR, OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE, OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE, MSD_DEM_COMMON_UTILITIES.get_workorder_item, MSD_DEM_COMMON_UTILITIES.GET_DEM_SPF_BASE_MODEL, MAINTENANCE_TYPE_CODE, MAINTENANCE_TYPE_DESC, VISIT_TYPE, VISIT_STAGE_TYPE, TRANSIT_VISIT, OPERATING_FLEET, ORIGINATING_MR, decode(pval.value, 1, ORG_CODE, du.default_code) UNION ALL SELECT /* Child member (material) */ OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE || '::' || MATERIAL_CODE || decode(pval.value, 1, '::' || ORG_CODE, '') SPF_CODE, OPERATING_FLEET || '::' || ORIGINATING_MR BASE_MODEL_CODE, MATERIAL_CODE CHILD_CODE, OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE PARENT_CODE, MSD_DEM_COMMON_UTILITIES.get_workorder_item PARENT_ITEM_CODE, MSD_DEM_COMMON_UTILITIES.GET_DEM_SPF_OPTION DEMAND_TYPE, MAINTENANCE_TYPE_CODE, MAINTENANCE_TYPE_DESC, VISIT_TYPE, VISIT_STAGE_TYPE, TRANSIT_VISIT, OPERATING_FLEET ASSET_GROUP, ORIGINATING_MR CLASS_CODE, decode(pval.value, 1, ORG_CODE, du.default_code) ORGANIZATION_CODE, MIN(USG_DATE) EFFECTIVITY_DATE FROM MSD_SPF_ST_CMRO_MTL_USG, (SELECT msd_dem_sr_util.get_null_code default_code FROM DUAL) du, (select fnd_profile.value('MSD_DEM_INCLUDE_ORG_CMRO_DATA') value from dual) pval GROUP BY OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE || '::' || MATERIAL_CODE || decode(pval.value, 1, '::' || ORG_CODE, ''), OPERATING_FLEET || '::' || ORIGINATING_MR, MATERIAL_CODE, OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE, MSD_DEM_COMMON_UTILITIES.get_workorder_item, MSD_DEM_COMMON_UTILITIES.GET_DEM_SPF_OPTION, MAINTENANCE_TYPE_CODE, MAINTENANCE_TYPE_DESC, VISIT_TYPE, VISIT_STAGE_TYPE, TRANSIT_VISIT, OPERATING_FLEET, ORIGINATING_MR, decode(pval.value, 1, ORG_CODE, du.default_code) UNION ALL SELECT /* Child member (resource) */ OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE || '::' || BOM_RESOURCE_CODE || decode(pval.value, 1, '::' || ORG_CODE, '') SPF_CODE, OPERATING_FLEET || '::' || ORIGINATING_MR BASE_MODEL_CODE, BOM_RESOURCE_CODE CHILD_CODE, OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE PARENT_CODE, MSD_DEM_COMMON_UTILITIES.get_workorder_item PARENT_ITEM_CODE, MSD_DEM_COMMON_UTILITIES.GET_DEM_SPF_OPTION DEMAND_TYPE, MAINTENANCE_TYPE_CODE, MAINTENANCE_TYPE_DESC, VISIT_TYPE, VISIT_STAGE_TYPE, TRANSIT_VISIT, OPERATING_FLEET ASSET_GROUP, ORIGINATING_MR CLASS_CODE, decode(pval.value, 1, ORG_CODE, du.default_code) ORGANIZATION_CODE, MIN(USG_DATE) EFFECTIVITY_DATE FROM MSD_SPF_ST_CMRO_RES_USG, (SELECT msd_dem_sr_util.get_null_code default_code FROM DUAL) du, (select fnd_profile.value('MSD_DEM_INCLUDE_ORG_CMRO_DATA') value from dual) pval GROUP BY OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE || '::' || BOM_RESOURCE_CODE || decode(pval.value, 1, '::' || ORG_CODE, ''), OPERATING_FLEET || '::' || ORIGINATING_MR, BOM_RESOURCE_CODE, OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE, MSD_DEM_COMMON_UTILITIES.get_workorder_item, MSD_DEM_COMMON_UTILITIES.GET_DEM_SPF_OPTION, MAINTENANCE_TYPE_CODE, MAINTENANCE_TYPE_DESC, VISIT_TYPE, VISIT_STAGE_TYPE, TRANSIT_VISIT, OPERATING_FLEET, ORIGINATING_MR, decode(pval.value, 1, ORG_CODE, du.default_code)

View Text - HTML Formatted

SELECT /* BASE MODEL MEMBERS */ OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE || DECODE(PVAL.VALUE
, 1
, '::' || ORG_CODE
, '') SPF_CODE
, OPERATING_FLEET || '::' || ORIGINATING_MR BASE_MODEL_CODE
, OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE CHILD_CODE
, OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE PARENT_CODE
, MSD_DEM_COMMON_UTILITIES.GET_WORKORDER_ITEM PARENT_ITEM_CODE
, MSD_DEM_COMMON_UTILITIES.GET_DEM_SPF_BASE_MODEL DEMAND_TYPE
, MAINTENANCE_TYPE_CODE
, MAINTENANCE_TYPE_DESC
, VISIT_TYPE
, VISIT_STAGE_TYPE
, TRANSIT_VISIT
, OPERATING_FLEET ASSET_GROUP
, ORIGINATING_MR CLASS_CODE
, DECODE(PVAL.VALUE
, 1
, ORG_CODE
, DU.DEFAULT_CODE) ORGANIZATION_CODE
, MIN(SDATE) EFFECTIVITY_DATE
FROM MSD_SPF_ST_CMRO_WO_HIST
, (SELECT MSD_DEM_SR_UTIL.GET_NULL_CODE DEFAULT_CODE
FROM DUAL) DU
, (SELECT FND_PROFILE.VALUE('MSD_DEM_INCLUDE_ORG_CMRO_DATA') VALUE
FROM DUAL) PVAL GROUP BY OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE || DECODE(PVAL.VALUE
, 1
, '::' || ORG_CODE
, '')
, OPERATING_FLEET || '::' || ORIGINATING_MR
, OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE
, OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE
, MSD_DEM_COMMON_UTILITIES.GET_WORKORDER_ITEM
, MSD_DEM_COMMON_UTILITIES.GET_DEM_SPF_BASE_MODEL
, MAINTENANCE_TYPE_CODE
, MAINTENANCE_TYPE_DESC
, VISIT_TYPE
, VISIT_STAGE_TYPE
, TRANSIT_VISIT
, OPERATING_FLEET
, ORIGINATING_MR
, DECODE(PVAL.VALUE
, 1
, ORG_CODE
, DU.DEFAULT_CODE) UNION ALL SELECT /* CHILD MEMBER (MATERIAL) */ OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE || '::' || MATERIAL_CODE || DECODE(PVAL.VALUE
, 1
, '::' || ORG_CODE
, '') SPF_CODE
, OPERATING_FLEET || '::' || ORIGINATING_MR BASE_MODEL_CODE
, MATERIAL_CODE CHILD_CODE
, OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE PARENT_CODE
, MSD_DEM_COMMON_UTILITIES.GET_WORKORDER_ITEM PARENT_ITEM_CODE
, MSD_DEM_COMMON_UTILITIES.GET_DEM_SPF_OPTION DEMAND_TYPE
, MAINTENANCE_TYPE_CODE
, MAINTENANCE_TYPE_DESC
, VISIT_TYPE
, VISIT_STAGE_TYPE
, TRANSIT_VISIT
, OPERATING_FLEET ASSET_GROUP
, ORIGINATING_MR CLASS_CODE
, DECODE(PVAL.VALUE
, 1
, ORG_CODE
, DU.DEFAULT_CODE) ORGANIZATION_CODE
, MIN(USG_DATE) EFFECTIVITY_DATE
FROM MSD_SPF_ST_CMRO_MTL_USG
, (SELECT MSD_DEM_SR_UTIL.GET_NULL_CODE DEFAULT_CODE
FROM DUAL) DU
, (SELECT FND_PROFILE.VALUE('MSD_DEM_INCLUDE_ORG_CMRO_DATA') VALUE
FROM DUAL) PVAL GROUP BY OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE || '::' || MATERIAL_CODE || DECODE(PVAL.VALUE
, 1
, '::' || ORG_CODE
, '')
, OPERATING_FLEET || '::' || ORIGINATING_MR
, MATERIAL_CODE
, OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE
, MSD_DEM_COMMON_UTILITIES.GET_WORKORDER_ITEM
, MSD_DEM_COMMON_UTILITIES.GET_DEM_SPF_OPTION
, MAINTENANCE_TYPE_CODE
, MAINTENANCE_TYPE_DESC
, VISIT_TYPE
, VISIT_STAGE_TYPE
, TRANSIT_VISIT
, OPERATING_FLEET
, ORIGINATING_MR
, DECODE(PVAL.VALUE
, 1
, ORG_CODE
, DU.DEFAULT_CODE) UNION ALL SELECT /* CHILD MEMBER (RESOURCE) */ OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE || '::' || BOM_RESOURCE_CODE || DECODE(PVAL.VALUE
, 1
, '::' || ORG_CODE
, '') SPF_CODE
, OPERATING_FLEET || '::' || ORIGINATING_MR BASE_MODEL_CODE
, BOM_RESOURCE_CODE CHILD_CODE
, OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE PARENT_CODE
, MSD_DEM_COMMON_UTILITIES.GET_WORKORDER_ITEM PARENT_ITEM_CODE
, MSD_DEM_COMMON_UTILITIES.GET_DEM_SPF_OPTION DEMAND_TYPE
, MAINTENANCE_TYPE_CODE
, MAINTENANCE_TYPE_DESC
, VISIT_TYPE
, VISIT_STAGE_TYPE
, TRANSIT_VISIT
, OPERATING_FLEET ASSET_GROUP
, ORIGINATING_MR CLASS_CODE
, DECODE(PVAL.VALUE
, 1
, ORG_CODE
, DU.DEFAULT_CODE) ORGANIZATION_CODE
, MIN(USG_DATE) EFFECTIVITY_DATE
FROM MSD_SPF_ST_CMRO_RES_USG
, (SELECT MSD_DEM_SR_UTIL.GET_NULL_CODE DEFAULT_CODE
FROM DUAL) DU
, (SELECT FND_PROFILE.VALUE('MSD_DEM_INCLUDE_ORG_CMRO_DATA') VALUE
FROM DUAL) PVAL GROUP BY OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE || '::' || BOM_RESOURCE_CODE || DECODE(PVAL.VALUE
, 1
, '::' || ORG_CODE
, '')
, OPERATING_FLEET || '::' || ORIGINATING_MR
, BOM_RESOURCE_CODE
, OPERATING_FLEET || '::' || ORIGINATING_MR || '::' || VISIT_TYPE || '::' || VISIT_STAGE_TYPE || '::' || MAINTENANCE_TYPE_CODE
, MSD_DEM_COMMON_UTILITIES.GET_WORKORDER_ITEM
, MSD_DEM_COMMON_UTILITIES.GET_DEM_SPF_OPTION
, MAINTENANCE_TYPE_CODE
, MAINTENANCE_TYPE_DESC
, VISIT_TYPE
, VISIT_STAGE_TYPE
, TRANSIT_VISIT
, OPERATING_FLEET
, ORIGINATING_MR
, DECODE(PVAL.VALUE
, 1
, ORG_CODE
, DU.DEFAULT_CODE)