View: AHL_RT_OPER_RESOURCES_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	View based on the table AHL_RT_OPER_RESOURCES and the view FND_LOOKUP_VALUES_VL to include all the corresponding descriptions of the codes.
Implementation/DBA Data:	APPS.AHL_RT_OPER_RESOURCES_V

View Text

SELECT ARO.RT_OPER_RESOURCE_ID
, ARO.OBJECT_VERSION_NUMBER
, ARO.LAST_UPDATE_DATE
, ARO.LAST_UPDATED_BY
, ARO.CREATION_DATE
, ARO.CREATED_BY
, ARO.LAST_UPDATE_LOGIN
, ARO.ASSOCIATION_TYPE_CODE
, ARO.OBJECT_ID
, ARO.ASO_RESOURCE_ID
, ASO.NAME
, ASO.DESCRIPTION
, ASO.RESOURCE_TYPE_ID
, ASO.RESOURCE_TYPE
, ARO.COST_BASIS_ID
, CB.MEANING
, ARO.SCHEDULED_TYPE_ID
, ST.MEANING
, ARO.ACTIVITY_ID
, CST.ACTIVITY
, ARO.AUTOCHARGE_TYPE_ID
, ACT.MEANING
, ARO.STANDARD_RATE_FLAG
, SR.MEANING
, ARO.QUANTITY
, ARO.DURATION
, ARO.ATTRIBUTE_CATEGORY
, ARO.ATTRIBUTE1
, ARO.ATTRIBUTE2
, ARO.ATTRIBUTE3
, ARO.ATTRIBUTE4
, ARO.ATTRIBUTE5
, ARO.ATTRIBUTE6
, ARO.ATTRIBUTE7
, ARO.ATTRIBUTE8
, ARO.ATTRIBUTE9
, ARO.ATTRIBUTE10
, ARO.ATTRIBUTE11
, ARO.ATTRIBUTE12
, ARO.ATTRIBUTE13
, ARO.ATTRIBUTE14
, ARO.ATTRIBUTE15
FROM AHL_RT_OPER_RESOURCES ARO
, AHL_RESOURCES_V ASO
, MFG_LOOKUPS CB
, MFG_LOOKUPS ST
, MFG_LOOKUPS ACT
, MFG_LOOKUPS SR
, CST_ACTIVITIES CST
WHERE ASO.RESOURCE_ID = ARO.ASO_RESOURCE_ID
AND CST.ACTIVITY_ID (+) = ARO.ACTIVITY_ID
AND SR.LOOKUP_CODE (+) = ARO.STANDARD_RATE_FLAG
AND SR.LOOKUP_TYPE (+) = 'SYS_YES_NO'
AND ACT.LOOKUP_CODE (+) = ARO.AUTOCHARGE_TYPE_ID
AND ACT.LOOKUP_TYPE (+) = 'BOM_AUTOCHARGE_TYPE'
AND ST.LOOKUP_CODE (+) = ARO.SCHEDULED_TYPE_ID
AND ST.LOOKUP_TYPE (+) = 'BOM_RESOURCE_SCHEDULE_TYPE'
AND CB.LOOKUP_CODE (+) = ARO.COST_BASIS_ID
AND CB.LOOKUP_TYPE (+) = 'CST_BASIS'

Columns