Instead of continuing to do things the way I’ve always done them, I was trying to put a solution together using projections/rest api and I’m stumped on where to find the equivalent of an Apps10 view. Is there a way to find where/if a view is surfaced in the projections?
In this particular case I was looking to do something close to the delivery note, except that I need the quantities of each lot and the expiration date. For the body of the report I with SQL I would have done something like
SELECT part_no,
ifsapp.part_catalog_api.get_description(part_no),
lot_batch_no,
expiration_date,
qty_shipped
FROM ifsapp.shipment_source_reservation
WHERE shipment_id = '29816'
order by part_no, lot_batch_no