View: AHL_MR_ROUTES_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	View based on the views AHL_MR_ROUTES and AHL_ROUTES_V to include all the codes and their corresponding descriptions.
Implementation/DBA Data:	APPS.AHL_MR_ROUTES_V

View Text

SELECT A.MR_ROUTE_ID
, A.OBJECT_VERSION_NUMBER
, A.MR_HEADER_ID
, A.ROUTE_ID
, B.ROUTE_NO
, B.REVISION_NUMBER
, B.TITLE
, PDTYPE.MEANING
, OPR.PARTY_NAME
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, 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
, A.APPLICATION_USG_CODE
FROM AHL_MR_ROUTES_APP_V A
, AHL_ROUTES_APP_V B
, HZ_PARTIES OPR
, FND_LOOKUP_VALUES_VL PDTYPE
WHERE A.ROUTE_ID = B.ROUTE_ID
AND OPR.PARTY_ID (+) = B.OPERATOR_PARTY_ID
AND PDTYPE.LOOKUP_TYPE (+) = 'ITEM_TYPE'
AND PDTYPE.LOOKUP_CODE (+) = B.PRODUCT_TYPE_CODE

Columns