View: OKL_LSE_SCS_RULES_V

Product:	OKL - Leasing 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