Product: | ONT - Order Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OE_PC_VTMPLTS_VL |
SELECT V.ROWID ROW_ID
, V.VALIDATION_TMPLT_ID
, V.ENTITY_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
, 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
, V.WF_ITEM_TYPE
FROM OE_PC_VTMPLTS V
, OE_PC_VTMPLTS_TL TL
WHERE V.VALIDATION_TMPLT_ID = TL.VALIDATION_TMPLT_ID
AND TL.LANGUAGE = USERENV('LANG')