Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | View based on the views AHL_PROG_TYPE_SUBTYPES,FND_LOOKUP_VALUES_VL and FND_LOOKUP_VALUES_VL |
Implementation/DBA Data: | APPS.AHL_PROG_TYPE_SUBTYPES_V |
SELECT REL.PROG_TYPE_SUBTYPE_ID
, REL.OBJECT_VERSION_NUMBER
, REL.PROGRAM_TYPE_CODE
, PT.MEANING
, PT.DESCRIPTION
, REL.PROGRAM_SUBTYPE_CODE
, ST.MEANING
, ST.DESCRIPTION
, REL.ATTRIBUTE_CATEGORY
, REL.ATTRIBUTE1
, REL.ATTRIBUTE2
, REL.ATTRIBUTE3
, REL.ATTRIBUTE4
, REL.ATTRIBUTE5
, REL.ATTRIBUTE6
, REL.ATTRIBUTE7
, REL.ATTRIBUTE8
, REL.ATTRIBUTE9
, REL.ATTRIBUTE10
, REL.ATTRIBUTE11
, REL.ATTRIBUTE12
, REL.ATTRIBUTE13
, REL.ATTRIBUTE14
, REL.ATTRIBUTE15
FROM AHL_PROG_TYPE_SUBTYPES REL
, FND_LOOKUP_VALUES_VL PT
, FND_LOOKUP_VALUES_VL ST
WHERE PT.LOOKUP_TYPE = 'AHL_FMP_MR_PROGRAM_TYPE'
AND PT.LOOKUP_CODE = REL.PROGRAM_TYPE_CODE
AND ST.LOOKUP_TYPE = 'AHL_FMP_MR_PROGRAM_SUBTYPE'
AND ST.LOOKUP_CODE = REL.PROGRAM_SUBTYPE_CODE