View: AHL_PRODTYPE_ZONES_V

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

View Text

SELECT PRODTYPE_ZONE_ID
, OBJECT_VERSION_NUMBER
, AOB.LAST_UPDATE_DATE
, AOB.LAST_UPDATED_BY
, AOB.CREATION_DATE
, AOB.CREATED_BY
, AOB.LAST_UPDATE_LOGIN
, PRODUCT_TYPE_CODE
, PRODTY.MEANING PROD_TYPE_MEANING
, PRODTY.DESCRIPTION PROD_TYPE_DESCRIPTION
, ZONE_CODE
, ZONE.MEANING ZONE_MEANING
, ZONE.DESCRIPTION ZONE_DESCRIPTION
, SUB_ZONE_CODE
, SUBZONE.MEANING SUB_ZONE_MEANING
, SUBZONE.DESCRIPTION SUB_ZONE_DESCRIPTION
, AOB.ATTRIBUTE_CATEGORY
, AOB.ATTRIBUTE1
, AOB.ATTRIBUTE2
, AOB.ATTRIBUTE3
, AOB.ATTRIBUTE4
, AOB.ATTRIBUTE5
, AOB.ATTRIBUTE6
, AOB.ATTRIBUTE7
, AOB.ATTRIBUTE8
, AOB.ATTRIBUTE9
, AOB.ATTRIBUTE10
, AOB.ATTRIBUTE11
, AOB.ATTRIBUTE12
, AOB.ATTRIBUTE13
, AOB.ATTRIBUTE14
, AOB.ATTRIBUTE15
FROM AHL_PRODTYPE_ZONES AOB
, FND_LOOKUP_VALUES_VL PRODTY
, FND_LOOKUP_VALUES_VL ZONE
, FND_LOOKUP_VALUES_VL SUBZONE
WHERE PRODTY.LOOKUP_TYPE (+)= 'ITEM_TYPE'
AND PRODTY.LOOKUP_CODE (+)= AOB.PRODUCT_TYPE_CODE
AND ZONE.LOOKUP_TYPE (+)= 'AHL_ZONE'
AND ZONE.LOOKUP_CODE (+) = AOB.ZONE_CODE
AND SUBZONE.LOOKUP_TYPE (+)= 'AHL_SUB_ZONE'
AND SUBZONE.LOOKUP_CODE (+) = AOB.SUB_ZONE_CODE

Columns