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

Data is not retrieving for Non Hundi Listing Query.

Received Response
15
Views
5
Comments
edited Jul 17, 2020 7:14AM in Receivables & Collections 5 comments

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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