Oracle apps AR Applications and SLA details
Oracle EBS receivable applications and xla details query
AR_RECEIVABLE_APPLICATIONS_ALL and xla_ae_lines join R12
--AR Applications and xla
SELECT ard.source_id,
xdl.SOURCE_DISTRIBUTION_TYPE,
xal.ACCOUNTING_CLASS_CODE,
ard.SOURCE_ID,
ard.SOURCE_TABLE,
ard.SOURCE_TYPE,
rcta.trx_number,
(SELECT name
FROM apps.ra_cust_trx_types_all
WHERE cust_trx_type_id = rcta.cust_trx_type_id)
transaction_type,
xah.*
FROM apps.xla_ae_lines xal,
apps.xla_distribution_links xdl,
apps.xla_ae_headers xah,
apps.AR_DISTRIBUTIONS_ALL ard,
apps.AR_RECEIVABLE_APPLICATIONS_ALL ara,
apps.ra_customer_trx_all rcta
WHERE 1 = 1
AND xal.ae_header_id = xdl.ae_header_id
AND xal.ae_line_num = xdl.ae_line_num
AND xdl.SOURCE_DISTRIBUTION_TYPE = 'AR_DISTRIBUTIONS_ALL'
AND xah.ae_header_id = xal.ae_header_id
AND ARD.LINE_ID = XDL.source_distribution_id_num_1
AND ard.SOURCE_ID = ara.RECEIVABLE_APPLICATION_ID
AND ara.APPLIED_CUSTOMER_TRX_ID = rcta.customer_trx_id(+)
AND rcta.trx_number = '123456'
--AND GL_TRANSFER_STATUS_CODE = 'N'
;
Related posts:
- PTD and YTD balances query in Oracle R12
- Query to find all Expense report entry delegations
- Query to find vacation rules in Oracle R12
- View accounting query in oracle apps R12
- Query to get AR invoice SLA and GL details
- Accounting entries not transferred to the General Ledger
- Query to find all APIs of Oracle Apps modules
- R12 AR cash receipt SLA and GL details query
- Oracle apps AR Applications and SLA details
- Oracle EBS query to get AP Invoice SLA Details
- Oracle EBS query to get AR Invoice SLA Details
- Oracle AR Remit to address query
- Oracle Apps iExpense credit card details query
- Query to get customer tax registration details in R12
- Purchase Requisition Vertex debug xml query in Oracle EBS
- Purchase Order Vertex debug xml query in Oracle EBS
- AP Invoice Vertex debug xml query in Oracle EBS
- AR Invoice Vertex debug xml query in Oracle EBS
- Query to find AP invoice workflow item key in oracle apps
- Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assets
- Oracle apps EBS sql to get Fixed Asset (FA) details with Net Book Value (NBV) and Depreciation
- Query to find Sales Orders that are shipped but not invoiced
- Query to get Customer Bank Account Details
- Query to get description of GL Code Combination
- Query to find Purchase Order and Invoice Details
- Query to find AP Invoices matched with receipts
- Query to find Supplier Bank Details
- Query to find Credit Memos on an AP invoice
- Query to find the AP invoices that are applied to multiple Purchase Orders
- AR Invoice grouping rule from RA_INTERFACE_LINES_ALL
- Query to find shipset and fulfilment set