[Home] [Help]
View: OKC_CONVERSION_ATTRIBS_V
View Text
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
Columns
Name |
RUL_ID |
CHR_ID |
CLE_ID |
DNZ_CHR_ID |
CONVERSION_TYPE |
CONVERSION_DATE |
CONVERSION_RATE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |