Hi @Binu S

Can you refer Data-lineage -

https://docs.oracle.com/en/cloud/saas/analytics/24r2/fascm/chapter-data-lineage.html

Regards,

Arjun

In Oracle Cloud, sales agreements information is typically found in the DOO (Distributed Order Orchestration) and Order Management modules. Some relevant tables for sales agreements include:

• DOO_HEADERS_ALL: Contains high-level information on sales orders and agreements, including header_id, agreement_name, and dates.
• DOO_LINES_ALL: Holds details about the lines on sales agreements.
• HZ_PARTIES: For customer and sales rep information.
• QP_LIST_HEADERS_B: For price list information associated with the sales agreement.
• DOO_AGREEMENTS: Specific to agreements, with start_date, end_date, signed_date.

For fields like the agreement name, effective start/end dates, signed date, sales rep, and price list, you can join these tables based on header_id or party_id where applicable.

An example query:

sqlCopy codeSELECT d.header_id, d.agreement_name, d.effective_start_date, d.effective_end_date, d.signed_date,       hz.party_name AS sales_rep, ql.price_list_nameFROM DOO_HEADERS_ALL dJOIN HZ_PARTIES hz ON d.sales_rep_id = hz.party_idJOIN QP_LIST_HEADERS_B ql ON d.price_list_id = ql.list_header_id;

This retrieves key details like agreement names, dates, and associated sales reps and price lists.