Demantra Solutions - EBS (MOSC)

MOSC Banner

Collect specific orders within order type in Demand history collections

Our client has a requirement to collect specific orders in some order types in the sales orders in OM. I see that Demantra has 'Collect Shipment and Booking History - ERP - V3' under that parameter 'Type Selection Method' with value 'Enter SQL query name from Table MSD_DEM_ENTITY_QUERIES'. User guide says that the user has to enter the query name stored in Table MSD_DEM_ENTITY_QUERIES in the " Include Order Types" or "Exclude Order Types" parameter fields which will return valid order type ids.

My doubt is, can we add an SQL query which will pull specific orders based on conditions in the order type in this option? Will it be able to filter other orders which we don't want to collect in this shipment and booking history collections? Can someone clarify?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center