eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKC_RULES2_BLK_V

Source

View Text - Preformatted


SELECT rgrl.RGD_CODE ,rgrl.RDF_CODE ,decode(rgrl.OPTIONAL_YN,'Y','N','Y') REQUIRED_YN ,lkp.meaning RULE_NAME from OKC_RG_DEF_RULES_V rgrl, okc_rule_defs_v lkp WHERE rgrl.RDF_CODE = lkp.rule_code

View Text - HTML Formatted

SELECT RGRL.RGD_CODE
, RGRL.RDF_CODE
, DECODE(RGRL.OPTIONAL_YN
, 'Y'
, 'N'
, 'Y') REQUIRED_YN
, LKP.MEANING RULE_NAME
FROM OKC_RG_DEF_RULES_V RGRL
, OKC_RULE_DEFS_V LKP
WHERE RGRL.RDF_CODE = LKP.RULE_CODE