[Home] [Help]
View: AHL_RESOURCES_V
Product: | AHL - Complex Maintenance Repair and Overhaul |
Description: | |
Implementation/DBA Data: |
APPS.AHL_RESOURCES_V
|
View Text
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
Columns
Name |
RESOURCE_ID |
OBJECT_VERSION_NUMBER |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
NAME |
RESOURCE_TYPE_ID |
RESOURCE_TYPE |
DESCRIPTION |
ATTRIBUTE_CATEGORY |
ATTRIBUTE1 |
ATTRIBUTE2 |
ATTRIBUTE3 |
ATTRIBUTE4 |
ATTRIBUTE5 |
ATTRIBUTE6 |
ATTRIBUTE7 |
ATTRIBUTE8 |
ATTRIBUTE9 |
ATTRIBUTE10 |
ATTRIBUTE11 |
ATTRIBUTE12 |
ATTRIBUTE13 |
ATTRIBUTE14 |
ATTRIBUTE15 |