SELECT HDR.ORG_ID ORG_ID ,HDR.ID CONTRACT_ID ,HDR.CONTRACT_NUMBER CONTRACT_NUMBER ,HDR.STS_CODE CONTRACT_STATUS_CODE ,FND.MEANING CONTRACT_STATUS_NAME FROM OKC_K_HEADERS_ALL_B HDR ,FND_LOOKUPS FND WHERE FND.LOOKUP_CODE = HDR.STS_CODE AND FND.LOOKUP_TYPE = 'OKC_STATUS_TYPE'
SELECT HDR.ORG_ID ORG_ID
, HDR.ID CONTRACT_ID
, HDR.CONTRACT_NUMBER CONTRACT_NUMBER
, HDR.STS_CODE CONTRACT_STATUS_CODE
, FND.MEANING CONTRACT_STATUS_NAME
FROM OKC_K_HEADERS_ALL_B HDR
, FND_LOOKUPS FND
WHERE FND.LOOKUP_CODE = HDR.STS_CODE
AND FND.LOOKUP_TYPE = 'OKC_STATUS_TYPE'
|
|
|