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: ICX_CONFIG_MESSAGES_V

Product:	ICX - Oracle iProcurement
Description:	Configurator Validation Messages View
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CZ.ERROR_ID
, CZ.ROWID ROW_ID
, CC.NAME CONSTRAINT_NAME
, CA.CONSTRAINT_GROUP
, FND2.MEANING CONSTRAINT_GROUP_NAME
, CA.AUTOSELECTION_TYPE
, CC.CONSTRAINT_TYPE
, FND1.MEANING CONSTRAINT_TYPE_NAME
, CZ.LAST_UPDATE_DATE
, CZ.LAST_UPDATED_BY
, CZ.CREATION_DATE
, CZ.CREATED_BY
, CZ.LAST_UPDATE_LOGIN
, CC.MESSAGE_TEXT
, CZ.MESSAGE_STATUS
, CZ.SYSTEM_ID
, CZ.HEADER_ID
, AQL.QUOTE_LINE_ID LINE_ID
, CZ.GROUP_ID
, CZ.ASSIGNMENT_ID
, CZ.REQUEST_ID
, CZ.PROGRAM_APPLICATION_ID
, CZ.PROGRAM_ID
, CZ.PROGRAM_UPDATE_DATE
FROM CZ_CONSTRAINTS_VL CC
, FND_COMMON_LOOKUPS FND1
, FND_COMMON_LOOKUPS FND2
, CZ_CONSTRAINT_ASSIGNMENTS CA
, CZ_ERRORS CZ
, AS_QUOTE_LINES AQL
WHERE CZ.LINE_ID = AQL.QUOTE_LINE_ID
AND CA.ASSIGNMENT_ID = CZ.ASSIGNMENT_ID
AND CC.CONSTRAINT_ID = CA.CONSTRAINT_ID
AND FND1.LOOKUP_TYPE = 'CZ_CONSTRAINT_TYPES'
AND FND1.LOOKUP_CODE = CC.CONSTRAINT_TYPE
AND FND2.LOOKUP_TYPE = 'CZ_CONSTRAINT_GROUPS'
AND FND2.LOOKUP_CODE = CA.CONSTRAINT_GROUP

Columns

Name
ERROR_ID
ROW_ID
CONSTRAINT_NAME
CONSTRAINT_GROUP
CONSTRAINT_GROUP_NAME
AUTOSELECTION_TYPE
CONSTRAINT_TYPE
CONSTRAINT_TYPE_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
MESSAGE_TEXT
MESSAGE_STATUS
SYSTEM_ID
HEADER_ID
LINE_ID
GROUP_ID
ASSIGNMENT_ID
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE