View: AHL_OPERATION_PHASES_V

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

View Text

SELECT OPERATION_PHASE_ID
, OBJECT_VERSION_NUMBER
, AOB.LAST_UPDATE_DATE
, AOB.LAST_UPDATED_BY
, AOB.CREATION_DATE
, AOB.CREATED_BY
, AOB.LAST_UPDATE_LOGIN
, OPERATION_ID
, PHASE_CODE
, PHASE.MEANING PHASE_MEANING
, PHASE.DESCRIPTION PHASE_DESCRIPTION
, REVISION_NUMBER
FROM AHL_OPERATION_PHASES AOB
, FND_LOOKUP_VALUES_VL PHASE
WHERE PHASE.LOOKUP_TYPE = 'AHL_PHASE_CODE'
AND PHASE.LOOKUP_CODE = AOB.PHASE_CODE

Columns