[Home] [Help]
View: OKS_CONTRACT_NUMBER_V
Product: | OKS - Service Contracts |
Description: | View Is Used For Quote Printing LOV to display distinct Contract Numbers |
Implementation/DBA Data: |
APPS.OKS_CONTRACT_NUMBER_V
|
View Text
SELECT DISTINCT CHRB.CONTRACT_NUMBER
, CHRT.SHORT_DESCRIPTION
FROM OKC_K_HEADERS_B CHRB
, OKC_K_HEADERS_TL CHRT
WHERE CHRB.ID = CHRT.ID
AND CHRB.SCS_CODE = 'WARRANTY'
AND CHRT.LANGUAGE = USERENV('LANG')
Columns
Name |
CONTRACT_NUMBER |
SHORT_DESCRIPTION |