VIEW: APPS.OKC_CONVERSION_ATTRIBS_HV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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