EBS-Demantra Integratiion: How to Modify collection for Booking & Shipment History series?
We have a requirement to change not just the sales quantity but also, warehouse, sales channel, demand class before we load into staging tables.
The note says option 2, create a Custom view similar to the source view. So in our case I want to create a custom view similar to MSD_SH_SI_RD_V which pulls data for Shipment History - Shipped Item - Requested Date. How is the source view generated so that I can use the same logic. Which DB object like procedure, pkg utilizes so that I can create a custom object to generate my custom view based on source view.Any pointer like look into MSD_DEM% object in source side or APS side will be helpful.
The note says option 2, create a Custom view similar to the source view. So in our case I want to create a custom view similar to MSD_SH_SI_RD_V which pulls data for Shipment History - Shipped Item - Requested Date. How is the source view generated so that I can use the same logic. Which DB object like procedure, pkg utilizes so that I can create a custom object to generate my custom view based on source view.Any pointer like look into MSD_DEM% object in source side or APS side will be helpful.
0