Identify TAX Allocation Lines
We have upgraded Oracle AP to R12 from 11i.I want to identify all ORG_ID which used Tax Allocation feature in 11i ?
(WE use PO matched line, so TRV should hold good)
For new created transactions in R12, I can use below query I believe:
select COUNT(DISTINCT INVOICE_ID), ORG_ID from apps.AP_INVOICE_DISTRIBUTIONS_all
where
LINE_TYPE_LOOKUP_CODE='TRV'
GROUP BY ORG_ID
However, I dont think this query fetches 11i ORGs which had Tax Allocations used.
Can you help me with that query please.
Regards,
Siddhi
Tagged:
0