Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | Item Groups V joins Lookup meaning and Codes |
Implementation/DBA Data: | APPS.AHL_ITEM_GROUPS_V |
SELECT AHL_ITEM_GROUPS_VL.ROW_ID
, AHL_ITEM_GROUPS_VL.ITEM_GROUP_ID
, AHL_ITEM_GROUPS_VL.OBJECT_VERSION_NUMBER
, AHL_ITEM_GROUPS_VL.NAME
, AHL_ITEM_GROUPS_VL.STATUS_CODE
, FND_STAT.MEANING STATUS_MEANING
, AHL_ITEM_GROUPS_VL.TYPE_CODE
, FND_TYPE.MEANING TYPE_MEANING
, AHL_ITEM_GROUPS_VL.SOURCE_ITEM_GROUP_ID
, AHL_ITEM_GROUPS_VL.CREATION_DATE
, AHL_ITEM_GROUPS_VL.CREATED_BY
, AHL_ITEM_GROUPS_VL.LAST_UPDATE_DATE
, AHL_ITEM_GROUPS_VL.LAST_UPDATED_BY
, AHL_ITEM_GROUPS_VL.LAST_UPDATE_LOGIN
, AHL_ITEM_GROUPS_VL.ATTRIBUTE_CATEGORY
, AHL_ITEM_GROUPS_VL.ATTRIBUTE1
, AHL_ITEM_GROUPS_VL.ATTRIBUTE2
, AHL_ITEM_GROUPS_VL.ATTRIBUTE3
, AHL_ITEM_GROUPS_VL.ATTRIBUTE4
, AHL_ITEM_GROUPS_VL.ATTRIBUTE5
, AHL_ITEM_GROUPS_VL.ATTRIBUTE6
, AHL_ITEM_GROUPS_VL.ATTRIBUTE7
, AHL_ITEM_GROUPS_VL.ATTRIBUTE8
, AHL_ITEM_GROUPS_VL.ATTRIBUTE9
, AHL_ITEM_GROUPS_VL.ATTRIBUTE10
, AHL_ITEM_GROUPS_VL.ATTRIBUTE11
, AHL_ITEM_GROUPS_VL.ATTRIBUTE12
, AHL_ITEM_GROUPS_VL.ATTRIBUTE13
, AHL_ITEM_GROUPS_VL.ATTRIBUTE14
, AHL_ITEM_GROUPS_VL.ATTRIBUTE15
, AHL_ITEM_GROUPS_VL.DESCRIPTION
FROM AHL_ITEM_GROUPS_VL
, FND_LOOKUP_VALUES_VL FND_STAT
, FND_LOOKUP_VALUES_VL FND_TYPE
WHERE FND_STAT.LOOKUP_CODE(+)= AHL_ITEM_GROUPS_VL.STATUS_CODE
AND FND_STAT.LOOKUP_TYPE(+)='AHL_ITEMGROUP_STATUS'
AND FND_TYPE.LOOKUP_CODE(+)= AHL_ITEM_GROUPS_VL.TYPE_CODE
AND FND_TYPE.LOOKUP_TYPE(+)='AHL_ITEMGROUP_TYPE'