[Home] [Help]
View: OKS_ENT_HDR_SUMMARY_V
Product: | OKS - Service Contracts |
Description: | This holds all the service contracts summary and party information. |
Implementation/DBA Data: |
APPS.OKS_ENT_HDR_SUMMARY_V
|
View Text
SELECT HDR.ID CONTRACT_ID
, HDR.CONTRACT_NUMBER CONTRACT_NUMBER
, HDR.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, HDR.ESTIMATED_AMOUNT CONTRACT_AMOUNT
, HDR.CURRENCY_CODE CURRENCY_CODE
, HDR.STS_CODE CONTRACT_STATUS_CODE
, HDR.START_DATE START_DATE_ACTIVE
, HDR.END_DATE END_DATE_ACTIVE
, PTY.OBJECT1_ID1 PARTY_ID
FROM OKC_K_HEADERS_V HDR
, OKC_K_PARTY_ROLES_B PTY
, OKC_SUBCLASSES_V CLS
WHERE HDR.TEMPLATE_YN ='N'
AND CLS.CLS_CODE = 'SERVICE'
AND HDR.SCS_CODE = CLS.CODE
AND HDR.ID = PTY.CHR_ID
AND PTY.RLE_CODE IN ('CUSTOMER'
, 'SUBSCRIBER')
Columns
Name |
CONTRACT_ID |
CONTRACT_NUMBER |
CONTRACT_NUMBER_MODIFIER |
CONTRACT_AMOUNT |
CURRENCY_CODE |
CONTRACT_STATUS_CODE |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
PARTY_ID |