Product: | BOM - Bills of Material |
---|---|
Description: | Attribute value errors |
Implementation/DBA Data: | Not implemented in this database |
SELECT CAV.ATTRIBUTE_VALUE_ID
, CAV.ROWID ROW_ID
, CAV.LAST_UPDATE_DATE
, CAV.LAST_UPDATED_BY
, CAV.CREATION_DATE
, CAV.CREATED_BY
, CAV.LAST_UPDATE_LOGIN
, CAV.ERROR_CLAUSE_ID
, CCC.NAME CLAUSE_NAME
, CAV.ATTRIBUTE_CODE
, AKA.NAME ATTRIBUTE_NAME
, CAV.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS ITEM_NAME
, CAV.ORGANIZATION_ID
, CAV.ATTRIBUTE_VALUE
, CAV.REQUEST_ID
, CAV.PROGRAM_APPLICATION_ID
, CAV.PROGRAM_ID
, CAV.PROGRAM_UPDATE_DATE
FROM AK_ATTRIBUTES_VL AKA
, MTL_SYSTEM_ITEMS_KFV MSI
, CZ_CONSTRAINT_CLAUSES CCC
, CZ_ERROR_CLAUSES CEC
, CZ_ERROR_ATTRIBUTE_VALUES CAV
WHERE CEC.ERROR_CLAUSE_ID = CAV.ERROR_CLAUSE_ID
AND CCC.CLAUSE_ID = CEC.CLAUSE_ID
AND MSI.INVENTORY_ITEM_ID = CAV.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = CAV.ORGANIZATION_ID
AND AKA.ATTRIBUTE_CODE = CAV.ATTRIBUTE_CODE