tag:blogger.com,1999:blog-3748123311723907043.post4927447930398255788..comments2024-03-28T10:15:27.244+05:30Comments on Oracle Applications: Query To Get Receipt Accounting EntriesUnknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-3748123311723907043.post-36986556117541985142020-11-03T13:43:01.501+05:302020-11-03T13:43:01.501+05:30SELECT
amount_dr,
amount_cr,
acctd_amount_dr...SELECT<br /> amount_dr,<br /> amount_cr,<br /> acctd_amount_dr,<br /> acctd_amount_cr,<br /> gcc.segment1<br /> || '.'<br /> || gcc.segment2<br /> || '.'<br /> || gcc.segment3<br /> || '.'<br /> || gcc.segment4<br /> || '.'<br /> || gcc.segment5 ACCOUNT<br />FROM<br /> ar.ar_distributions_all ad,<br /> gl.gl_code_combinations gcc<br />WHERE source_table = 'RA'<br /> AND ad.code_combination_id = gcc.code_combination_id<br />AND EXISTS (<br /> SELECT 'T'<br /> FROM<br /> ar.ar_receivable_applications_all a,<br /> ar.ar_cash_receipts_all b<br /> WHERE a.cash_receipt_id = b.cash_receipt_id<br /> AND a.receivable_application_id = source_id<br /> AND b.org_id = '&org_id'<br /> AND b.org_id = a.org_id<br /> AND b.receipt_number LIKE '%&receipt_number%'<br /> )<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3748123311723907043.post-37968995822188298852020-03-12T12:11:23.536+05:302020-03-12T12:11:23.536+05:30For the script Please send a mail to OracleApps88@...For the script Please send a mail to OracleApps88@Yahoo.comRaju Chinthapatlahttps://www.blogger.com/profile/07470059728519346926noreply@blogger.com