View: OKL_LA_PAYMENTS_UV

Product:	OKL - Lease and Finance Management
Description:	User Interface view for payments page
Implementation/DBA Data:	APPS.OKL_LA_PAYMENTS_UV

View Text

SELECT RL.ID ID
, RL.RGP_ID RGP_ID
, RL.DNZ_CHR_ID DNZ_CHR_ID
, RL.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, RL.OBJECT1_ID1 OBJECT1_ID1
, RL.OBJECT1_ID2 OBJECT1_ID2
, RL.JTOT_OBJECT2_CODE JTOT_OBJECT2_CODE
, RL.OBJECT2_ID1 OBJECT2_ID1
, RL.OBJECT2_ID2 OBJECT2_ID2
, RL.JTOT_OBJECT3_CODE JTOT_OBJECT3_CODE
, RL.OBJECT3_ID1 OBJECT3_ID1
, RL.OBJECT3_ID2 OBJECT3_ID2
, RL.RULE_INFORMATION1 RULE_INFORMATION1
, OKL_LLA_UTIL_PVT.GET_DISPLAY_DATE(NVL(RL.RULE_INFORMATION2
, '')) RULE_INFORMATION2
, RL.RULE_INFORMATION3 RULE_INFORMATION3
, RL.RULE_INFORMATION4 RULE_INFORMATION4
, RL.RULE_INFORMATION5 RULE_INFORMATION5
, RL.RULE_INFORMATION6 RULE_INFORMATION6
, RL.RULE_INFORMATION7 RULE_INFORMATION7
, RL.RULE_INFORMATION8 RULE_INFORMATION8
, RL.RULE_INFORMATION9 RULE_INFORMATION9
, RL.RULE_INFORMATION10 RULE_INFORMATION10
, RL.RULE_INFORMATION11 RULE_INFORMATION11
, RL.RULE_INFORMATION12 RULE_INFORMATION12
, RL.RULE_INFORMATION13 RULE_INFORMATION13
, RL.RULE_INFORMATION14 RULE_INFORMATION14
, RL.RULE_INFORMATION15 RULE_INFORMATION15
, RL.RULE_INFORMATION_CATEGORY RULE_INFORMATION_CATEGORY
, FND_DATE.CANONICAL_TO_DATE(NVL(RL.RULE_INFORMATION2
, NULL)) START_DATE
, RULE_INFORMATION2 CNL_START_DATE
, OKL_LA_PAYMENTS_PVT.GET_DISPLAY_END_DATE( RL.RULE_INFORMATION2
, RL.RULE_INFORMATION7
, RL.OBJECT1_ID1
, RL.RULE_INFORMATION3
, OKL_LA_PAYMENTS_PVT.GET_START_DAY(RL.ID
, RL.DNZ_CHR_ID
, RL.RGP_ID
, RL.OBJECT2_ID1
, RL.RULE_INFORMATION2)
, (SELECT END_DATE
FROM OKC_K_HEADERS_B
WHERE ID = RL.DNZ_CHR_ID)) END_DATE
FROM OKC_RULES_V RL
WHERE RL.RULE_INFORMATION_CATEGORY = 'LASLL' ORDER BY START_DATE

Columns