VIEW: APPS.OKL_OPT_RULES_UV

Source

View Text - Preformatted

SELECT orl.id id, orl.opt_id opt_id, NULL lse_id, NULL line_style, orl.srd_id_for srd_id, srd.scs_code subclass, orl.rgr_rgd_code rulegroup, orl.rgr_rdf_code rule, orl.rgr_rdf_code || '.' || orl.rgr_rgd_code || '.' || srd.scs_code concatenated_rule, okl_Accounting_util.get_rule_meaning( orl.rgr_rdf_code) meaning, orl.overall_instructions overall_instructions, srd.start_date start_date, srd.end_date end_date, orl.created_by created_by, orl.creation_date creation_date, orl.last_updated_by last_updated_by, orl.last_update_date last_update_date , orl.last_update_login last_update_login FROM OKL_OPT_RULES ORL,OKC_SUBCLASS_RG_DEFS SRD WHERE orl.lrg_lse_id is null and srd.id = orl.srd_id_for

View Text - HTML Formatted

SELECT ORL.ID ID
, ORL.OPT_ID OPT_ID
, NULL LSE_ID
, NULL LINE_STYLE
, ORL.SRD_ID_FOR SRD_ID
, SRD.SCS_CODE SUBCLASS
, ORL.RGR_RGD_CODE RULEGROUP
, ORL.RGR_RDF_CODE RULE
, ORL.RGR_RDF_CODE || '.' || ORL.RGR_RGD_CODE || '.' || SRD.SCS_CODE CONCATENATED_RULE
, OKL_ACCOUNTING_UTIL.GET_RULE_MEANING( ORL.RGR_RDF_CODE) MEANING
, ORL.OVERALL_INSTRUCTIONS OVERALL_INSTRUCTIONS
, SRD.START_DATE START_DATE
, SRD.END_DATE END_DATE
, ORL.CREATED_BY CREATED_BY
, ORL.CREATION_DATE CREATION_DATE
, ORL.LAST_UPDATED_BY LAST_UPDATED_BY
, ORL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ORL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_OPT_RULES ORL
, OKC_SUBCLASS_RG_DEFS SRD
WHERE ORL.LRG_LSE_ID IS NULL
AND SRD.ID = ORL.SRD_ID_FOR