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

Join XCC_BALANCES with PO tables

Received Response
4
Views
1
Comments
edited Aug 30, 2021 11:25AM in Budgetary Control 1 comment

Content

Hi all,

I need to retrieve the budget available amount (see screenshot below)

I found the amounts in the table XCC_BALANCES. But I can't find a way to join it with PO tables. I tried to link PO_DISTRIBUTIONS_ALL with XCC_BALANCES.BUDGET_CCID but this is not the way.

Does someone know how to perform the join ?

Thanks in advance,

Paul

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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