View: MTL_SERVICE_CONTRACTS_V

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.MTL_SERVICE_CONTRACTS_V

View Text

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

Columns