[Home] [Help]
View: OKS_ENT_K_STATUS_V
Product: | OKS - Service Contracts |
Description: | Lists all Statuses of the Contract |
Implementation/DBA Data: |
APPS.OKS_ENT_K_STATUS_V
|
View Text
SELECT HDR.AUTHORING_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_B HDR
, FND_LOOKUPS FND
WHERE FND.LOOKUP_CODE = HDR.STS_CODE
AND FND.LOOKUP_TYPE = 'OKC_STATUS_TYPE'
Columns
Name |
ORG_ID |
CONTRACT_ID |
CONTRACT_NUMBER |
CONTRACT_STATUS_CODE |
CONTRACT_STATUS_NAME |