[Home] [Help]
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
Name |
OPERATION_PHASE_ID |
OBJECT_VERSION_NUMBER |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
OPERATION_ID |
PHASE_CODE |
PHASE_MEANING |
PHASE_DESCRIPTION |
REVISION_NUMBER |