Implemented O2C cycle? In this post I'll mention the Sales Order Table Linkage with various tables to find important information of the Sales Order. Alias I have given to the table is dha i.e. if I have to connect any column of doo_headers_all table, join statement will look like dha.<column_name> Entity NameTable NameJoin Condition(s)Select columnCustomer… Continue reading Sales Order Table Linkage in Oracle Fusion
Category: Oracle Fusion Finance
Oracle Fusion Sales Order Table – DOO_HEADERS_ALL
To provide the table structure & indexes of DOO_HEADERS_ALL table in Oracle Fusion which holds the Sales Order Header Data in Oracle Fusion.
How To Fetch (Query) The Payment Details In Fusion
To illustrate the data base structure of Oracle Fusion Payment system i.e. how the different entities like Payment Process Request, Payment, Checks and Invoices are connected to each other and the basic Payment Query.
Payment Process Request Query in Fusion
How to fetch the payment details in Fusion Finance i.e. Payment Process Profile, Payment Method and other selection criteria of the invoices.
Shipment Details Query In Oracle Fusion
SQL to fetch the shipment details like Shipment, carrier, Bill of Lading, item, inventory, sub inventory , ship to party etc