Agile (MOSC)

MOSC Banner

How to Query Supplier Discussion's History Table

in Agile (MOSC) 2 commentsAnswered

Could anyone know how to query History Table on Discussions?

thanks.



==This is Supplier Discussions function Query==

select t.auto_number,

    decode(t.status, 1, 'Close', 'Open') status,

    t.subject,

    t.message,

    (select l.entryvalue from listentry l where t.priority = entryid(+)) priority,

    (select i.item_number from item i where dp.list32 =i.id) item_number,

    t.*

 from discussion t, discussion_p2p3 dp

 where t.subclass = 2476857 --SDS

  and t.id = dp.id

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