Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

SQL query to get SO Details

Received Response

38

Views

2

Comments

Dinesh K89 Rank 1 - Community Starter

Apr 2, 2025 9:48AM in Oracle Transactional Business Intelligence

Can someone please provide SQL query to get SO, Customer, ship_to, bill_to, delivery_id, invoice_number, payment_terms and other details

Tagged:

• Reporting
• SQL
• Oracle Fusion Analytics
• BI Publisher Data Models
• Fusion Data Intelligence

0

Answers

• 

  Riyaz Ali-Oracle Rank 6 - Analytics & AI Lead

  Apr 30, 2025 9:40PM

  Check below as it might be helpful:

  FA: SCM: OM: SQL Query: Querying Customer, SHIP_TO and BILL_TO Information on an Order (Doc ID 2235032.1)

  SQL to find Sales Order Customer, Ship To, Bill To and Invoice for a Sales Order — Cloud Customer Connect

  0
• 

  MandeepGupta Rank 8 - Analytics & AI Strategist

  May 1, 2025 5:16AM

  https://community.oracle.com/products/oracleanalytics/discussion/25167/sql-query-to-get-so-details

  Hi Dinesh,

  Welcome to Oracle Analytics community.

  Please check the query shared on below link:

  Need table for Supply Order Status to match with screen — Cloud Customer Connect

  Thanks.

  0