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

Unapplied Receipts Query.

edited Jul 11, 2020 8:51AM in Receivables & Collections 8 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.

The below query from Oracle R12 fetches correct number of rows, but in Oracle Fusion the query is fetching only 2 rows. Please help us to get it correct.

select HOU.name ORG_NAME--c.org_id ORG_ID
, c.DOC_SEQUENCE_VALUE DOC_SEQ_VALUE, receipt_number RPT_NUM, hp.party_name PARTY_NAME, c.receipt_date RPT_DATE, c.status STATUS, c.amount*NVL(c.EXCHANGE_RATE,1) RPT_AMT, NVL(appl.amount_applied,0)*NVL(c.EXCHANGE_RATE,1) APPLIED_AMT, DECODE(NVL(appl.amount_applied,0),0,'FULLY','PARTIALLY') CATG, m.NAME RPT_METHOD, hps.party_site_number PARTY_SITE_NUM, hl.address1 ADDRESS, hl.city CITY, hl.state STATE

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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