eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CZBV_CONFIG_CONSTRAINT_CLAUSES

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CO.NAME
, COCL.NAME
, COCL.SEQUENCE_NUMBER
, COCL.PREFIX
, COCL.SUFFIX
, COCL.DB_FUNCTION1
, COCL.CONSTRAINT_ID
, COCL.CLAUSE_ID
, COCL.FUNCTION1
, COCL.FUNCTION2
, COCL.DB_OBJECT_NAME1
, COCL.DB_OBJECT_NAME2
, COCL.ATTRIBUTE_CODE1
, COCL.ATTRIBUTE_CODE2
, COCL.COMPARATOR
, COCL.OPERATOR
, COCL.ACTION_IF_NULL
, COCL.CREATION_DATE
, COCL.CREATED_BY
, COCL.LAST_UPDATE_DATE
, COCL.LAST_UPDATED_BY
FROM CZ_CONSTRAINTS CO
, CZ_CONSTRAINT_CLAUSES COCL
WHERE COCL.CONSTRAINT_ID = CO.CONSTRAINT_ID WITH READ ONLY

Columns

Name
CONSTRAINT_NAME
CONFIG_CONSTRAINT_CLAUSE_NAME
SEQUENCE_NUMBER
LEFT_PARENTHESIS
RIGHT_PARENTHESIS
USER_VALIDATION_FUNCTION
CONSTRAINT_ID
CONFIG_CONSTRAINT_CLAUSE_ID
FUNCTION1
FUNCTION2
DB_OBJECT_NAME1
DB_OBJECT_NAME2
ATTRIBUTE_CODE1
ATTRIBUTE_CODE2
COMPARATOR
OPERATOR
ACTION_IF_NULL
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY