VIEW: APPS.AHL_MR_ACTIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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