indexes, R12, Table Structure

OE_ORDER_HEADERS_ALL: Column, Index & Few Tricks

OE_ORDER_HEADERS_ALL: The table used by Oracle Fusion to store the Sales Order Header level data. You would need to query OE_ORDER_HEADERS_ALL table if you have implemented O2C Cycle. So you can say that this is the equivalent of table DOO_HEADERS_ALL table in Oracle Fusion. In this post, we will discuss the columns and indexes present… Continue reading OE_ORDER_HEADERS_ALL: Column, Index & Few Tricks

Oracle Fusion Finance, sales Order, shipment

Item Shipment History Query in Fusion

Query to fetch the shipment history like item number, shipment date, Inventory, ship to site, ship to party, quantity , sales order number etc