Kintana Script : SQL Based Validations

Purpose

List the source code for SQL based validations and locate validations where the sql contains a specified string.

Tested

With HP PPM (Project and Portfolio Management) Kintana v6.0.

Usage

Paste the script into Toad or SQL Runner

select nv.validation_name, nv.enabled_flag, nv.validation_sql
from KNTA_VALIDATIONS nv
where nv.validation_type_code = 'SQL'
  and nv.validation_sql like '%mystring%'
  and nv.enabled_flag = 'Y'

Download

KintanaScripts.zip (64 Kb)