View: OKL_OPT_RULE_VALUES_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_OPT_RULE_VALUES_UV

View Text

SELECT OVD.ID ID
, ORL.ID ORL_ID
, OVD.OVE_ID OVE_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_LOOKUP_MEANING('OKL_INTENT_TYPE'
, OVD.CONTEXT_INTENT) INTENT_DESCR
, OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_OPTION_VALUE_RULE_FLAG'
, OVD.COPY_OR_ENTER_FLAG) CPY_OR_ENT_DESCR
, OKL_ACCOUNTING_UTIL.GET_RULE_MEANING(ORL.RGR_RDF_CODE) MEANING
, OUTL.NAME CONTEXT_ORG_NAME
, OUTL_1.NAME CONTEXT_INV_ORG_NAME
, OVD.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, OVD.CONTEXT_INTENT CONTEXT_INTENT
, OVD.INDIVIDUAL_INSTRUCTIONS INDIVIDUAL_INSTRUCTIONS
, OVD.COPY_OR_ENTER_FLAG COPY_OR_ENTER_FLAG
, OVD.CONTEXT_ORG CONTEXT_ORG
, OVD.CONTEXT_INV_ORG CONTEXT_INV_ORG
, OVD.CONTEXT_ASSET_BOOK CONTEXT_ASSET_BOOK
, SRD.START_DATE START_DATE
, SRD.END_DATE END_DATE
FROM OKL_OPT_RULES ORL
, OKL_OPV_RULES OVD
, OKC_SUBCLASS_RG_DEFS SRD
, HR_ALL_ORGANIZATION_UNITS_TL OUTL
, HR_ALL_ORGANIZATION_UNITS_TL OUTL_1
WHERE ORL.LRG_LSE_ID IS NULL
AND ORL.ID = OVD.ORL_ID
AND OUTL.ORGANIZATION_ID(+) = OVD.CONTEXT_ORG
AND OUTL.LANGUAGE(+) = USERENV('LANG')
AND OUTL_1.ORGANIZATION_ID(+) = OVD.CONTEXT_INV_ORG
AND OUTL_1.LANGUAGE(+) = USERENV('LANG')
AND SRD.ID = ORL.SRD_ID_FOR

Columns