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_EQUIP_ENTITIES_V

Source

View Text - Preformatted


SELECT ENTIY_PK, ENTITY_NAME, ENTITY_TYPE, SYSTEM_FK, USER_ATTR1, USER_ATTR2, USER_ATTR3, USER_ATTR4, USER_ATTR5, USER_MEASURE1, USER_MEASURE2, USER_MEASURE3, USER_MEASURE4, USER_MEASURE5, PRODUCTION_ENTITY, STATUS, DESCRIPTION, BUSINESS_FUNCTION, AREA, HEAD_COUNT, EFFECTIVE_DATE, SOURCE_ORG_CODE, LAST_UPDATE_DATE FROM (SELECT to_char(bd.DEPARTMENT_ID) ENTIY_PK, bd.DEPARTMENT_CODE ENTITY_NAME, (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'MTH_USER_DEFINED_ENTITIES' AND LOOKUP_CODE = 'DEPARTMENT' AND LANGUAGE = UserEnv('LANG')) ENTITY_TYPE, fnd_profile.value('MTH_EBS_GLOBAL_NAME') SYSTEM_FK, bd.ATTRIBUTE1 USER_ATTR1, bd.ATTRIBUTE2 USER_ATTR2, bd.ATTRIBUTE3 USER_ATTR3, bd.ATTRIBUTE4 USER_ATTR4, bd.ATTRIBUTE5 USER_ATTR5, 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, (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'MTH_YES_NO' AND LOOKUP_CODE = 'Y' AND LANGUAGE = UserEnv('LANG')) PRODUCTION_ENTITY, (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'MTH_STATUS_TYPE' AND LOOKUP_CODE = 'ACTIVE' AND LANGUAGE = UserEnv('LANG')) STATUS, bd.DESCRIPTION DESCRIPTION, CAST(NULL AS VARCHAR2(100)) BUSINESS_FUNCTION, CAST(NULL AS NUMBER) AREA, CAST(NULL AS NUMBER) HEAD_COUNT, CAST(NULL AS DATE) EFFECTIVE_DATE, MP.ORGANIZATION_CODE SOURCE_ORG_CODE, bd.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM BOM_DEPARTMENTS bd, MTL_PARAMETERS MP WHERE bd.ORGANIZATION_ID = MP.ORGANIZATION_ID UNION ALL SELECT fnd_crp.lookup_code ENTIY_PK, fnd_crp.meaning ENTITY_NAME, (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'MTH_USER_DEFINED_ENTITIES' AND LOOKUP_CODE = 'RESOURCE GROUP' AND LANGUAGE = UserEnv('LANG')) ENTITY_TYPE, fnd_profile.value('MTH_EBS_GLOBAL_NAME') SYSTEM_FK, NULL USER_ATTR1, NULL USER_ATTR2, NULL USER_ATTR3, NULL USER_ATTR4, NULL USER_ATTR5, 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, (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'MTH_YES_NO' AND LOOKUP_CODE = 'Y' AND LANGUAGE = UserEnv('LANG')) PRODUCTION_ENTITY, (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'MTH_STATUS_TYPE' AND LOOKUP_CODE = 'ACTIVE' AND LANGUAGE = UserEnv('LANG')) STATUS, fnd_crp.DESCRIPTION DESCRIPTION, CAST(NULL AS VARCHAR2(100)) BUSINESS_FUNCTION, CAST(NULL AS NUMBER) AREA, CAST(NULL AS NUMBER) HEAD_COUNT, CAST(NULL AS DATE) EFFECTIVE_DATE, NULL SOURCE_ORG_CODE, fnd_crp.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM fnd_lookup_values fnd_crp WHERE fnd_crp.LOOKUP_TYPE ='CRP_RESOURCE_GROUPS' AND fnd_crp.LANGUAGE = USERENV('LANG') AND NOT EXISTS (SELECT 1 FROM CR_RSRC_CLS crc WHERE fnd_crp.lookup_code = crc.RESOURCE_CLASS) UNION ALL SELECT crc.RESOURCE_CLASS ENTITY_PK, crc.RESOURCE_CLASS ENTITY_NAME, (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'MTH_USER_DEFINED_ENTITIES' AND LOOKUP_CODE = 'RESOURCE GROUP' AND LANGUAGE = UserEnv('LANG')) ENTITY_TYPE, fnd_profile.value('MTH_EBS_GLOBAL_NAME') SYSTEM_FK, 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 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, (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'MTH_YES_NO' AND LOOKUP_CODE = 'Y' AND LANGUAGE = UserEnv('LANG')) PRODUCTION_ENTITY, (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'MTH_STATUS_TYPE' AND LOOKUP_CODE = 'ACTIVE' AND LANGUAGE = UserEnv('LANG')) STATUS, CAST(NULL AS VARCHAR2(150)) DESCRIPTION, CAST(NULL AS VARCHAR2(100)) BUSINESS_FUNCTION, CAST(NULL AS NUMBER) AREA, CAST(NULL AS NUMBER) HEAD_COUNT, CAST(NULL AS DATE) EFFECTIVE_DATE, CAST(NULL AS VARCHAR2(150)) SOURCE_ORG_CODE, crc.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM CR_RSRC_CLS crc UNION ALL SELECT res.GROUP_RESOURCE ENTITY_PK, res.GROUP_RESOURCE ENTITY_NAME, (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'MTH_USER_DEFINED_ENTITIES' AND LOOKUP_CODE = 'DEPARTMENT' AND LANGUAGE = UserEnv('LANG')) ENTITY_TYPE, fnd_profile.value('MTH_EBS_GLOBAL_NAME') SYSTEM_FK, 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 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, (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'MTH_YES_NO' AND LOOKUP_CODE = 'Y' AND LANGUAGE = UserEnv('LANG')) PRODUCTION_ENTITY, (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'MTH_STATUS_TYPE' AND LOOKUP_CODE = 'ACTIVE' AND LANGUAGE = UserEnv('LANG')) STATUS, CAST(NULL AS VARCHAR2(150)) DESCRIPTION, CAST(NULL AS VARCHAR2(100)) BUSINESS_FUNCTION, CAST(NULL AS NUMBER) AREA, CAST(NULL AS NUMBER) HEAD_COUNT, CAST(NULL AS DATE) EFFECTIVE_DATE, res.ORGANIZATION_CODE SOURCE_ORG_CODE, res.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM (SELECT mtp.ORGANIZATION_CODE, crd.GROUP_RESOURCE, GREATEST(Min(crd.LAST_UPDATE_DATE),Min(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 GROUP BY mtp.ORGANIZATION_CODE, crd.GROUP_RESOURCE) res)

View Text - HTML Formatted

SELECT ENTIY_PK
, ENTITY_NAME
, ENTITY_TYPE
, SYSTEM_FK
, USER_ATTR1
, USER_ATTR2
, USER_ATTR3
, USER_ATTR4
, USER_ATTR5
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, PRODUCTION_ENTITY
, STATUS
, DESCRIPTION
, BUSINESS_FUNCTION
, AREA
, HEAD_COUNT
, EFFECTIVE_DATE
, SOURCE_ORG_CODE
, LAST_UPDATE_DATE
FROM (SELECT TO_CHAR(BD.DEPARTMENT_ID) ENTIY_PK
, BD.DEPARTMENT_CODE ENTITY_NAME
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'MTH_USER_DEFINED_ENTITIES'
AND LOOKUP_CODE = 'DEPARTMENT'
AND LANGUAGE = USERENV('LANG')) ENTITY_TYPE
, FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK
, BD.ATTRIBUTE1 USER_ATTR1
, BD.ATTRIBUTE2 USER_ATTR2
, BD.ATTRIBUTE3 USER_ATTR3
, BD.ATTRIBUTE4 USER_ATTR4
, BD.ATTRIBUTE5 USER_ATTR5
, 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
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'MTH_YES_NO'
AND LOOKUP_CODE = 'Y'
AND LANGUAGE = USERENV('LANG')) PRODUCTION_ENTITY
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'MTH_STATUS_TYPE'
AND LOOKUP_CODE = 'ACTIVE'
AND LANGUAGE = USERENV('LANG')) STATUS
, BD.DESCRIPTION DESCRIPTION
, CAST(NULL AS VARCHAR2(100)) BUSINESS_FUNCTION
, CAST(NULL AS NUMBER) AREA
, CAST(NULL AS NUMBER) HEAD_COUNT
, CAST(NULL AS DATE) EFFECTIVE_DATE
, MP.ORGANIZATION_CODE SOURCE_ORG_CODE
, BD.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM BOM_DEPARTMENTS BD
, MTL_PARAMETERS MP
WHERE BD.ORGANIZATION_ID = MP.ORGANIZATION_ID UNION ALL SELECT FND_CRP.LOOKUP_CODE ENTIY_PK
, FND_CRP.MEANING ENTITY_NAME
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'MTH_USER_DEFINED_ENTITIES'
AND LOOKUP_CODE = 'RESOURCE GROUP'
AND LANGUAGE = USERENV('LANG')) ENTITY_TYPE
, FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK
, NULL USER_ATTR1
, NULL USER_ATTR2
, NULL USER_ATTR3
, NULL USER_ATTR4
, NULL USER_ATTR5
, 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
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'MTH_YES_NO'
AND LOOKUP_CODE = 'Y'
AND LANGUAGE = USERENV('LANG')) PRODUCTION_ENTITY
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'MTH_STATUS_TYPE'
AND LOOKUP_CODE = 'ACTIVE'
AND LANGUAGE = USERENV('LANG')) STATUS
, FND_CRP.DESCRIPTION DESCRIPTION
, CAST(NULL AS VARCHAR2(100)) BUSINESS_FUNCTION
, CAST(NULL AS NUMBER) AREA
, CAST(NULL AS NUMBER) HEAD_COUNT
, CAST(NULL AS DATE) EFFECTIVE_DATE
, NULL SOURCE_ORG_CODE
, FND_CRP.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM FND_LOOKUP_VALUES FND_CRP
WHERE FND_CRP.LOOKUP_TYPE ='CRP_RESOURCE_GROUPS'
AND FND_CRP.LANGUAGE = USERENV('LANG')
AND NOT EXISTS (SELECT 1
FROM CR_RSRC_CLS CRC
WHERE FND_CRP.LOOKUP_CODE = CRC.RESOURCE_CLASS) UNION ALL SELECT CRC.RESOURCE_CLASS ENTITY_PK
, CRC.RESOURCE_CLASS ENTITY_NAME
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'MTH_USER_DEFINED_ENTITIES'
AND LOOKUP_CODE = 'RESOURCE GROUP'
AND LANGUAGE = USERENV('LANG')) ENTITY_TYPE
, FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK
, 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 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
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'MTH_YES_NO'
AND LOOKUP_CODE = 'Y'
AND LANGUAGE = USERENV('LANG')) PRODUCTION_ENTITY
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'MTH_STATUS_TYPE'
AND LOOKUP_CODE = 'ACTIVE'
AND LANGUAGE = USERENV('LANG')) STATUS
, CAST(NULL AS VARCHAR2(150)) DESCRIPTION
, CAST(NULL AS VARCHAR2(100)) BUSINESS_FUNCTION
, CAST(NULL AS NUMBER) AREA
, CAST(NULL AS NUMBER) HEAD_COUNT
, CAST(NULL AS DATE) EFFECTIVE_DATE
, CAST(NULL AS VARCHAR2(150)) SOURCE_ORG_CODE
, CRC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM CR_RSRC_CLS CRC UNION ALL SELECT RES.GROUP_RESOURCE ENTITY_PK
, RES.GROUP_RESOURCE ENTITY_NAME
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'MTH_USER_DEFINED_ENTITIES'
AND LOOKUP_CODE = 'DEPARTMENT'
AND LANGUAGE = USERENV('LANG')) ENTITY_TYPE
, FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK
, 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 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
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'MTH_YES_NO'
AND LOOKUP_CODE = 'Y'
AND LANGUAGE = USERENV('LANG')) PRODUCTION_ENTITY
, (SELECT MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'MTH_STATUS_TYPE'
AND LOOKUP_CODE = 'ACTIVE'
AND LANGUAGE = USERENV('LANG')) STATUS
, CAST(NULL AS VARCHAR2(150)) DESCRIPTION
, CAST(NULL AS VARCHAR2(100)) BUSINESS_FUNCTION
, CAST(NULL AS NUMBER) AREA
, CAST(NULL AS NUMBER) HEAD_COUNT
, CAST(NULL AS DATE) EFFECTIVE_DATE
, RES.ORGANIZATION_CODE SOURCE_ORG_CODE
, RES.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM (SELECT MTP.ORGANIZATION_CODE
, CRD.GROUP_RESOURCE
, GREATEST(MIN(CRD.LAST_UPDATE_DATE)
, MIN(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 GROUP BY MTP.ORGANIZATION_CODE
, CRD.GROUP_RESOURCE) RES)