View: OKL_SO_PAYMENT_SCEN_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_SO_PAYMENT_SCEN_UV

View Text

SELECT RGP.ID RGP_ID
, RGP.CLE_ID LINE_ID
, SOPAMT.ID AMT_RULE_ID
, SOPSST.ID STATUS_RULE_ID
, SOPAMT.ID PAYMT_RULE_ID
, RGP.DNZ_CHR_ID DNZ_CHR_ID
, SOPAMT.RULE_INFORMATION5 AMOUNT
, STATUS.MEANING STATUS
, NULL TERM
, NULL ARREARS
, NULL START_DATE
, METHOD.MEANING METHOD
FROM OKC_RULE_GROUPS_B RGP
, OKC_RULES_B SOPMSC
, OKC_RULES_B SOPAMT
, OKC_RULES_B SOPSST
, FND_LOOKUPS METHOD
, FND_LOOKUPS STATUS
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 SOPSST.RULE_INFORMATION1 = STATUS.LOOKUP_CODE
AND STATUS.LOOKUP_TYPE = 'OKL_PAYMENT_PLAN_STATUS'

Columns