[Home] [Help]
View: OKS_K_DETAIL_V
Product: | OKS - Service Contracts |
Description: | view for contracts detail form |
Implementation/DBA Data: |
APPS.OKS_K_DETAIL_V
|
View Text
SELECT KH.CONTRACT_NUMBER CONTRACT_NUMBER
, KH.START_DATE START_DATE
, KH.END_DATE END_DATE
, KD.ID ID
, KD.ORDER_LINE_ID1 ORDER_LINE_ID1
, KD.CHR_ID CHR_ID
, KD.CLE_ID CLE_ID
, KD.OBJECT_VERSION_NUMBER
FROM OKC_K_HEADERS_V KH
, OKS_K_ORDER_DETAILS_V KD
WHERE KD.LINK_CHR_ID = KH.ID
Columns
Name |
CONTRACT_NUMBER |
START_DATE |
END_DATE |
ID |
ORDER_LINE_ID1 |
CHR_ID |
CLE_ID |
OBJECT_VERSION_NUMBER |