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

need a query to get the unit price of subscription invoice

Summary: need a query to get the unit price of subscription invoice


Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):

currently we are using but we are getting wrong value for one invoice

select (SELECT to_char(obla.adjustment_amount, 'fm9,999,999,900.00999')
FROM ra_customer_trx_all rac,
oss_bill_lines obl,
ra_customer_trx_lines_all racl
oss_bill_adjustments oba
WHERE 1 = 1
AND rac.customer_trx_id = c.customer_trx_id
--AND rac.trx_number = '26502450091'
AND racl.customer_trx_id = rac.customer_trx_id

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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