joining on a sub record

[psoftJohn]

I am using PS 8.45.11 and Financials/SCM 8.80. I am trying to insert a table in PS query that I am using in a Crystal Report. The table is MEMBER_PHONE which come to find out is a Sub Record. When I insert it into my query it shows up as PHONE_SBR and only shows the fields in the sub record and not the key field that I need to join on.

I have tried writing an expression with the field that I need but it dosn't pass edit because the field is not listed in the query. I can successfully run it in my SQL editor. Here is the SQL that I wish to run.

SELECT PHONE FROM PS_MEMBER_PERSON I, PS_MEMBER_PHONE J
WHERE I.SUPPORT_TEAM_MBR = J.SUPPORT_TEAM_MBR(+)

Any suggestions?

 

[psoftJohn]

Can we say, 'Clear your cache.'?

I would have never suspected this because I had not made any changes to any pages, tables, etc, but, I went to a coworkers machine and his MEMBER_PHONE file looked fine with all fields as expected. I cleared my cache and now I can see all the fields both in App designer and in Query.

There's a lesson in there somewhere.