Comprehensive SQL to Retrieve Contracts with Lines, Fulfillment, Deliverables, Risks & Attached Doc — 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

Comprehensive SQL to Retrieve Contracts with Lines, Fulfillment, Deliverables, Risks & Attached Doc

edited Aug 2, 2025 12:05PM in Enterprise Contracts 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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