VIEW: APPS.AHL_MR_ROUTES_V

Source

View Text - Preformatted

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, RTYPE.MEANING, OPR.PARTY_NAME, B.START_DATE_ACTIVE, B.END_DATE_ACTIVE, A.STAGE, B.TIME_SPAN, 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, A.STAGE_TYPE_CODE, STAGETYPE.MEANING STAGE_TYPE_MEANING FROM AHL_MR_ROUTES_APP_V A, AHL_ROUTES_APP_V B, HZ_PARTIES OPR, FND_LOOKUP_VALUES_VL PDTYPE, FND_LOOKUP_VALUES_VL RTYPE, FND_LOOKUP_VALUES_VL STAGETYPE 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 AND RTYPE.LOOKUP_TYPE (+) = 'AHL_ROUTE_TYPE' AND RTYPE.LOOKUP_CODE (+) = B.ROUTE_TYPE_CODE AND STAGETYPE.LOOKUP_TYPE (+) = 'AHL_VWP_STAGE_TYPE' AND STAGETYPE.LOOKUP_CODE (+) = A.STAGE_TYPE_CODE

View Text - HTML Formatted

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
, RTYPE.MEANING
, OPR.PARTY_NAME
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, A.STAGE
, B.TIME_SPAN
, 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
, A.STAGE_TYPE_CODE
, STAGETYPE.MEANING STAGE_TYPE_MEANING
FROM AHL_MR_ROUTES_APP_V A
, AHL_ROUTES_APP_V B
, HZ_PARTIES OPR
, FND_LOOKUP_VALUES_VL PDTYPE
, FND_LOOKUP_VALUES_VL RTYPE
, FND_LOOKUP_VALUES_VL STAGETYPE
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
AND RTYPE.LOOKUP_TYPE (+) = 'AHL_ROUTE_TYPE'
AND RTYPE.LOOKUP_CODE (+) = B.ROUTE_TYPE_CODE
AND STAGETYPE.LOOKUP_TYPE (+) = 'AHL_VWP_STAGE_TYPE'
AND STAGETYPE.LOOKUP_CODE (+) = A.STAGE_TYPE_CODE