BI Publisher (MOSC)

MOSC Banner

Query to get the tax name and rate from a draft invoice under contract

Oracle Fusion Cloud Applications24A (11.13.24.01.0)

I need to retrieve the tax name and tax rate applied on the draft invoice (without calculating it manually) under contract management. In the tables pjb_inv_line_dists and pjb_invoice_lines, I only have the amount after the tax is applied OUTPUT_TAX_AMT and the OUTPUT_TAX_CLASS_CODE.

Please advise.

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