Oracle R12 Hundi query in Oracle Fusion.

Summary

Hundi query.

Content

Hi,

We recently migrated our Oracle R12 to Oracle Fusion. We have developed some custom reports in our Old Oracle R12, we need to develop

it in Oracle Fusion. We face difficulty in finding tables and fields. Below is the Hundi query, which is not fetching rows.

select        rcta.customer_trx_id
                ,rcta.trx_number  BILL_NO
                ,fabu.bu_name
                ,substr(fabu.bu_name,1,1)||'-'||rcta.trx_number CONCAT_BILLNO
                ,rcta.trx_date DATE1
                ,rcta.term_due_date DUE_DATE
                ,nvl(rcta.br_amount,0) Amount
                ,rcta.term_due_date-rcta.trx_date DAYS
                ,rctt.type
                ,cust_acct.ACCOUNT_NUMBER