We have requirement for SQL Query to find open transfer orders for create shipment

Srinivas_VNM

Hi Everyone,

We are trying to get All open transfer orders for create and completion shipment against the Sales Order Lines in current quarter.

Getting failed to deriving values using SQL query in BI Publisher.

If anyone previously working on the same, And Kindly give any possible suggestion and solution to get that query.

Please help me to get that requirement.

And giving parameters are (Item Number, Lot Number and Organization). 

Heartly Thanks in Advance

Regards

Srinivas

Sinduja Sekar-Oracle

Hi @User_UV50M ,

Thank you for visiting and posting in Oracle Business Intelligence (OBI) Product Community Page.

This forum is for OBI product and looks like your question is for BI Publisher.

Kindly use the below URL to post BI Publisher questions, submit ideas, receive support from our BIP experts and check out the resources they have available for you.

https://community.oracle.com/products/oracleanalytics/categories/bi-publisher

Regards,

Sinduja