AR Invoice grouping rule from RA_INTERFACE_LINES_ALL
Oracle Receivables AR to Order management OM interface grouping
SELECT AGREEMENT_ID,
COMMENTS,
CONS_BILLING_NUMBER,
CONVERSION_DATE,
CONVERSION_RATE,
CONVERSION_TYPE,
CREDIT_METHOD_FOR_ACCT_RULE,
CREDIT_METHOD_FOR_INSTALLMENTS,
CURRENCY_CODE,
CUSTOMER_BANK_ACCOUNT_ID,
CUST_TRX_TYPE_ID,
DOCUMENT_NUMBER,
DOCUMENT_NUMBER_SEQUENCE_ID,
GL_DATE,
HEADER_ATTRIBUTE1,
HEADER_ATTRIBUTE2,
HEADER_ATTRIBUTE3,
HEADER_ATTRIBUTE4,
HEADER_ATTRIBUTE5,
HEADER_ATTRIBUTE6,
HEADER_ATTRIBUTE7,
HEADER_ATTRIBUTE8,
HEADER_ATTRIBUTE9,
HEADER_ATTRIBUTE10,
HEADER_ATTRIBUTE11,
HEADER_ATTRIBUTE12,
HEADER_ATTRIBUTE13,
HEADER_ATTRIBUTE14,
HEADER_ATTRIBUTE15,
HEADER_ATTRIBUTE_CATEGORY,
HEADER_GDF_ATTRIBUTE1,
HEADER_GDF_ATTRIBUTE2,
HEADER_GDF_ATTRIBUTE3,
HEADER_GDF_ATTRIBUTE4,
HEADER_GDF_ATTRIBUTE5,
HEADER_GDF_ATTRIBUTE6,
HEADER_GDF_ATTRIBUTE7,
HEADER_GDF_ATTRIBUTE8,
HEADER_GDF_ATTRIBUTE9,
HEADER_GDF_ATTRIBUTE10,
HEADER_GDF_ATTRIBUTE11,
HEADER_GDF_ATTRIBUTE12,
HEADER_GDF_ATTRIBUTE13,
HEADER_GDF_ATTRIBUTE14,
HEADER_GDF_ATTRIBUTE15,
HEADER_GDF_ATTRIBUTE16,
HEADER_GDF_ATTRIBUTE17,
HEADER_GDF_ATTRIBUTE18,
HEADER_GDF_ATTRIBUTE19,
HEADER_GDF_ATTRIBUTE20,
HEADER_GDF_ATTRIBUTE21,
HEADER_GDF_ATTRIBUTE22,
HEADER_GDF_ATTRIBUTE23,
HEADER_GDF_ATTRIBUTE24,
HEADER_GDF_ATTRIBUTE25,
HEADER_GDF_ATTRIBUTE26,
HEADER_GDF_ATTRIBUTE27,
HEADER_GDF_ATTRIBUTE28,
HEADER_GDF_ATTRIBUTE29,
HEADER_GDF_ATTRIBUTE30,
INITIAL_CUSTOMER_TRX_ID,
INTERNAL_NOTES,
INVOICING_RULE_ID,
ORIG_SYSTEM_BILL_ADDRESS_ID,
ORIG_SYSTEM_BILL_CONTACT_ID,
ORIG_SYSTEM_BILL_CUSTOMER_ID,
ORIG_SYSTEM_SHIP_CONTACT_ID,
ORIG_SYSTEM_SHIP_CUSTOMER_ID,
ORIG_SYSTEM_SOLD_CUSTOMER_ID,
ORIG_SYSTEM_BATCH_NAME,
PAYMENT_SET_ID,
PREVIOUS_CUSTOMER_TRX_ID,
PRIMARY_SALESREP_ID,
PRINTING_OPTION,
PURCHASE_ORDER,
PURCHASE_ORDER_DATE,
PURCHASE_ORDER_REVISION,
REASON_CODE,
RECEIPT_METHOD_ID,
RELATED_CUSTOMER_TRX_ID,
SET_OF_BOOKS_ID,
TERM_ID,
TERRITORY_ID,
TRX_DATE,
TRX_NUMBER
FROM RA_INTERFACE_LINES_ALL
WHERE INTERFACE_LINE_ATTRIBUTE1 = '&sales_order'
Related posts:
- How to Retrieve Period to Date (PTD) and Year to Date (YTD) Balances of GL Account in Oracle R12
- Sales order line status query in Oracle apps
- 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 get price list details in Oracle EBS
- Query to find all APIs of Oracle Apps modules
- Oracle R12 shipping status query
- 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
- Query to get Sales order and lines details in Oracle Apps
- 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 serial number material transactions details
- 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