View: OKE_K_HISTORY_ORGNZR_V

Product:	OKE - Project Contracts
Description:	Contract Header Version History View for Organizer
Implementation/DBA Data:	APPS.OKE_K_HISTORY_ORGNZR_V

View Text

SELECT VH.K_HEADER_ID
, VH.MAJOR_VERSION
, VH.CREATION_DATE
, VH.CREATED_BY
, VH.LAST_UPDATE_DATE
, VH.LAST_UPDATED_BY
, VH.LAST_UPDATE_LOGIN
, VH.CREATION_DATE
, VH.VERSION_REASON_CODE
, VR.MEANING
, VH.CHG_REQUEST_ID
, CR.CHG_REQUEST_NUM
FROM OKE_K_VERS_NUMBERS_H VH
, OKE_CHG_REQUESTS CR
, FND_LOOKUP_VALUES_VL VR
WHERE VR.VIEW_APPLICATION_ID = 777
AND VR.LOOKUP_TYPE = 'VERSION_REASON'
AND VR.LOOKUP_CODE = VH.VERSION_REASON_CODE
AND CR.CHG_REQUEST_ID (+) = VH.CHG_REQUEST_ID

Columns