Payables and Cash Management - EBS (MOSC)

MOSC Banner

Add PO# in Account Analysis report

edited Mar 20, 2017 9:35AM in Payables and Cash Management - EBS (MOSC) 6 commentsAnswered

Hi All,

I am trying to print/add PO# in custom Account Analysis report.

SELECT DISTINCT source_distribution_type

                rt.po_header_id,

                aeh.ae_header_id

FROM   XLA_AE_HEADERS aeh,

       XLA_AE_LINES ael,

       RCV_TRANSACTIONS rt,

       XLA_DISTRIBUTION_LINKS xdl,

       RCV_RECEIVING_SUB_LEDGER rrsl

WHERE  aeh.ae_header_id = xdl.ae_header_id AND

       aeh.ae_header_id = ael.ae_header_id AND

       ael.ae_header_id = xdl.ae_header_id AND

       ael.ae_line_num = xdl.ae_line_num AND

       xdl.source_distribution_id_num_1 = rrsl.rcv_sub_ledger_id(+) AND

       rrsl.rcv_transaction_id = rt.transaction_id(+) AND

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center