SELECT contracts.id , contracts.contract_number , contracts.object_version_number , contracts.authoring_org_id FROM okc_k_headers_all_b contracts , okc_statuses_b statuses WHERE statuses.code = contracts.sts_code AND statuses.STE_CODE = 'ACTIVE' AND contracts.scs_code = 'SERVICE' AND sysdate between contracts.start_date and contracts.end_date
SELECT CONTRACTS.ID
, CONTRACTS.CONTRACT_NUMBER
, CONTRACTS.OBJECT_VERSION_NUMBER
, CONTRACTS.AUTHORING_ORG_ID
FROM OKC_K_HEADERS_ALL_B CONTRACTS
, OKC_STATUSES_B STATUSES
WHERE STATUSES.CODE = CONTRACTS.STS_CODE
AND STATUSES.STE_CODE = 'ACTIVE'
AND CONTRACTS.SCS_CODE = 'SERVICE'
AND SYSDATE BETWEEN CONTRACTS.START_DATE
AND CONTRACTS.END_DATE
|
|
|