Query to Fetch Planning Notes and Linked Item Details — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!