PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Users are not able to view public query

Hi

I have a public query, but other users are not able to see it. Why can others not see it?

Query properties:

Here's my query:


Query SQL

SELECT A.BUSINESS_UNIT, A.VOUCHER_ID, A.VOUCHER_STYLE, A.INVOICE_ID, (CONVERT(CHAR(10),A.INVOICE_DT,121)), A.VENDOR_ID, C.NAME1, A.OPRID, (CONVERT(CHAR(10),A.ACCOUNTING_DT,121)), A.POST_STATUS_AP, A.GROSS_AMT, (CONVERT(CHAR(10),A.DELETE_DT,121))

 FROM PS_VOUCHER A, PS_VCHR_FS B, PS_VNDR_FS C

 WHERE ( C.VENDOR_ID = A.VENDOR_ID

    AND A.INVOICE_ID = B.INVOICE_ID

    AND A.VOUCHER_STYLE <> B.VOUCHER_STYLE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center