VIEW: APPS.OE_PC_CONSTRAINT_CNDS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')