View: OE_PC_VTMPLTS_V

Product:	ONT - Order Management
Description:	This view stores the processing constraint validation templates.
Implementation/DBA Data:	APPS.OE_PC_VTMPLTS_V

View Text

SELECT V.ROWID ROW_ID
, V.VALIDATION_TMPLT_ID
, V.ENTITY_ID
, E.ENTITY_SHORT_NAME
, E.ENTITY_DISPLAY_NAME
, E.DB_OBJECT_NAME
, E.DB_OBJECT_TYPE
, E.APPLICATION_ID
, V.VALIDATION_TMPLT_SHORT_NAME
, TL.DISPLAY_NAME VALIDATION_TMPLT_DISPLAY_NAME
, TL.DESCRIPTION VALIDATION_TMPLT_DESCRIPTION
, V.VALIDATION_TYPE
, V.SYSTEM_FLAG
, V.CREATED_BY
, V.CREATION_DATE
, V.LAST_UPDATED_BY
, V.LAST_UPDATE_DATE
, NVL(V.WF_ITEM_TYPE
, E.WF_ITEM_TYPE)
, V.ACTIVITY_NAME
, V.ACTIVITY_STATUS_CODE
, V.ACTIVITY_RESULT_CODE
, V.API_PKG
, V.API_PROC
, V.LAST_UPDATE_LOGIN
, V.ATTRIBUTE_CATEGORY
, V.ATTRIBUTE1
, V.ATTRIBUTE2
, V.ATTRIBUTE3
, V.ATTRIBUTE4
, V.ATTRIBUTE5
, V.ATTRIBUTE6
, V.ATTRIBUTE7
, V.ATTRIBUTE8
, V.ATTRIBUTE9
, V.ATTRIBUTE10
, V.ATTRIBUTE11
, V.ATTRIBUTE12
, V.ATTRIBUTE13
, V.ATTRIBUTE14
, V.ATTRIBUTE15
FROM OE_PC_VTMPLTS V
, OE_PC_VTMPLTS_TL TL
, OE_PC_ENTITIES_V E
WHERE V.VALIDATION_TMPLT_ID = TL.VALIDATION_TMPLT_ID
AND TL.LANGUAGE = USERENV('LANG')
AND V.ENTITY_ID = E.ENTITY_ID

Columns