PS Query & SQL

I am trying to identify the record where Distribution Detail is stored. This is what you get when you are about to start a process, and on the Process Scheduler Request page press the Distribution link. I'm interested in the Email Subject, Message Text, Email Address List and Distribution ID. It looks like it should be a combination of PRCSRQSTDLG and PRCSDEFNDIST_VW, however when I asked for access to PRCSRQSTDLG I was told that it doesn't exist, while 

PRCSRQSTDLGLNG does exist, it doesn't contain any data.

Also, PRCSDEFNDIST_VW doesn't contain any data.

Does anyone know how to get to this data?

Hi Kevin,

I think it might be PSPRCSRQSTTEXT you want.  

There could be multiple rows for a process instance, including the email address, subject and text.

Hope this helps!

Paz

I am trying to identify the record where Distribution Detail is stored. This is what you get when you are about to start a process, and on the Process Scheduler Request page press the Distribution link. I'm interested in the Email Subject, Message Text, Email Address List and Distribution ID. It looks like it should be a combination of PRCSRQSTDLG and PRCSDEFNDIST_VW, however when I asked for access to PRCSRQSTDLG I was told that it doesn't exist, while 

PRCSRQSTDLGLNG does exist, it doesn't contain any data.

Also, PRCSDEFNDIST_VW doesn't contain any data.

Does anyone know how to get to this data?

I am trying to identify the record where Distribution Detail is stored. This is what you get when you are about to start a process, and on the Process Scheduler Request page press the Distribution link. I'm interested in the Email Subject, Message Text, Email Address List and Distribution ID. It looks like it should be a combination of PRCSRQSTDLG and PRCSDEFNDIST_VW, however when I asked for access to PRCSRQSTDLG I was told that it doesn't exist, while 

PRCSRQSTDLGLNG does exist, it doesn't contain any data.

Also, PRCSDEFNDIST_VW doesn't contain any data.

Does anyone know how to get to this data?

Hi Kevin,

A few more tables that you can look at related to run control ids;  that may have the information as it was saved based on the oprid, runcntlid, prcstype and prcsname   ;   some reverse engineering related to those numeric fields may be able to get you were you want to see information about the distributions and/or email addresses.

PRCSRUNCNTLDTL

PRCSRUNCNTLOUT

PRCSRUNCNTLDIST

PRCSRUNCNTLEOPT

Pam

I am trying to identify the record where Distribution Detail is stored. This is what you get when you are about to start a process, and on the Process Scheduler Request page press the Distribution link. I'm interested in the Email Subject, Message Text, Email Address List and Distribution ID. It looks like it should be a combination of PRCSRQSTDLG and PRCSDEFNDIST_VW, however when I asked for access to PRCSRQSTDLG I was told that it doesn't exist, while 

PRCSRQSTDLGLNG does exist, it doesn't contain any data.

Also, PRCSDEFNDIST_VW doesn't contain any data.

Does anyone know how to get to this data?