VIEW: APPS.OKL_LSE_SCS_RULES_V

Source

View Text - Preformatted

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' )

View Text - HTML Formatted

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' )