[Home] [Help]
View: OKL_LSE_SCS_RULES_V
Product: | OKL - Lease and Finance Management |
Description: | View for getting the rule information required for product. This view provides information about line style ,subclass,rule group and the rule itself. |
Implementation/DBA Data: |
APPS.OKL_LSE_SCS_RULES_V
|
View Text
SELECT NULL LSE_ID
, NULL LINE_STYLE
, NULL LINE_TYPE
, NULL PARENT_ID
, SRD.ID SRD_ID
, SRD.SCS_CODE SUBCLASS
, RGR.RGD_CODE RULE_GROUP
, RGR.RDF_CODE RULE
, RGR.RDF_CODE || '.' || RGR.RGD_CODE || '.' || SRD.SCS_CODE CONCATENATED_RULE
, SRD.START_DATE
, SRD.END_DATE
, OKL_ACCOUNTING_UTIL.GET_RULE_MEANING( RGR.RDF_CODE) MEANING
FROM OKC_SUBCLASS_RG_DEFS SRD
, OKC_RG_DEF_RULES RGR
WHERE RGR.RGD_CODE = SRD.RGD_CODE
AND ( RGR.RGD_CODE = 'AMTEOC'
AND RGR.RDF_CODE = 'AMBPOC' OR RGR.RGD_CODE = 'AMTFOC'
AND RGR.RDF_CODE = 'AMBPOC' OR RGR.RGD_CODE = 'LAEVEL'
AND RGR.RDF_CODE = 'LAEVEL' OR RGR.RGD_CODE = 'LAIIND'
AND RGR.RDF_CODE = 'LAINTP' )
Columns
Name |
LSE_ID |
LINE_STYLE |
LINE_TYPE |
PARENT_ID |
SRD_ID |
SUBCLASS |
RULE_GROUP |
RULE |
CONCATENATED_RULE |
START_DATE |
END_DATE |
MEANING |