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.MTH_SRC_RESOURCES_V

Source

View Text - Preformatted


SELECT RESOURCE_PK, RESOURCE_TYPE, EBS_RESOURCE_ID, EBS_DEPARTMENT_ID, EBS_ORGANIZATION_ID, USAGE_UOM, CAPACITY_UNITS, AVAILABLE_24_HOUR_FLAG, SYSTEM_FK, DISABLE_DATE, RESOURCE_NAME, USER_ATTR1, USER_ATTR2, USER_ATTR3, USER_ATTR4, USER_ATTR5, USER_ATTR6, USER_ATTR7, USER_ATTR8, USER_ATTR9, USER_ATTR10, USER_ATTR11, USER_ATTR12, USER_ATTR13, USER_ATTR14, USER_ATTR15, USER_ATTR16, USER_ATTR17, USER_ATTR18, USER_ATTR19, USER_ATTR20, USER_MEASURE1, USER_MEASURE2, USER_MEASURE3, USER_MEASURE4, USER_MEASURE5, SOURCE_ORG_CODE, RESOURCE_DESCRIPTION, STD_UTILIZATION, STD_EFFICIENCY, PRODUCTION_RESOURCE, BUSINESS_FUNCTION, STATUS, LAST_UPDATE_DATE FROM (SELECT br.RESOURCE_ID || '-' || bd.DEPARTMENT_ID RESOURCE_PK, flv_type.MEANING RESOURCE_TYPE, br.RESOURCE_ID EBS_RESOURCE_ID, bd.DEPARTMENT_ID EBS_DEPARTMENT_ID, br.ORGANIZATION_ID EBS_ORGANIZATION_ID, br.UNIT_OF_MEASURE USAGE_UOM, bdr.CAPACITY_UNITS CAPACITY_UNITS, bdr.AVAILABLE_24_HOURS_FLAG AVAILABLE_24_HOUR_FLAG, fnd_profile.value('MTH_EBS_GLOBAL_NAME') SYSTEM_FK, br.DISABLE_DATE DISABLE_DATE, br.RESOURCE_CODE RESOURCE_NAME, br.ATTRIBUTE1 USER_ATTR1, br.ATTRIBUTE2 USER_ATTR2, br.ATTRIBUTE3 USER_ATTR3, br.ATTRIBUTE4 USER_ATTR4, br.ATTRIBUTE5 USER_ATTR5, br.ATTRIBUTE6 USER_ATTR6, br.ATTRIBUTE7 USER_ATTR7, br.ATTRIBUTE8 USER_ATTR8, br.ATTRIBUTE9 USER_ATTR9, br.ATTRIBUTE10 USER_ATTR10, br.ATTRIBUTE11 USER_ATTR11, br.ATTRIBUTE12 USER_ATTR12, br.ATTRIBUTE13 USER_ATTR13, br.ATTRIBUTE14 USER_ATTR14, br.ATTRIBUTE15 USER_ATTR15, CAST(NULL AS VARCHAR2(150)) USER_ATTR16, CAST(NULL AS VARCHAR2(150)) USER_ATTR17, CAST(NULL AS VARCHAR2(150)) USER_ATTR18, CAST(NULL AS VARCHAR2(150)) USER_ATTR19, CAST(NULL AS VARCHAR2(150)) USER_ATTR20, CAST(NULL AS NUMBER) USER_MEASURE1, CAST(NULL AS NUMBER) USER_MEASURE2, CAST(NULL AS NUMBER) USER_MEASURE3, CAST(NULL AS NUMBER) USER_MEASURE4, CAST(NULL AS NUMBER) USER_MEASURE5, mp.ORGANIZATION_CODE SOURCE_ORG_CODE, br.DESCRIPTION RESOURCE_DESCRIPTION, CAST(NULL AS NUMBER) STD_UTILIZATION, CAST(NULL AS NUMBER) STD_EFFICIENCY, (SELECT flv_prod.MEANING FROM FND_LOOKUP_VALUES flv_prod WHERE flv_prod.LOOKUP_TYPE = 'MTH_YES_NO' AND flv_prod.LOOKUP_CODE = 'Y' AND flv_prod.LANGUAGE = UserEnv('LANG')) PRODUCTION_RESOURCE, CAST(NULL AS VARCHAR2(100)) BUSINESS_FUNCTION, (SELECT flv_stat.MEANING FROM FND_LOOKUP_VALUES flv_stat WHERE flv_stat.LOOKUP_TYPE = 'MTH_STATUS_TYPE' AND flv_stat.LOOKUP_CODE = 'ACTIVE' AND flv_stat.LANGUAGE = UserEnv('LANG')) STATUS, Greatest(bdr.LAST_UPDATE_DATE, br.LAST_UPDATE_DATE) LAST_UPDATE_DATE FROM BOM_RESOURCES br, BOM_DEPARTMENTS bd, BOM_DEPARTMENT_RESOURCES bdr, MTL_PARAMETERS mp, FND_LOOKUP_VALUES flv_type WHERE bdr.DEPARTMENT_ID = bd.DEPARTMENT_ID AND bdr.RESOURCE_ID = br.RESOURCE_ID AND br.RESOURCE_TYPE IN (1,2) AND br.ORGANIZATION_ID = mp.ORGANIZATION_ID AND flv_type.LOOKUP_TYPE = 'MTH_RESOURCE_TYPE' AND flv_type.LOOKUP_CODE = Decode(br.RESOURCE_TYPE,1,'MACHINE','PERSON') AND flv_type.LANGUAGE = UserEnv('LANG') UNION ALL SELECT to_char(crd.RESOURCE_ID) RESOURCE_PK, CAST(NULL AS VARCHAR2(120)) RESOURCE_TYPE, crd.RESOURCE_ID EBS_RESOURCE_ID, CAST(NULL AS NUMBER) EBS_DEPARTMENT_ID, mtp.ORGANIZATION_ID EBS_ORGANIZATION_ID, crd.USAGE_UM USAGE_UOM, crd.ASSIGNED_QTY CAPACITY_UNITS, DECODE(crd.DAILY_AVAIL_USE,24,1,2) AVAIL_24_HOUR_FLAG, FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK, CAST(NULL AS DATE) DISABLE_DATE, crd.RESOURCES RESOURCE_NAME, CAST(NULL AS VARCHAR2(150)) USER_ATTR1, CAST(NULL AS VARCHAR2(150)) USER_ATTR2, CAST(NULL AS VARCHAR2(150)) USER_ATTR3, CAST(NULL AS VARCHAR2(150)) USER_ATTR4, CAST(NULL AS VARCHAR2(150)) USER_ATTR5, CAST(NULL AS VARCHAR2(150)) USER_ATTR6, CAST(NULL AS VARCHAR2(150)) USER_ATTR7, CAST(NULL AS VARCHAR2(150)) USER_ATTR8, CAST(NULL AS VARCHAR2(150)) USER_ATTR9, CAST(NULL AS VARCHAR2(150)) USER_ATTR10, CAST(NULL AS VARCHAR2(150)) USER_ATTR11, CAST(NULL AS VARCHAR2(150)) USER_ATTR12, CAST(NULL AS VARCHAR2(150)) USER_ATTR13, CAST(NULL AS VARCHAR2(150)) USER_ATTR14, CAST(NULL AS VARCHAR2(150)) USER_ATTR15, CAST(NULL AS VARCHAR2(150)) USER_ATTR16, CAST(NULL AS VARCHAR2(150)) USER_ATTR17, CAST(NULL AS VARCHAR2(150)) USER_ATTR18, CAST(NULL AS VARCHAR2(150)) USER_ATTR19, CAST(NULL AS VARCHAR2(150)) USER_ATTR20, CAST(NULL AS NUMBER) USER_MEASURE1, CAST(NULL AS NUMBER) USER_MEASURE2, CAST(NULL AS NUMBER) USER_MEASURE3, CAST(NULL AS NUMBER) USER_MEASURE4, CAST(NULL AS NUMBER) USER_MEASURE5, mtp.ORGANIZATION_CODE SOURCE_ORG_CODE, mst.RESOURCE_DESC RESOURCE_DESCRIPTION, crd.UTILIZATION STD_UTILIZATION, crd.EFFICIENCY STD_EFFICIENCY, (SELECT flv_prod.MEANING FROM FND_LOOKUP_VALUES flv_prod WHERE flv_prod.LOOKUP_TYPE = 'MTH_YES_NO' AND flv_prod.LOOKUP_CODE = 'Y' AND flv_prod.LANGUAGE = UserEnv('LANG')) PRODUCTION_RESOURCE, CAST(NULL AS VARCHAR2(150)) BUSINESS_FUNCTION, (SELECT flv_stat.MEANING FROM FND_LOOKUP_VALUES flv_stat WHERE flv_stat.LOOKUP_TYPE = 'MTH_STATUS_TYPE' AND flv_stat.LOOKUP_CODE = 'ACTIVE' AND flv_stat.LANGUAGE = UserEnv('LANG')) STATUS, GREATEST(crd.LAST_UPDATE_DATE,mst.LAST_UPDATE_DATE ) LAST_UPDATE_DATE FROM CR_RSRC_DTL crd, CR_RSRC_MST_VL mst, MTL_PARAMETERS mtp WHERE crd.RESOURCES = mst.RESOURCES AND mtp.ORGANIZATION_ID = crd.ORGANIZATION_ID )

