VIEW: APPS.AHL_RESOURCES_V

Source

View Text - Preformatted

SELECT R.RESOURCE_ID, R.OBJECT_VERSION_NUMBER, R.LAST_UPDATE_DATE, R.LAST_UPDATED_BY, R.CREATION_DATE, R.CREATED_BY, R.LAST_UPDATE_LOGIN, R.NAME, R.RESOURCE_TYPE_ID, MFG.MEANING, R.DESCRIPTION, 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 FROM AHL_RESOURCES R, MFG_LOOKUPS MFG WHERE MFG.lookup_type = 'BOM_RESOURCE_TYPE' AND MFG.lookup_code = R.resource_type_id

View Text - HTML Formatted

SELECT R.RESOURCE_ID
, R.OBJECT_VERSION_NUMBER
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, R.CREATION_DATE
, R.CREATED_BY
, R.LAST_UPDATE_LOGIN
, R.NAME
, R.RESOURCE_TYPE_ID
, MFG.MEANING
, R.DESCRIPTION
, 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
FROM AHL_RESOURCES R
, MFG_LOOKUPS MFG
WHERE MFG.LOOKUP_TYPE = 'BOM_RESOURCE_TYPE'
AND MFG.LOOKUP_CODE = R.RESOURCE_TYPE_ID