View: OE_PC_CONDITIONS_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_PC_CONDITIONS_V

View Text

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

Columns