The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Request Types and Request header Types

Highlighted
Jajcen Harris
Occasional Contributor

Request Types and Request header Types

Hello All,

I am trying to run a query to show the fields on the request form and header, the validations in those fields, and what request headers are attached to which request types. Has anyone done this before? I cannot seem to get it. Thanks!
3 REPLIES
VijayVignesh
Occasional Contributor

Re: Request Types and Request header Types

Here u go :-)

SELECT
--KPS.*,
KPS.PROMPT,
KPS.PARAMETER_TOKEN,
KVA.VALIDATION_NAME,
'PARAMETER'
|| KPS.PARAMETER_COLUMN_NUMBER PARAMETER,
'VISIBLE_PARAMETER'
|| KPS.PARAMETER_COLUMN_NUMBER VISIBLE_PARAMETER,
kps.enabled_flag,
KPS.DISPLAY_FLAG,
KPS.DISPLAY_ONLY_FLAG,
KPS.UPDATEABLE_FLAG,
KPS.REQUIRED_FLAG,
KPS.TRANS_HISTORY_FLAG,
KPS.NOTES_HISTORY_FLAG,
KPS.ENABLED_FLAG,
KPS.WORKBENCH_ONLY_FLAG,
KPS.MULTI_FLAG,
KPS.BATCH_NUMBER
FROM kcrt_request_types krht,
KNTA_VALIDATIONS KVA,
knta_parameter_set_contexts kpc,
Knta_Parameter_Set_Fields kps
WHERE 1 = 1
AND kva.validation_id = kps.validation_id
AND kpc.context_value = TO_CHAR(krht.request_type_id)
AND krht.request_type_name LIKE '<>'
AND kps.parameter_set_context_id = kpc.parameter_set_context_id
AND kps.enabled_flag = 'Y'
ORDER BY kps.prompt
Jajcen Harris
Occasional Contributor

Re: Request Types and Request header Types

Thank you for the quick response!!

I ran it and I am seeing the request type fiels, but it is not bringing back the fields on the header that is connected to the request type. Any ideas why?
Jajcen Harris
Occasional Contributor

Re: Request Types and Request header Types

Oh ok I got it. Thanks alot!
//Add this to "OnDomLoad" event