View: OKL_SO_PLAN_DETAILS_UV

Product:	OKL - Lease and Finance Management
Description:	Used to display Payment Plan Details on screen
Implementation/DBA Data:	APPS.OKL_SO_PLAN_DETAILS_UV

View Text

SELECT RGP.CLE_ID PAYMENT_PLAN_ID
, CLET.NAME PLAN_NAME
, RGP.DNZ_CHR_ID CHR_ID
, RGP.ID SOPYSC_RG_ID
, SOPMSC.ID SOPMSC_RULE_ID
, SOPSST.ID SOPSST_RULE_ID
, SORVGT.ID SORVGT_RULE_ID
, SOPSST.RULE_INFORMATION1 PLAN_STATUS_CODE
, STATUS.MEANING PLAN_STATUS
, SOPMSC.RULE_INFORMATION4 PRICING_ENGINE_CODE
, SOPMSC.RULE_INFORMATION1 PRICING_METHOD_CODE
, LRTV.ID RATE_CARD_ID
, LRTV.NAME RATE_CARD
, SOPMSC.RULE_INFORMATION7 RATE
, SOPMSC.RULE_INFORMATION3 PAYMENT_STRUCTURE_CODE
, SOPMSC.RULE_INFORMATION9 BOOK_CLASS_CODE
, SOPMSC.RULE_INFORMATION10 TAX_OWNER_CODE
, SORVGT.RULE_INFORMATION1 GUARANTEE_TYPE_CODE
, SORVGT.RULE_INFORMATION2 GUARANTEE_AMOUNT
, SORVGT.RULE_INFORMATION3 CALCULATE_RVI_YN
, SORVGT.RULE_INFORMATION4 RVI_RATE
, LRTV.FRQ_CODE FREQUENCY_CODE
, LRTV.ARREARS_YN ARREARS_YN
, SOPMSC.RULE_INFORMATION5 ESTIMATED_TAX_PERCENTAGE
, SOPSST.RULE_INFORMATION4 SAVE_POINT
FROM OKC_K_LINES_TL CLET
, OKC_RULE_GROUPS_B RGP
, OKL_LS_RT_FCTR_SETS_B LRTV
, OKC_RULES_B SOPMSC
, OKC_RULES_B SOPSST
, OKC_RULES_B SORVGT
, FND_LOOKUPS STATUS
, FND_LOOKUPS METHOD
WHERE RGP.RGD_CODE = 'SOPYSC'
AND RGP.ID = SOPMSC.RGP_ID
AND RGP.ID = SOPSST.RGP_ID
AND RGP.ID = SORVGT.RGP_ID
AND SOPMSC.RULE_INFORMATION_CATEGORY = 'SOPMSC'
AND SOPSST.RULE_INFORMATION_CATEGORY = 'SOPSST'
AND SORVGT.RULE_INFORMATION_CATEGORY = 'SORVGT'
AND TO_NUMBER(SOPMSC.RULE_INFORMATION2) = LRTV.ID (+)
AND SOPSST.RULE_INFORMATION1 = STATUS.LOOKUP_CODE
AND STATUS.LOOKUP_TYPE = 'OKL_PAYMENT_PLAN_STATUS'
AND SOPMSC.RULE_INFORMATION1 = METHOD.LOOKUP_CODE
AND METHOD.LOOKUP_TYPE = 'OKL_PRICING_METHOD'
AND RGP.CLE_ID = CLET.ID
AND CLET.LANGUAGE = USERENV('LANG')

Columns