[Home] [Help]
View: CZBV_CONFIGURATION_CONSTRAINTS
Product: | BOM - Bills of Material |
Description: | - Retrofitted |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT CO.CONSTRAINT_ID
, CO.NAME
, CO.DESCRIPTION
, COLO.MEANING
, COTL.MESSAGE_TEXT
, CO.CREATION_DATE
, CO.CREATED_BY
, CO.LAST_UPDATE_DATE
, CO.LAST_UPDATED_BY
FROM FND_COMMON_LOOKUPS COLO
, CZ_CONSTRAINT_MESSAGES_TL COTL
, CZ_CONSTRAINTS CO
WHERE CO.CONSTRAINT_ID = COTL.CONSTRAINT_ID
AND COTL.LANGUAGE = SUBSTR(USERENV('LANGUAGE')
, 1
, INSTR(USERENV('LANGUAGE')
, '_')-1)
AND CO.CONSTRAINT_TYPE = COLO.LOOKUP_CODE
AND COLO.LOOKUP_TYPE = 'CZ_CONSTRAINT_TYPES'
AND COLO.APPLICATION_ID =702 WITH READ ONLY
Columns
Name |
CONFIGURATION_CONSTRAINT_ID |
NAME |
DESCRIPTION |
TYPE |
MESSAGE_TEXT |
CREATED_DATE |
CREATED_BY |
LAST_UPDATED_DATE |
LAST_UPDATED_BY |