Subledger query - Receivables (journal source) Receipts (Category)
Summary:I am trying to construct a query against the XLA sub-ledger tables for Receivables (source) / Receipts (category) which includes the customer site detail.
Content (required):
I am trying to construct a query against the XLA sub-ledger tables for Receivables (source) / Receipts (category) which includes the customer site detail.
I tried utilising the PARTY_SITE_ID from the table XLA_AE_LINES, but this proved to not join to sites at all. (Note party_id works fine to get me a party, but the number stored in party_site_id seems to join to ar_distributions_all third_party_sub_id - which does not help me in this respect.
Tagged:
0