[Home] [Help]
View: OKS_CONT_HEADERS_V
Product: | OKS - Service Contracts |
Description: | This view is created for the object type OKS_K_HEADER used for the update level attribute in Mass change |
Implementation/DBA Data: |
APPS.OKS_CONT_HEADERS_V
|
View Text
SELECT ID ID1
, '#' ID2
, CONTRACT_NUMBER NAME
, CONTRACT_NUMBER CONTRACT_NUMBER
, CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, SHORT_DESCRIPTION DESCRIPTION
, START_DATE START_DATE
, END_DATE END_DATE
FROM OKC_K_HEADERS_V
WHERE APPLICATION_ID = 515
Columns
Name |
ID1 |
ID2 |
NAME |
CONTRACT_NUMBER |
CONTRACT_NUMBER_MODIFIER |
DESCRIPTION |
START_DATE |
END_DATE |