VIEW: APPS.OKC_LAUNCH_HISTORY_GRID_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')