Find sql behind a view

[Allen Cunningham <allen.cunningham@SONOMA.EDU>]

I am trying to find the criteria used to fill a prompt table with vendors on
the RUN_1099_COPYB_RPT panel. A certain vendor should be in the prompt table
and is not, and I need to find out why he is not in the prompt table. If I
have the name of the view (PS_VNDR_COPYB_VW) what is a good debug technique
to find what the criteria is to load the table. I did a sql trace on the
panel and I see a SQL select being done that selects all vendors from the
view so the user can pick one, but need to know whay my vendor did not get
into the table.

Using SQR 4.3.4
PS 7.5 Financials

*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Allen Cunningham
Sonoma State University
Administrative Information Systems
allen.cunningham@sonoma.edu
ph 707.664.2052
fx 707.664.2505
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*