View: AHL_ROUTES_V

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

View Text

SELECT DISTINCT R.ROUTE_ID
, R.OBJECT_VERSION_NUMBER
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, R.CREATION_DATE
, R.CREATED_BY
, R.LAST_UPDATE_LOGIN
, R.ROUTE_NO
, R.REVISION_NUMBER
, R.REVISION_STATUS_CODE
, REVST.MEANING
, R.SUMMARY_FLAG
, R.ENABLED_FLAG
, R.START_DATE_ACTIVE
, R.END_DATE_ACTIVE
, R.OPERATOR_PARTY_ID
, OPR.PARTY_NAME
, R.SERVICE_ITEM_ID
, R.SERVICE_ITEM_ORG_ID
, MTL.CONCATENATED_SEGMENTS
, R.TASK_TEMPLATE_GROUP_ID
, TSK.TEMPLATE_GROUP_NAME
, R.ACCOUNTING_CLASS_CODE
, R.ACCOUNTING_CLASS_ORG_ID
, ACC.DESCRIPTION
, R.ROUTE_TYPE_CODE
, RTTYPE.MEANING
, R.PRODUCT_TYPE_CODE
, PDTYPE.MEANING
, R.ZONE_CODE
, ZONE.MEANING
, R.SUB_ZONE_CODE
, SUBZONE.MEANING
, R.PROCESS_CODE
, PROCESS.MEANING
, R.APPLICATION_USG_CODE
, R.TIME_SPAN
, R.QA_INSPECTION_TYPE
, QAL.DESCRIPTION
, R.SEGMENT1
, R.SEGMENT2
, R.SEGMENT3
, R.SEGMENT4
, R.SEGMENT5
, R.SEGMENT6
, R.SEGMENT7
, R.SEGMENT8
, R.SEGMENT9
, R.SEGMENT10
, R.SEGMENT11
, R.SEGMENT12
, R.SEGMENT13
, R.SEGMENT14
, R.SEGMENT15
, R.CONCATENATED_SEGMENTS
, R.TITLE
, R.REMARKS
, R.REVISION_NOTES
, R.APPROVER_NOTE
, R.ATTRIBUTE_CATEGORY
, R.ATTRIBUTE1
, R.ATTRIBUTE2
, R.ATTRIBUTE3
, R.ATTRIBUTE4
, R.ATTRIBUTE5
, R.ATTRIBUTE6
, R.ATTRIBUTE7
, R.ATTRIBUTE8
, R.ATTRIBUTE9
, R.ATTRIBUTE10
, R.ATTRIBUTE11
, R.ATTRIBUTE12
, R.ATTRIBUTE13
, R.ATTRIBUTE14
, R.ATTRIBUTE15
FROM AHL_ROUTES_APP_V R
, FND_LOOKUP_VALUES_VL REVST
, FND_LOOKUP_VALUES_VL RTTYPE
, FND_LOOKUP_VALUES_VL PDTYPE
, FND_LOOKUP_VALUES_VL ZONE
, FND_LOOKUP_VALUES_VL SUBZONE
, FND_LOOKUP_VALUES_VL PROCESS
, HZ_PARTIES OPR
, MTL_SYSTEM_ITEMS_KFV MTL
, JTF_TASK_TEMP_GROUPS_VL TSK
, WIP_ACCOUNTING_CLASSES ACC
, QA_CHAR_VALUE_LOOKUPS_V QAL
WHERE REVST.LOOKUP_TYPE = 'AHL_REVISION_STATUS'
AND REVST.LOOKUP_CODE = R.REVISION_STATUS_CODE
AND RTTYPE.LOOKUP_TYPE (+) = 'AHL_ROUTE_TYPE'
AND RTTYPE.LOOKUP_CODE (+) = R.ROUTE_TYPE_CODE
AND PDTYPE.LOOKUP_TYPE (+) = 'ITEM_TYPE'
AND PDTYPE.LOOKUP_CODE (+) = R.PRODUCT_TYPE_CODE
AND ZONE.LOOKUP_TYPE (+) = 'AHL_ZONE'
AND ZONE.LOOKUP_CODE (+) = R.ZONE_CODE
AND SUBZONE.LOOKUP_TYPE (+) = 'AHL_SUB_ZONE'
AND SUBZONE.LOOKUP_CODE (+) = R.SUB_ZONE_CODE
AND PROCESS.LOOKUP_TYPE (+) = 'AHL_PROCESS_CODE'
AND PROCESS.LOOKUP_CODE (+) = R.PROCESS_CODE
AND OPR.PARTY_ID (+) = R.OPERATOR_PARTY_ID
AND MTL.INVENTORY_ITEM_ID (+) = R.SERVICE_ITEM_ID
AND MTL.ORGANIZATION_ID (+) = R.SERVICE_ITEM_ORG_ID
AND TSK.TASK_TEMPLATE_GROUP_ID (+) = R.TASK_TEMPLATE_GROUP_ID
AND ACC.CLASS_CODE (+) = R.ACCOUNTING_CLASS_CODE
AND ACC.ORGANIZATION_ID (+) = R.ACCOUNTING_CLASS_ORG_ID
AND QAL.SHORT_CODE (+) = R.QA_INSPECTION_TYPE

Columns