[Home] [Help]
| Product: | BOM - Bills of Material |
|---|---|
| Description: | Errors with clauses |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CEC.ERROR_CLAUSE_ID
, CEC.ROWID ROW_ID
, C.NAME CONSTRAINT_NAME
, CCC.CLAUSE_ID
, CCC.NAME CLAUSE_NAME
, CEC.ERROR_ID
, CEC.LAST_UPDATE_DATE
, CEC.LAST_UPDATED_BY
, CEC.CREATION_DATE
, CEC.CREATED_BY
, CEC.LAST_UPDATE_LOGIN
, CCC.OPERATOR
, CCC.PREFIX||F1.MEANING||'('||AKA1.NAME||')'||':'||RESULT1|| COMP.MEANING ||F2.MEANING||'('||AKA2.NAME||')'||':'||RESULT2|| CCC.SUFFIX CLAUSE_DESCRIPTION
, CEC.REQUEST_ID
, CEC.PROGRAM_APPLICATION_ID
, CEC.PROGRAM_ID
, CEC.PROGRAM_UPDATE_DATE
FROM AK_ATTRIBUTES_VL AKA1
, AK_ATTRIBUTES_VL AKA2
, FND_COMMON_LOOKUPS F1
, FND_COMMON_LOOKUPS F2
, FND_COMMON_LOOKUPS OP
, FND_COMMON_LOOKUPS COMP
, CZ_CONSTRAINTS C
, CZ_CONSTRAINT_CLAUSES CCC
, CZ_ERROR_CLAUSES CEC
WHERE CCC.CLAUSE_ID = CEC.CLAUSE_ID
AND C.CONSTRAINT_ID = CCC.CONSTRAINT_ID
AND AKA1.ATTRIBUTE_CODE = CCC.ATTRIBUTE_CODE1
AND AKA2.ATTRIBUTE_CODE(+) = DECODE(CCC.FUNCTION2
, 'LIT_NUM'
, ''
, 'LIT_CHAR'
, ''
, CCC.ATTRIBUTE_CODE2 )
AND F1.LOOKUP_TYPE = 'CZ_FUNCTIONS'
AND F1.LOOKUP_CODE = CCC.FUNCTION1
AND F2.LOOKUP_TYPE = 'CZ_FUNCTIONS'
AND F2.LOOKUP_CODE = CCC.FUNCTION2
AND OP.LOOKUP_TYPE = 'CZ_OPERATORS'
AND OP.LOOKUP_CODE = CCC.OPERATOR
AND COMP.LOOKUP_TYPE = 'CZ_COMPARATORS'
AND COMP.LOOKUP_CODE = CCC.COMPARATOR