View: OKC_CONVERSION_ATTRIBS_HV

Product:	OKC - Contracts Core
Description:	History view for OKC_CONVERSION_ATTRIBS.
Implementation/DBA Data:	APPS.OKC_CONVERSION_ATTRIBS_HV

View Text

SELECT RUL.ID RUL_ID
, RUL.MAJOR_VERSION
, RGP.CHR_ID
, RGP.CLE_ID
, RUL.DNZ_CHR_ID
, RUL.OBJECT1_ID1 CONVERSION_TYPE
, TO_DATE(RUL.RULE_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS' ) CONVERSION_DATE
, TO_NUMBER(DECODE(OKC_CURRENCY_API.GET_CURRENCY_TYPE( OKC_CURRENCY_API.GET_OU_CURRENCY(CHR.AUTHORING_ORG_ID)
, TO_DATE(RUL.RULE_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS' ))
, 'EMU'
, RUL.RULE_INFORMATION3
, RUL.RULE_INFORMATION1)) CONVERSION_RATE
, RUL.CREATED_BY
, RUL.CREATION_DATE
, RUL.LAST_UPDATED_BY
, RUL.LAST_UPDATE_DATE
, RUL.LAST_UPDATE_LOGIN
FROM OKC_RULES_BH RUL
, OKC_RULE_GROUPS_BH RGP
, OKC_K_HEADERS_BH CHR
WHERE RUL.RULE_INFORMATION_CATEGORY = 'CVN'
AND RUL.RGP_ID = RGP.ID
AND RGP.DNZ_CHR_ID = CHR.ID
AND RGP.MAJOR_VERSION = CHR.MAJOR_VERSION
AND RUL.MAJOR_VERSION = RGP.MAJOR_VERSION

Columns