View Text - HTML Formatted

SELECT RESOURCE_PK
, RESOURCE_TYPE
, EBS_RESOURCE_ID
, EBS_DEPARTMENT_ID
, EBS_ORGANIZATION_ID
, USAGE_UOM
, CAPACITY_UNITS
, AVAILABLE_24_HOUR_FLAG
, SYSTEM_FK
, DISABLE_DATE
, RESOURCE_NAME
, USER_ATTR1
, USER_ATTR2
, USER_ATTR3
, USER_ATTR4
, USER_ATTR5
, USER_ATTR6
, USER_ATTR7
, USER_ATTR8
, USER_ATTR9
, USER_ATTR10
, USER_ATTR11
, USER_ATTR12
, USER_ATTR13
, USER_ATTR14
, USER_ATTR15
, USER_ATTR16
, USER_ATTR17
, USER_ATTR18
, USER_ATTR19
, USER_ATTR20
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, SOURCE_ORG_CODE
, RESOURCE_DESCRIPTION
, STD_UTILIZATION
, STD_EFFICIENCY
, PRODUCTION_RESOURCE
, BUSINESS_FUNCTION
, STATUS
, LAST_UPDATE_DATE
FROM (SELECT BR.RESOURCE_ID || '-' || BD.DEPARTMENT_ID RESOURCE_PK
, FLV_TYPE.MEANING RESOURCE_TYPE
, BR.RESOURCE_ID EBS_RESOURCE_ID
, BD.DEPARTMENT_ID EBS_DEPARTMENT_ID
, BR.ORGANIZATION_ID EBS_ORGANIZATION_ID
, BR.UNIT_OF_MEASURE USAGE_UOM
, BDR.CAPACITY_UNITS CAPACITY_UNITS
, BDR.AVAILABLE_24_HOURS_FLAG AVAILABLE_24_HOUR_FLAG
, FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK
, BR.DISABLE_DATE DISABLE_DATE
, BR.RESOURCE_CODE RESOURCE_NAME
, BR.ATTRIBUTE1 USER_ATTR1
, BR.ATTRIBUTE2 USER_ATTR2
, BR.ATTRIBUTE3 USER_ATTR3
, BR.ATTRIBUTE4 USER_ATTR4
, BR.ATTRIBUTE5 USER_ATTR5
, BR.ATTRIBUTE6 USER_ATTR6
, BR.ATTRIBUTE7 USER_ATTR7
, BR.ATTRIBUTE8 USER_ATTR8
, BR.ATTRIBUTE9 USER_ATTR9
, BR.ATTRIBUTE10 USER_ATTR10
, BR.ATTRIBUTE11 USER_ATTR11
, BR.ATTRIBUTE12 USER_ATTR12
, BR.ATTRIBUTE13 USER_ATTR13
, BR.ATTRIBUTE14 USER_ATTR14
, BR.ATTRIBUTE15 USER_ATTR15
, CAST(NULL AS VARCHAR2(150)) USER_ATTR16
, CAST(NULL AS VARCHAR2(150)) USER_ATTR17
, CAST(NULL AS VARCHAR2(150)) USER_ATTR18
, CAST(NULL AS VARCHAR2(150)) USER_ATTR19
, CAST(NULL AS VARCHAR2(150)) USER_ATTR20
, CAST(NULL AS NUMBER) USER_MEASURE1
, CAST(NULL AS NUMBER) USER_MEASURE2
, CAST(NULL AS NUMBER) USER_MEASURE3
, CAST(NULL AS NUMBER) USER_MEASURE4
, CAST(NULL AS NUMBER) USER_MEASURE5
, MP.ORGANIZATION_CODE SOURCE_ORG_CODE
, BR.DESCRIPTION RESOURCE_DESCRIPTION
, CAST(NULL AS NUMBER) STD_UTILIZATION
, CAST(NULL AS NUMBER) STD_EFFICIENCY
, (SELECT FLV_PROD.MEANING
FROM FND_LOOKUP_VALUES FLV_PROD
WHERE FLV_PROD.LOOKUP_TYPE = 'MTH_YES_NO'
AND FLV_PROD.LOOKUP_CODE = 'Y'
AND FLV_PROD.LANGUAGE = USERENV('LANG')) PRODUCTION_RESOURCE
, CAST(NULL AS VARCHAR2(100)) BUSINESS_FUNCTION
, (SELECT FLV_STAT.MEANING
FROM FND_LOOKUP_VALUES FLV_STAT
WHERE FLV_STAT.LOOKUP_TYPE = 'MTH_STATUS_TYPE'
AND FLV_STAT.LOOKUP_CODE = 'ACTIVE'
AND FLV_STAT.LANGUAGE = USERENV('LANG')) STATUS
, GREATEST(BDR.LAST_UPDATE_DATE
, BR.LAST_UPDATE_DATE) LAST_UPDATE_DATE
FROM BOM_RESOURCES BR
, BOM_DEPARTMENTS BD
, BOM_DEPARTMENT_RESOURCES BDR
, MTL_PARAMETERS MP
, FND_LOOKUP_VALUES FLV_TYPE
WHERE BDR.DEPARTMENT_ID = BD.DEPARTMENT_ID
AND BDR.RESOURCE_ID = BR.RESOURCE_ID
AND BR.RESOURCE_TYPE IN (1
, 2)
AND BR.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND FLV_TYPE.LOOKUP_TYPE = 'MTH_RESOURCE_TYPE'
AND FLV_TYPE.LOOKUP_CODE = DECODE(BR.RESOURCE_TYPE
, 1
, 'MACHINE'
, 'PERSON')
AND FLV_TYPE.LANGUAGE = USERENV('LANG') UNION ALL SELECT TO_CHAR(CRD.RESOURCE_ID) RESOURCE_PK
, CAST(NULL AS VARCHAR2(120)) RESOURCE_TYPE
, CRD.RESOURCE_ID EBS_RESOURCE_ID
, CAST(NULL AS NUMBER) EBS_DEPARTMENT_ID
, MTP.ORGANIZATION_ID EBS_ORGANIZATION_ID
, CRD.USAGE_UM USAGE_UOM
, CRD.ASSIGNED_QTY CAPACITY_UNITS
, DECODE(CRD.DAILY_AVAIL_USE
, 24
, 1
, 2) AVAIL_24_HOUR_FLAG
, FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK
, CAST(NULL AS DATE) DISABLE_DATE
, CRD.RESOURCES RESOURCE_NAME
, CAST(NULL AS VARCHAR2(150)) USER_ATTR1
, CAST(NULL AS VARCHAR2(150)) USER_ATTR2
, CAST(NULL AS VARCHAR2(150)) USER_ATTR3
, CAST(NULL AS VARCHAR2(150)) USER_ATTR4
, CAST(NULL AS VARCHAR2(150)) USER_ATTR5
, CAST(NULL AS VARCHAR2(150)) USER_ATTR6
, CAST(NULL AS VARCHAR2(150)) USER_ATTR7
, CAST(NULL AS VARCHAR2(150)) USER_ATTR8
, CAST(NULL AS VARCHAR2(150)) USER_ATTR9
, CAST(NULL AS VARCHAR2(150)) USER_ATTR10
, CAST(NULL AS VARCHAR2(150)) USER_ATTR11
, CAST(NULL AS VARCHAR2(150)) USER_ATTR12
, CAST(NULL AS VARCHAR2(150)) USER_ATTR13
, CAST(NULL AS VARCHAR2(150)) USER_ATTR14
, CAST(NULL AS VARCHAR2(150)) USER_ATTR15
, CAST(NULL AS VARCHAR2(150)) USER_ATTR16
, CAST(NULL AS VARCHAR2(150)) USER_ATTR17
, CAST(NULL AS VARCHAR2(150)) USER_ATTR18
, CAST(NULL AS VARCHAR2(150)) USER_ATTR19
, CAST(NULL AS VARCHAR2(150)) USER_ATTR20
, CAST(NULL AS NUMBER) USER_MEASURE1
, CAST(NULL AS NUMBER) USER_MEASURE2
, CAST(NULL AS NUMBER) USER_MEASURE3
, CAST(NULL AS NUMBER) USER_MEASURE4
, CAST(NULL AS NUMBER) USER_MEASURE5
, MTP.ORGANIZATION_CODE SOURCE_ORG_CODE
, MST.RESOURCE_DESC RESOURCE_DESCRIPTION
, CRD.UTILIZATION STD_UTILIZATION
, CRD.EFFICIENCY STD_EFFICIENCY
, (SELECT FLV_PROD.MEANING
FROM FND_LOOKUP_VALUES FLV_PROD
WHERE FLV_PROD.LOOKUP_TYPE = 'MTH_YES_NO'
AND FLV_PROD.LOOKUP_CODE = 'Y'
AND FLV_PROD.LANGUAGE = USERENV('LANG')) PRODUCTION_RESOURCE
, CAST(NULL AS VARCHAR2(150)) BUSINESS_FUNCTION
, (SELECT FLV_STAT.MEANING
FROM FND_LOOKUP_VALUES FLV_STAT
WHERE FLV_STAT.LOOKUP_TYPE = 'MTH_STATUS_TYPE'
AND FLV_STAT.LOOKUP_CODE = 'ACTIVE'
AND FLV_STAT.LANGUAGE = USERENV('LANG')) STATUS
, GREATEST(CRD.LAST_UPDATE_DATE
, MST.LAST_UPDATE_DATE ) LAST_UPDATE_DATE
FROM CR_RSRC_DTL CRD
, CR_RSRC_MST_VL MST
, MTL_PARAMETERS MTP
WHERE CRD.RESOURCES = MST.RESOURCES
AND MTP.ORGANIZATION_ID = CRD.ORGANIZATION_ID )