Learn Oracle with Mohit

Monday, May 2, 2022

Visualizing SQL Joins (Learning SQL)

Courtesy: Ravit Jain

at May 02, 2022 No comments:

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: SQL; joins; left join; right join; outer join; inner join;

Newer Posts Older Posts Home

Subscribe to: Comments (Atom)

Oracle Fusion Dunning Letter Delivery Details Report SQL — Fetch Dunning letter name, delivery status etc against a Account, Site, and Contact Information for AR Collections

Description Learn how to build a Dunning Letter Delivery Details Report in Oracle Fusion using SQL. This query retrieves customer account an...

SQL Query to find concurrent program Responsibility and Request Group in Oracle EBS R12

SELECT DISTINCT fcpl . user_concurrent_program_name , fcp . concurrent_program_name , fapp . applica...
SQL Query to get Payment Process Request (PPR) Templates Used to Create a Payment Process Request (PPR) in oracle EBS R12

Query to get all AP Payments related to a PPR:- SELECT c . * FROM ap_checks_all c WHERE c . payment_id IN ( SELECT ip . pay...
Can I assign an Operating Unit to Multiple Legal Entities?

The short answer is sort of. Which is not much help to anyone, hopefully you will have a few moments to read on and I can explain myself. T...

Search This Blog

About Me

Mohit Agarwal: A seasoned Oracle Financial Consultant with more than a decade long experience in Oracle EBS and Fusion financials. Have successfully delivered Oracle EBS implementation, upgradation and rollout projects for many different clients of different domains. Feel free to get in touch for any help or support required.

View my complete profile

Home

Blog Archive

October 2025 (2)
February 2023 (2)
November 2022 (1)
May 2022 (1)
April 2022 (1)
November 2021 (2)

Labels

Report Abuse

Ethereal theme. Powered by Blogger.