VIEW: APPS.OKL_LA_PAYMENTS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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