Query to Fetch Planning Notes and Linked Item Details
Summary:
How can I retrieve Planning Notes (ZMM_NOTES) that were originally created by an extended sales team? I used the two queries below to get the note text and joined the msc_association_context table. However, I am unsure how to retrieve the associated item information.
Retrieve Planning Notes:.
SELECT note_id, creator_party_id,
note_type_code, note_txt, source_object_code, source_object_uid,
visibility_code, created_by, creation_date
FROM zmm_notes
WHERE source_object_code = 'PLANNING_NOTE'
ORDER BY creation_date;
Get Association Context:
SELECT *
FROM msc_association_context
WHERE association_id IN ('ABC') -- Pass source_object_uid from the above query here