VIEW: APPS.OKC_CONVERSION_ATTRIBS_V

Source

View Text - Preformatted

SELECT rul.id rul_id, 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_b rul, okc_rule_groups_b rgp, okc_k_headers_b chr WHERE rul.rule_information_category = 'CVN' AND rul.rgp_id = rgp.id AND rgp.dnz_chr_id = chr.id

View Text - HTML Formatted

SELECT RUL.ID RUL_ID
, 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_B RUL
, OKC_RULE_GROUPS_B RGP
, OKC_K_HEADERS_B CHR
WHERE RUL.RULE_INFORMATION_CATEGORY = 'CVN'
AND RUL.RGP_ID = RGP.ID
AND RGP.DNZ_CHR_ID = CHR.ID