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.OKL_SO_PLAN_PRICING_PARAMS_UV

Source

View Text - Preformatted


SELECT rul.id SOPSAD_RULE_ID, rul.object1_id1 SOPMSC_RULE_ID, clet.item_description ITEM_DESCRIPTION, rul.rule_information2 DEFAULT_RESIDUAL, rul.rule_information4 PRICING_RESIDUAL, rul.rule_information1 DEFAULT_LEASE_RATE, rul.rule_information3 PRICING_LEASE_RATE FROM OKC_K_LINES_TL CLET,OKC_RULES_B RUL,OKC_RULE_GROUPS_B RGP WHERE rgp.rgd_code = 'SOPSAD' AND rgp.id = rul.rgp_id AND rgp.cle_id = clet.id AND clet.language = USERENV('LANG')

View Text - HTML Formatted

SELECT RUL.ID SOPSAD_RULE_ID
, RUL.OBJECT1_ID1 SOPMSC_RULE_ID
, CLET.ITEM_DESCRIPTION ITEM_DESCRIPTION
, RUL.RULE_INFORMATION2 DEFAULT_RESIDUAL
, RUL.RULE_INFORMATION4 PRICING_RESIDUAL
, RUL.RULE_INFORMATION1 DEFAULT_LEASE_RATE
, RUL.RULE_INFORMATION3 PRICING_LEASE_RATE
FROM OKC_K_LINES_TL CLET
, OKC_RULES_B RUL
, OKC_RULE_GROUPS_B RGP
WHERE RGP.RGD_CODE = 'SOPSAD'
AND RGP.ID = RUL.RGP_ID
AND RGP.CLE_ID = CLET.ID
AND CLET.LANGUAGE = USERENV('LANG')