Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_OPT_RULES_UV |
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