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: sales Order
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.
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
Sales Order Query in Oracle Fusion
Retrieving the Sales Order Details in Oracle Fusion