Add PO# in Account Analysis report
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