Oracle EBS : How to Create Inventory Stock Locator

Subject: How to Create New Inventory Stock Locator.

Step1: Navigation: Application Developer > Flexfields > Key > Values

Search with following Details. Click on Find

Step2:Click on “+” button and Create New Entry. Click on Save.

 

Step3: Navigation: Inventory > Setup > Transactions > Organization > Stock Locators.

Click on New Button.

Enter all these 3 new locator entries. Save the Transaction.

Oracle Fusion: Sales Order Shipment Shipping Cost Query

Subject: Need to fetch Sales Order Shipment Shipping Cost Query.

Navigation: Supply Chain Execution > Inventory Management > Shipment > Manage Shipment > Enter Order No and Search

SQL Query: 

SELECT 

SUM(UNIT_AMOUNT) SHIPPING_COST

FROM 

WSH_FREIGHT_COSTS WFC,

WSH_DELIVERY_DETAILS WDD

WHERE WFC.DELIVERY_DETAIL_ID=WDD.DELIVERY_DETAIL_ID 

AND WDD.SOURCE_HEADER_NUMBER='1531' --SO ORDER NUM