Kintana Script : List Status Dependencies for a Request Type

Purpose

This script provides the same information you see on the status dependencies tab and also lists the token for the field.

Tested

With HP PPM (Project and Portfolio Management) Kintana v7.5.

Usage

Paste the script into SQL Runner

Change the 'and crt.request_type_name= 'My Request Type Name' to your request type name or comment it out.

Omit the comment, spool, and linesize statements unless you're using a PL-SQL editor.
SQL Runner only supports select statements and you'll get a KNTA-10648 error.
If using PL-SQL change 'yyyymmdd' in the output file name to today's date.

-- List Status Dependencies for a Request Type
spool c:\request_field_info_yyyymmdd.txt
set linesize 1000

select  crt.request_type_name,
        cs.status_name,
        ns.section_name,
        npsf.prompt,
        cfd.visible_field_flag "Visible",
        cfd.disabled_field_flag "Editable",
        cfd.required_field_flag "Required",
        cfd.reconfirm_field_flag "Reconfirm",
        cfd.clear_field_flag "Clear",
        npsf.parameter_token
from  KCRT_REQUEST_TYPES crt,
      KCRT_REQUEST_TYPE_STATUSES crts,
      KCRT_STATUSES cs,
      KCRT_FIELD_DEPENDENCIES cfd,
      KNTA_PARAMETER_SET_FIELDS npsf,
      KNTA_SECTION_LAYOUTS nsl,
      KNTA_SECTIONS ns
where

  -- limit to a single request type. Comment out to list all request types

      crt.request_type_name = 'My Request Type Name'

  and crt.request_type_id = crts.request_type_id
  and crts.status_id = cs.status_id
  and crts.request_type_status_id = cfd.request_type_status_id
  and cfd.parameter_set_field_id = npsf.parameter_set_field_id
  and npsf.section_id = nsl.section_id
  and nsl.entity_primary_key = crt.request_type_id
  and nsl.section_id = ns.section_id
  order by crt.request_type_name, cs.status_name, nsl.seq, ns.section_name, npsf.prompt

spool off

REQUEST_TYPE_NAME  STATUS_NAME SECTION_NAME  PROMPT           Visible Editable Required Reconfirm Clear PARAMETER_TOKEN

Inventory          Restock     Main Section  Customer No:     Y       Y        N        N         N     MS_CUSTOMER_NO
Inventory          Restock     Main Section  Date Received:   Y       Y        N        N         N     MS_DATE_RECIEVED
Inventory          Restock     Bin Info      SKU:             Y       Y        N        N         N     BI_SKU
Inventory          Restock     Bin Info      Bay-Rack-Shelf:  Y       Y        N        N         N     BI_BAT_RACK_SHELF
Inventory          Restock     Inspection    Inspected By:    Y       Y        N        N         N     IN_INSPECTED_BY
Inventory          Restock     Inspection    Passed As:       Y       Y        N        N         N     IN_PASSED_AS
...

To extract the output, click on the [Open as Text] button.

This opens a text window from which you can copy and paste.

Download

KintanaScripts.zip (79 Kb)