Comprehensive SQL to Retrieve Contracts with Lines, Fulfillment, Deliverables, Risks & Attached Doc
Summary:
This post shares a comprehensive SQL query that retrieves detailed Contract information from Oracle Fusion ERP Cloud, especially for ECM_BUY contracts. It consolidates contract headers, lines, fulfillment details, deliverables, risks, and attached documents into a single report. Ideal for procurement and legal teams to track contract status and compliance effectively.
Content (please ensure you mask any confidential information):
This SQL uses standard Oracle Fusion tables and combines key information such as:
- Contract metadata from
OKC_K_HEADERS_VL
- Contract lines from
OKC_K_LINES_VL
- Fulfillment deliverables from
OKC_DTS_DELIVERABLES_B
- Risks from
OKC_CONTRACT_RISKS
- Open deliverables from