View: OE_PC_CONSTRAINT_CNDS_V

Product:	ONT - Order Management
Description:	This view stores the conditions of the processing constraints.
Implementation/DBA Data:	APPS.OE_PC_CONSTRAINT_CNDS_V

View Text

SELECT C.ROWID ROW_ID
, C.CONDITION_ID
, C.CONSTRAINT_ID
, C.GROUP_NUMBER
, C.CREATION_DATE
, C.CREATED_BY
, C.LAST_UPDATE_DATE
, C.LAST_UPDATED_BY
, C.LAST_UPDATE_LOGIN
, C.SYSTEM_FLAG
, C.MODIFIER_FLAG
, VE.APPLICATION_ID
, C.VALIDATION_ENTITY_ID
, VE.ENTITY_DISPLAY_NAME
, C.VALIDATION_TMPLT_ID
, V.VALIDATION_TMPLT_DISPLAY_NAME
, C.RECORD_SET_ID
, S.RECORD_SET_DISPLAY_NAME
, C.SCOPE_OP
, TL.USER_MESSAGE
, C.ATTRIBUTE_CATEGORY
, C.ATTRIBUTE1
, C.ATTRIBUTE2
, C.ATTRIBUTE3
, C.ATTRIBUTE4
, C.ATTRIBUTE5
, C.ATTRIBUTE6
, C.ATTRIBUTE7
, C.ATTRIBUTE8
, C.ATTRIBUTE9
, C.ATTRIBUTE10
, C.ATTRIBUTE11
, C.ATTRIBUTE12
, C.ATTRIBUTE13
, C.ATTRIBUTE14
, C.ATTRIBUTE15
, C.START_DATE_ACTIVE
, C.END_DATE_ACTIVE
, C.ENABLED_FLAG
FROM OE_PC_CONDITIONS C
, OE_PC_VTMPLTS_VL V
, OE_PC_RSETS_VL S
, OE_PC_ENTITIES_V VE
, OE_PC_CONDITIONS_TL TL
WHERE C.VALIDATION_ENTITY_ID = VE.ENTITY_ID
AND C.VALIDATION_TMPLT_ID = V.VALIDATION_TMPLT_ID
AND C.RECORD_SET_ID = S.RECORD_SET_ID
AND C.CONDITION_ID = TL.CONDITION_ID
AND TL.LANGUAGE = USERENV('LANG')

Columns