[Home] [Help]
View: OKC_LAUNCH_HISTORY_GRID_V
View Text
SELECT 'VERSION' TYPE
, V.CHR_ID CONTRACT_ID
, KH.CONTRACT_NUMBER CONTRACT_NUMBER
, KH.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, KT.SHORT_DESCRIPTION DESCRIPTION
, TO_CHAR(V.MAJOR_VERSION) MAJOR_VERSION
, V.LAST_UPDATED_BY CREATED_BY
, U.USER_NAME USER_NAME
, V.LAST_UPDATE_DATE CREATION_DATE
, TO_NUMBER(NULL) CHANGE_REQUEST_ID
, NULL NAME
FROM OKC_K_VERS_NUMBERS V
, FND_USER U
, OKC_K_HEADERS_B KH
, OKC_K_HEADERS_TL KT
WHERE KT.LANGUAGE = USERENV('LANG')
AND KH.ID = KT.ID
AND V.CHR_ID = KH.ID
AND V.LAST_UPDATED_BY = U.USER_ID
AND V.MINOR_VERSION = 0
AND V.MAJOR_VERSION <> 0 UNION ALL SELECT 'VERSION' TYPE
, V.CHR_ID CONTRACT_ID
, KH.CONTRACT_NUMBER CONTRACT_NUMBER
, KH.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, KT.SHORT_DESCRIPTION DESCRIPTION
, TO_CHAR(V.MAJOR_VERSION) MAJOR_VERSION
, V.LAST_UPDATED_BY CREATED_BY
, U.USER_NAME USER_NAME
, V.LAST_UPDATE_DATE CREATION_DATE
, TO_NUMBER(NULL) CHANGE_REQUEST_ID
, NULL NAME
FROM OKC_K_VERS_NUMBERS_H V
, FND_USER U
, OKC_K_HEADERS_BH KH
, OKC_K_HEADERS_TLH KT
WHERE KT.LANGUAGE = USERENV('LANG')
AND KH.ID = KT.ID
AND KH.MAJOR_VERSION = KT.MAJOR_VERSION
AND V.CHR_ID = KH.ID
AND V.MAJOR_VERSION = KH.MAJOR_VERSION
AND V.LAST_UPDATED_BY = U.USER_ID
AND V.MINOR_VERSION = 0
AND V.MAJOR_VERSION <> 0 UNION ALL SELECT 'CHANGE' TYPE
, CB.CHR_ID CONTRACT_ID
, KH.CONTRACT_NUMBER CONTRACT_NUMBER
, KH.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, CT.SHORT_DESCRIPTION DESCRIPTION
, CB.APPLIED_CONTRACT_VERSION MAJOR_VERSION
, CB.CREATED_BY CREATED_BY
, U.USER_NAME USER_NAME
, CB.CREATION_DATE CREATION_DATE
, CB.ID CHANGE_REQUEST_ID
, CT.NAME NAME
FROM OKC_CHANGE_REQUESTS_B CB
, OKC_CHANGE_REQUESTS_TL CT
, FND_USER U
, OKC_K_HEADERS_B KH
, OKC_K_HEADERS_TL KT
WHERE KT.LANGUAGE = USERENV('LANG')
AND KH.ID = KT.ID
AND CB.CHR_ID = KH.ID
AND CB.CREATED_BY = U.USER_ID
AND CT.ID = CB.ID
AND CT.LANGUAGE = USERENV('LANG')
Columns
Name |
TYPE |
CONTRACT_ID |
CONTRACT_NUMBER |
CONTRACT_NUMBER_MODIFIER |
DESCRIPTION |
MAJOR_VERSION |
CREATED_BY |
USER_NAME |
CREATION_DATE |
CHANGE_REQUEST_ID |
NAME |