Oracle EBS 12 - Link To Order_Number From AR Receipts Tables?

Create AccountLog in

Oracle Database

--

Questions

--

Followers

Top Experts

globalwm2🇺🇸Oracle EBS 12 - Link to Order_Number from AR Receipts tables? I have a query that is joining these tables: AR_CASH_RECEIPTS_ALL a, ar_receipt_methods b, HZ_CUST_ACCOUNTS c, HZ_PARTIES d, AR_PAYMENT_SCHEDULES_ALL e to display AR Receipt information. I'm being asked to add the Order_Number and have read that I can link to RA_CUSTOMER_TRX_ALL to get Order_Number in column INTERFACE_HEADER_ATTRIBIUTE1. However, the link from RA_CUSTOMER_TRX_ALL table to AR_PAYMENT_SCHEDULES_ALL is the column CUSTOMER_TRX_ID which is NULL in AR_PAYMENT_SCHEDULES_ALL table. (Might have to do with Auto Invoice). Anyway, I'm looking for a way to link from AR_CASH_RECEIPTS_ALL or AR_PAYMENT_SCHEDULES_ALL to a table to obtain Order_Number (or HEADER_ID). Thanks

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

ASKER CERTIFIED SOLUTIONSwadhin Ray🇺🇸membershipLog in or create a free account to see answer.Signing up is free and takes 30 seconds. No credit card required.Create Accountglobalwm2🇺🇸

ASKER

CUSTOMER_TRX_ID is NULL in the tables noted above... globalwm2🇺🇸

ASKER

Final FROM/WHERE used as you suggested - thanks:    FROM AR_CASH_RECEIPTS_ALL a,          ar_receipt_methods b,          HZ_CUST_ACCOUNTS c,          HZ_PARTIES d,          AR_PAYMENT_SCHEDULES_ALL e,          AR_RECEIVABLE_APPLICATIONS_ALL f,          AR_PAYMENT_SCHEDULES_ALL g,          RA_CUSTOMER_TRX_ALL h,          OE_ORDER_HEADERS_ALL i    WHERE                      a.receipt_method_id = b.receipt_method_id          AND a.PAY_FROM_CUSTOMER = c.CUST_ACCOUNT_ID(+)          AND c.PARTY_ID = d.PARTY_ID(+)          AND a.cash_receipt_id = e.cash_receipt_id(+)          AND a.cash_receipt_id = f.CASH_RECEIPT_ID(+)          AND f.APPLIED_CUSTOMER_TRX_ID = g.CUSTOMER_TRX_ID          AND g.customer_trx_id = h.customer_trx_id          AND h.INTERFACE_header_ATTRIBUTE1 = TO_CHAR (i.order_number)          AND a.receipt_date BETWEEN TO_DATE (:p_start, 'mm/dd/yyyy') AND TO_DATE (:p_end, 'mm/dd/yyyy')

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Oracle Database

--

Questions

--

Followers

Top Experts

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.