View: OKL_SO_PLAN_PRICING_PARAMS_UV

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

View Text

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')

Columns