VIEW: APPS.OE_PC_CONDITIONS_V

Source

View Text - Preformatted

SELECT r.rowid row_id ,r.condition_id ,r.constraint_id ,e.application_id ,c.entity_id ,e.entity_code entity_short_name ,r.group_number ,r.creation_date ,r.created_by ,r.last_update_date ,r.last_updated_by ,r.last_update_login ,r.system_flag ,r.modifier_flag ,ve.application_id validation_application_id ,r.validation_entity_id ,ve.entity_code validation_entity_short_name ,r.validation_tmplt_id ,v.validation_tmplt_short_name ,r.record_set_id ,s.record_set_short_name ,r.scope_op ,decode(v.validation_type, 'API', v.api_pkg, 'OE_' || substr(to_char(c.entity_id), 1, 6)|| 'PC' || substr(to_char(r.validation_entity_id), 1, 6)||'_'|| s.record_set_short_name|| '_' || v.validation_tmplt_short_name) validation_pkg ,decode(v.validation_type, 'API', v.api_proc, 'Is_Valid') validation_proc ,r.attribute_category ,r.attribute1 ,r.attribute2 ,r.attribute3 ,r.attribute4 ,r.attribute5 ,r.attribute6 ,r.attribute7 ,r.attribute8 ,r.attribute9 ,r.attribute10 ,r.attribute11 ,r.attribute12 ,r.attribute13 ,r.attribute14 ,r.attribute15 ,r.enabled_flag FROM OE_PC_CONDITIONS r, OE_PC_CONSTRAINTS c, OE_PC_VTMPLTS v, OE_PC_RSETS s, OE_AK_OBJECTS_EXT e, OE_AK_OBJECTS_EXT ve WHERE r.constraint_id = c.constraint_id AND c.entity_id = e.entity_id AND r.validation_entity_id = ve.entity_id AND r.validation_tmplt_id = v.validation_tmplt_id AND r.record_set_id = s.record_set_id

View Text - HTML Formatted

SELECT R.ROWID ROW_ID
, R.CONDITION_ID
, R.CONSTRAINT_ID
, E.APPLICATION_ID
, C.ENTITY_ID
, E.ENTITY_CODE ENTITY_SHORT_NAME
, R.GROUP_NUMBER
, R.CREATION_DATE
, R.CREATED_BY
, R.LAST_UPDATE_DATE
, R.LAST_UPDATED_BY
, R.LAST_UPDATE_LOGIN
, R.SYSTEM_FLAG
, R.MODIFIER_FLAG
, VE.APPLICATION_ID VALIDATION_APPLICATION_ID
, R.VALIDATION_ENTITY_ID
, VE.ENTITY_CODE VALIDATION_ENTITY_SHORT_NAME
, R.VALIDATION_TMPLT_ID
, V.VALIDATION_TMPLT_SHORT_NAME
, R.RECORD_SET_ID
, S.RECORD_SET_SHORT_NAME
, R.SCOPE_OP
, DECODE(V.VALIDATION_TYPE
, 'API'
, V.API_PKG
, 'OE_' || SUBSTR(TO_CHAR(C.ENTITY_ID)
, 1
, 6)|| 'PC' || SUBSTR(TO_CHAR(R.VALIDATION_ENTITY_ID)
, 1
, 6)||'_'|| S.RECORD_SET_SHORT_NAME|| '_' || V.VALIDATION_TMPLT_SHORT_NAME) VALIDATION_PKG
, DECODE(V.VALIDATION_TYPE
, 'API'
, V.API_PROC
, 'IS_VALID') VALIDATION_PROC
, R.ATTRIBUTE_CATEGORY
, R.ATTRIBUTE1
, R.ATTRIBUTE2
, R.ATTRIBUTE3
, R.ATTRIBUTE4
, R.ATTRIBUTE5
, R.ATTRIBUTE6
, R.ATTRIBUTE7
, R.ATTRIBUTE8
, R.ATTRIBUTE9
, R.ATTRIBUTE10
, R.ATTRIBUTE11
, R.ATTRIBUTE12
, R.ATTRIBUTE13
, R.ATTRIBUTE14
, R.ATTRIBUTE15
, R.ENABLED_FLAG
FROM OE_PC_CONDITIONS R
, OE_PC_CONSTRAINTS C
, OE_PC_VTMPLTS V
, OE_PC_RSETS S
, OE_AK_OBJECTS_EXT E
, OE_AK_OBJECTS_EXT VE
WHERE R.CONSTRAINT_ID = C.CONSTRAINT_ID
AND C.ENTITY_ID = E.ENTITY_ID
AND R.VALIDATION_ENTITY_ID = VE.ENTITY_ID
AND R.VALIDATION_TMPLT_ID = V.VALIDATION_TMPLT_ID
AND R.RECORD_SET_ID = S.RECORD_SET_ID