FND Design Data [Home] [Help]

View: OKL_OPT_RULES_UV

Product: OKL - Lease and Finance Management
Description:
Implementation/DBA Data: ViewAPPS.OKL_OPT_RULES_UV
View Text

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

Columns

Name
ID
OPT_ID
LSE_ID
LINE_STYLE
SRD_ID
SUBCLASS
RULE_GROUP
RULE
CONCATENATED_RULE
MEANING
OVERALL_INSTRUCTIONS
START_DATE
END_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN