Data is not retrieving for Non Hundi Listing Query.

Jul 17, 2020 7:01AM

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.

Data is not retrieving for below said Non Hundi Listing Query in Oracle Fusion.

select distinct RAC.PARTY_NAME,

RAC.PARTY_NUMBER,

loc.city,

loc.address1,

APS.TRX_NUMBER,

RCT.CT_REFERENCE,

APS.TRX_DATE,

APS.AMOUNT_DUE_ORIGINAL,

APS.AMOUNT_DUE_REMAINING

from

ar_payment_schedules_all APS,

HZ_PARTIES RAC, HZ_CUST_ACCOUNTS RAC1,

RA_CUSTOMER_TRX_ALL RCT,

hz_cust_site_uses_all csu,