Supply Chain Management - PSFT (MOSC)

MOSC Banner

Need to get table name for contract entry subpage

edited Jul 23, 2018 11:43AM in Supply Chain Management - PSFT (MOSC) 3 commentsAnswered ✓

I am creating a sql Query. I have to join contract entry page and the PO from contract page. Trying to get the sql which can find the total released amount on the contract entry page is same as the total amount of all PO for each contract. Contract entry subpage CNTRCT_HDR_SBP is using work fields and that we cannot pull in SQL developer. Is there any other table which will have the release amount fields in different table so that I can join the query.

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