View: AHL_MR_ACTIONS_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	View based on the views AHL_MR_ACTIONS_VL, FND_LOOKUP_VALUES_VL and QA_PLANS
Implementation/DBA Data:	APPS.AHL_MR_ACTIONS_V

View Text

SELECT A.MR_ACTION_ID
, A.OBJECT_VERSION_NUMBER
, A.MR_HEADER_ID
, A.MR_ACTION_CODE
, F.MEANING
, A.PLAN_ID
, Q.NAME
, A.DESCRIPTION
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
FROM AHL_MR_ACTIONS_VL A
, FND_LOOKUP_VALUES_VL F
, QA_PLANS Q
WHERE F.LOOKUP_TYPE (+) = 'AHL_FMP_MR_ACTION'
AND F.LOOKUP_CODE (+) = A.MR_ACTION_CODE
AND Q.PLAN_ID (+) = A.PLAN_ID

Columns