VIEW: APPS.OKL_SO_PAYMENT_SCEN_UV

Source

View Text - Preformatted

SELECT rgp.id RGP_ID, rgp.cle_id LINE_ID, rlea.id AMT_RULE_ID, rleb.id STATUS_RULE_ID, rlec.id PAYMT_RULE_ID, rgp.dnz_chr_id DNZ_CHR_ID, rlea.rule_information1 AMOUNT, rleb.rule_information1 STATUS, rlec.rule_information5 TERM, rlec.rule_information4 ARREARS, rlec.rule_information11 START_DATE, fndb.meaning METHOD FROM OKC_RULE_GROUPS_B RGP,OKC_RULES_V RLEA,OKC_RULES_V RLEB,OKC_RULES_V RLEC,FND_LOOKUPS FNDB WHERE rgp.id = rlea.rgp_id AND rleb.rgp_id = rgp.id AND rlec.rgp_id = rgp.id AND rgp.rgd_code = 'SOPYSC' AND rlea.RULE_INFORMATION_CATEGORY = 'SOPAMT' AND rleb.RULE_INFORMATION_CATEGORY = 'SOPSST' AND rlec.RULE_INFORMATION_CATEGORY = 'SOPMSC' AND fndb.lookup_type = 'OKL_PRICING_METHOD' AND rlec.rule_information1 = fndb.lookup_code

View Text - HTML Formatted

SELECT RGP.ID RGP_ID
, RGP.CLE_ID LINE_ID
, RLEA.ID AMT_RULE_ID
, RLEB.ID STATUS_RULE_ID
, RLEC.ID PAYMT_RULE_ID
, RGP.DNZ_CHR_ID DNZ_CHR_ID
, RLEA.RULE_INFORMATION1 AMOUNT
, RLEB.RULE_INFORMATION1 STATUS
, RLEC.RULE_INFORMATION5 TERM
, RLEC.RULE_INFORMATION4 ARREARS
, RLEC.RULE_INFORMATION11 START_DATE
, FNDB.MEANING METHOD
FROM OKC_RULE_GROUPS_B RGP
, OKC_RULES_V RLEA
, OKC_RULES_V RLEB
, OKC_RULES_V RLEC
, FND_LOOKUPS FNDB
WHERE RGP.ID = RLEA.RGP_ID
AND RLEB.RGP_ID = RGP.ID
AND RLEC.RGP_ID = RGP.ID
AND RGP.RGD_CODE = 'SOPYSC'
AND RLEA.RULE_INFORMATION_CATEGORY = 'SOPAMT'
AND RLEB.RULE_INFORMATION_CATEGORY = 'SOPSST'
AND RLEC.RULE_INFORMATION_CATEGORY = 'SOPMSC'
AND FNDB.LOOKUP_TYPE = 'OKL_PRICING_METHOD'
AND RLEC.RULE_INFORMATION1 = FNDB.LOOKUP_CODE