VIEW: APPS.AHL_ITEM_GROUPS_V

Source

View Text - Preformatted

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, AHL_ITEM_GROUPS_VL.SOURCED_FROM_ENIGMA_FLAG, FND_YN.MEANING SOURCED_FROM_ENIGMA_MEANING FROM AHL_ITEM_GROUPS_VL, FND_LOOKUP_VALUES_VL FND_STAT, FND_LOOKUP_VALUES_VL FND_TYPE, FND_LOOKUP_VALUES_VL FND_YN 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' AND FND_YN.LOOKUP_CODE(+) = NVL(AHL_ITEM_GROUPS_VL.SOURCED_FROM_ENIGMA_FLAG, 'N') AND FND_YN.LOOKUP_TYPE(+) ='AHL_YES_NO_TYPE'

View Text - HTML Formatted

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
, AHL_ITEM_GROUPS_VL.SOURCED_FROM_ENIGMA_FLAG
, FND_YN.MEANING SOURCED_FROM_ENIGMA_MEANING
FROM AHL_ITEM_GROUPS_VL
, FND_LOOKUP_VALUES_VL FND_STAT
, FND_LOOKUP_VALUES_VL FND_TYPE
, FND_LOOKUP_VALUES_VL FND_YN
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'
AND FND_YN.LOOKUP_CODE(+) = NVL(AHL_ITEM_GROUPS_VL.SOURCED_FROM_ENIGMA_FLAG
, 'N')
AND FND_YN.LOOKUP_TYPE(+) ='AHL_YES_NO_TYPE'