VIEW: APPS.AHL_RESOURCE_MAPPINGS_V

Source

View Text - Preformatted

SELECT R.RESOURCE_MAPPING_ID, R.OBJECT_VERSION_NUMBER, R.LAST_UPDATE_DATE, R.LAST_UPDATED_BY, R.CREATION_DATE, R.CREATED_BY, R.LAST_UPDATE_LOGIN, R.ASO_RESOURCE_ID, R.BOM_RESOURCE_ID, R.BOM_ORG_ID, BOM.RESOURCE_CODE, HOU.NAME, BOM.DESCRIPTION, BOM.DISABLE_DATE, BOM.RESOURCE_TYPE, MFG.MEANING, R.ATTRIBUTE_CATEGORY, R.ATTRIBUTE1, R.ATTRIBUTE2, R.ATTRIBUTE3, R.ATTRIBUTE4, R.ATTRIBUTE5, R.ATTRIBUTE6, R.ATTRIBUTE7, R.ATTRIBUTE8, R.ATTRIBUTE9, R.ATTRIBUTE10, R.ATTRIBUTE11, R.ATTRIBUTE12, R.ATTRIBUTE13, R.ATTRIBUTE14, R.ATTRIBUTE15, R.DEPARTMENT_ID, DEPT.DESCRIPTION FROM AHL_RESOURCE_MAPPINGS R, BOM_RESOURCES BOM, HR_ORGANIZATION_UNITS HOU, MFG_LOOKUPS MFG, BOM_DEPARTMENTS DEPT WHERE R.BOM_RESOURCE_ID = BOM.RESOURCE_ID AND R.BOM_ORG_ID = BOM.ORGANIZATION_ID AND R.BOM_ORG_ID = HOU.ORGANIZATION_ID AND MFG.LOOKUP_TYPE (+) = 'BOM_RESOURCE_TYPE' AND MFG.LOOKUP_CODE (+) = BOM.RESOURCE_TYPE AND R.DEPARTMENT_ID = DEPT.DEPARTMENT_ID (+)

View Text - HTML Formatted

SELECT R.RESOURCE_MAPPING_ID
, R.OBJECT_VERSION_NUMBER
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, R.CREATION_DATE
, R.CREATED_BY
, R.LAST_UPDATE_LOGIN
, R.ASO_RESOURCE_ID
, R.BOM_RESOURCE_ID
, R.BOM_ORG_ID
, BOM.RESOURCE_CODE
, HOU.NAME
, BOM.DESCRIPTION
, BOM.DISABLE_DATE
, BOM.RESOURCE_TYPE
, MFG.MEANING
, R.ATTRIBUTE_CATEGORY
, R.ATTRIBUTE1
, R.ATTRIBUTE2
, R.ATTRIBUTE3
, R.ATTRIBUTE4
, R.ATTRIBUTE5
, R.ATTRIBUTE6
, R.ATTRIBUTE7
, R.ATTRIBUTE8
, R.ATTRIBUTE9
, R.ATTRIBUTE10
, R.ATTRIBUTE11
, R.ATTRIBUTE12
, R.ATTRIBUTE13
, R.ATTRIBUTE14
, R.ATTRIBUTE15
, R.DEPARTMENT_ID
, DEPT.DESCRIPTION
FROM AHL_RESOURCE_MAPPINGS R
, BOM_RESOURCES BOM
, HR_ORGANIZATION_UNITS HOU
, MFG_LOOKUPS MFG
, BOM_DEPARTMENTS DEPT
WHERE R.BOM_RESOURCE_ID = BOM.RESOURCE_ID
AND R.BOM_ORG_ID = BOM.ORGANIZATION_ID
AND R.BOM_ORG_ID = HOU.ORGANIZATION_ID
AND MFG.LOOKUP_TYPE (+) = 'BOM_RESOURCE_TYPE'
AND MFG.LOOKUP_CODE (+) = BOM.RESOURCE_TYPE
AND R.DEPARTMENT_ID = DEPT.DEPARTMENT_ID (+)