Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AHL_ALTERNATE_RESOURCES_V |
SELECT R.ALTERNATE_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.RT_OPER_RESOURCE_ID
, R.ASO_RESOURCE_ID
, AR.RESOURCE_TYPE_ID
, AR.NAME
, AR.DESCRIPTION
, R.PRIORITY
, 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_ALTERNATE_RESOURCES R
, AHL_RESOURCES AR
WHERE R.ASO_RESOURCE_ID = AR.RESOURCE_ID