[Home] [Help]
View: OKL_RULE_TEMPLATE_UV
View Text
SELECT OVT.ID ID
, RULB.ID RUL_ID
, OVT.OVD_ID OVD_ID
, TO_CHAR(NULL) COMMENTS
, OVT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, OVT.SEQUENCE_NUMBER SEQUENCE_NUMBER
, RULB.RULE_INFORMATION_CATEGORY RULE_INFORMATION_CATEGORY
, OKL_ACCOUNTING_UTIL.GET_RULE_MEANING(RULB.RULE_INFORMATION_CATEGORY) MEANING
FROM OKC_RULES_B RULB
, OKL_OPV_RULES OVD
, OKL_OVD_RUL_TMLS OVT
WHERE OVT.OVD_ID = OVD.ID
AND RULB.ID = OVT.RUL_ID
Columns
Name |
ID |
RUL_ID |
OVD_ID |
COMMENTS |
OBJECT_VERSION_NUMBER |
SEQUENCE_NUMBER |
RULE_INFORMATION_CATEGORY |
MEANING |