VIEW: APPS.OKL_SO_PLAN_DETAILS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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