ASCP exception_details; how can I see the connection between msc_exception_details and plan outcome
I looking some primary keys to connect tables together, because we building BI -reports and we want bring more information from other tables in same time.
in MSC_exceptions or MSC_exception_details or MSC_exception_detail_v tables has multiple keys like organization_id, inventory_item_id, plan_id, but then there are lot of other like transaction_id,demand_id,etc where there are not always values. Therefore I looking how to connect to tables like MSC_orders_v or MSC_supplies or MSC_tables together with exception tables?
do anyone of you have ideas to do the joins on SQL for those tables? or do I missing table where is located connecting information?