Flexfield Value Set - Table Validation
Problem: Trying to use Two Tables
Wsh_Delivery_Details dtl and Wsh_Delivery_Assignments hdr
Table Name = WSH_DELIVERY_DETAILS dtl Left Join wsh_delivery_assignments hdr on hdr.delivery_detail_id = dtl.delivery_detail_id
Value = hdr.wsh_delivery_Assignments
ID = dtl.delivery_detail_id
Where/Order by = where dtl.inventory_item_id = :INCIDENT_TRACKING.INVENTORY_ITEM_ID
and dtl.source_header_number = :INCIDENT_TRACKING.INCIDENT_ATTRIBUTE_1 --(This is the Original Sales Order Number Part went out on)