VIEW: APPS.OKL_SO_PLAN_SUMMARY_UV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'