You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Oracle revenue contracts query to fetch revenue contracts details

edited Mar 15, 2024 10:26PM in Revenue Management 2 comments

Hi All

I want to know the primary tables to fetch the revenue contract details:

I have got the relevant details from VRM_SOURCE_DOCUMENTS and VRM_SOURCE_DOC_LINES but I am Unable to fetch contract number.

I have found the contract number information in VRM_CUSTOMER_CONTRACT_HEADERS but I am unable to join it with VRM_SOURCE_DOCUMENTS and VRM_SOURCE_DOC_LINES. Can you please assist me in identifying the right tables and their primary key to get contract number along with the information in VRM_SOURCE_DOCUMENTS and VRM_SOURCE_DOC_LINES in one query.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!