Hi Experts, having a requirement to send debrief estimates to Service request contacts.

Summary:

I am unable to get joins between debriefs(depot repair ) , Service request and RMA orders .I tried joining RCL_DEBRIEF_HEADERS. parent_entity_id with RCL_PARTS_REQ_LINE_DETAILS.source_id and DOO_LINES_ALL.LINE_ID with RCL_PARTS_REQ_LINE_DETAILS.source_id but these joins are not sufficient and not consistent.

Let me know if am missing anything .

Please share your inputs.

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Thanks,

Bhavani