Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | This View stores association of complete routes with Active MR's |
Implementation/DBA Data: | APPS.AHL_ROUTE_MR_V |
SELECT A.MR_ROUTE_ID
, A.OBJECT_VERSION_NUMBER
, B.MR_HEADER_ID
, B.EFFECTIVE_TO
, C.ROUTE_ID
, C.ROUTE_NO
, C.REVISION_STATUS_CODE
, 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_ROUTES A
, AHL_MR_HEADERS_V B
, AHL_ROUTES_APP_V C
WHERE B.MR_HEADER_ID = A.MR_HEADER_ID
AND C.ROUTE_ID = A.ROUTE_ID