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
Tagged:
0