Oracle cloud table for Sales Agreements

Binu S

What is the the Oracle cloud table for Sales Agreements, We need the Agreements name,Effective Start and End date ,signed date, sales rep and price list etc In R12 we have oe_agreements_b and oe_agreements_tl etc..

Mallikarjuna Kuppauru-Oracle

Hi @Binu S

Can you refer Data-lineage -

Reference for Fusion SCM Analytics

Regards,

Arjun

Ashish-Oracle

@Binu S The FDI sales agreement table is DW_AGREEMENT_CF. Can you please check the same and confirm if this is the table you are looking for?

Jayant Ajayrao Deshmukh

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.