View: OKL_SO_PLAN_SUMMARY_UV

Product:	OKL - Lease and Finance Management
Description:	Used to display Plan Summary information on the Quote Details screen
Implementation/DBA Data:	APPS.OKL_SO_PLAN_SUMMARY_UV

View Text

SELECT RGP.CLE_ID PAYMENT_PLAN_ID
, SOPMSC.DNZ_CHR_ID CHR_ID
, METHOD.MEANING||' - '||DECODE(SOPMSC.RULE_INFORMATION1
, 'RC'
, LRTV.NAME
, SOPMSC.RULE_INFORMATION7) NAME
, BOOKCLASS.MEANING BOOK_CLASS
, SOPAMT.RULE_INFORMATION5 PAYMENT
, STATUS.MEANING STATUS
, STRUC.MEANING PAYMENT_STRUCTURE
FROM OKC_RULE_GROUPS_B RGP
, OKC_RULES_B SOPMSC
, OKC_RULES_B SOPAMT
, OKC_RULES_B SOPSST
, FND_LOOKUPS METHOD
, OKL_LS_RT_FCTR_SETS_B LRTV
, FND_LOOKUPS BOOKCLASS
, FND_LOOKUPS STATUS
, FND_LOOKUPS STRUC
WHERE RGP.RGD_CODE = 'SOPYSC'
AND RGP.ID = SOPAMT.RGP_ID
AND RGP.ID = SOPSST.RGP_ID
AND RGP.ID = SOPMSC.RGP_ID
AND SOPAMT.RULE_INFORMATION_CATEGORY = 'SOPAMT'
AND SOPSST.RULE_INFORMATION_CATEGORY = 'SOPSST'
AND SOPMSC.RULE_INFORMATION_CATEGORY = 'SOPMSC'
AND SOPMSC.RULE_INFORMATION1 = METHOD.LOOKUP_CODE
AND METHOD.LOOKUP_TYPE = 'OKL_PRICING_METHOD'
AND SOPMSC.RULE_INFORMATION2 = LRTV.ID(+)
AND SOPMSC.RULE_INFORMATION9 = BOOKCLASS.LOOKUP_CODE
AND BOOKCLASS.LOOKUP_TYPE = 'OKL_BOOK_CLASS'
AND SOPSST.RULE_INFORMATION1 = STATUS.LOOKUP_CODE
AND STATUS.LOOKUP_TYPE = 'OKL_PAYMENT_PLAN_STATUS'
AND SOPMSC.RULE_INFORMATION3 = STRUC.LOOKUP_CODE
AND STRUC.LOOKUP_TYPE = 'OKL_PAYMENT_STRUCTURES'

Columns