VIEW: APPS.OE_PC_VTMPLTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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