VIEW: APPS.OKL_OPT_RULE_VALUES_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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