[Home] [Help]
View: 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
Name |
SOPSAD_RULE_ID |
SOPMSC_RULE_ID |
ITEM_DESCRIPTION |
DEFAULT_RESIDUAL |
PRICING_RESIDUAL |
DEFAULT_LEASE_RATE |
PRICING_LEASE_RATE |