View: CZ_ITEM_ATTRIBUTE_VALUES_V

View Text

SELECT IAV.ROWID ROW_ID
, IAV.DATABASE_OBJECT_NAME
, IAV.KEY_VALUE1
, IAV.KEY_VALUE2
, IAV.ATTRIBUTE_APPLICATION_ID
, IAV.ATTRIBUTE_CODE
, AKA.DATA_TYPE
, ART.NAME LIST_TYPE
, ARI.REGION_CODE REGION_CODE
, DECODE( AKA.DATA_TYPE
, 'NUMBER'
, TO_CHAR( IAV.VALUE_NUMBER )
, IAV.VALUE_VARCHAR2 ) ATTRIBUTE_VALUE
, IAV.CREATION_DATE
, IAV.CREATED_BY
, IAV.LAST_UPDATE_DATE
, IAV.LAST_UPDATED_BY
, IAV.LAST_UPDATE_LOGIN
, MSI.CONCATENATED_SEGMENTS ITEM
, MSI.DESCRIPTION DESCRIPTION
FROM AK_INST_ATTRIBUTE_VALUES IAV
, MTL_SYSTEM_ITEMS_KFV MSI
, AK_ATTRIBUTES AKA
, AK_REGIONS_TL ART
, AK_REGION_ITEMS ARI
WHERE IAV.ATTRIBUTE_APPLICATION_ID = 702
AND IAV.DATABASE_OBJECT_NAME = 'MTL_SYSTEM_ITEMS_KFV'
AND AKA.ATTRIBUTE_APPLICATION_ID = 702
AND AKA.ATTRIBUTE_CODE = IAV.ATTRIBUTE_CODE
AND TO_CHAR(MSI.INVENTORY_ITEM_ID) = IAV.KEY_VALUE2
AND TO_CHAR(MSI.ORGANIZATION_ID) = IAV.KEY_VALUE1
AND ART.REGION_APPLICATION_ID(+) = 702
AND ART.REGION_CODE(+) = AKA.LOV_REGION_CODE
AND ARI.ATTRIBUTE_APPLICATION_ID = 702
AND ARI.ATTRIBUTE_CODE = IAV.ATTRIBUTE_CODE

Columns