VIEW: APPS.OKC_RULES1_BLK_V

Source

View Text - Preformatted

SELECT rle.RULE_INFORMATION_CATEGORY ,rle.DNZ_CHR_ID ,rle.RGP_ID ,rle.ID ,rle.OBJECT_VERSION_NUMBER ,rle.JTOT_OBJECT1_CODE ,rle.OBJECT1_ID1 ,rle.OBJECT1_ID2 ,substrb(OKC_RULE_PUB.get_object_val(rle.JTOT_OBJECT1_CODE,rle.OBJECT1_ID1,rle .OBJECT1_ID2),1,240) JTOT_OBJECT1_val ,substrb(OKC_RULE_PUB.get_object_dsc(rle.JTOT_OBJECT1_CODE,rle.OBJECT1_ID1,rle .OBJECT1_ID2),1,240) JTOT_OBJECT1_dsc ,rle.JTOT_OBJECT2_CODE ,rle.OBJECT2_ID1 ,rle.OBJECT2_ID2 ,substrb(OKC_RULE_PUB.get_object_val(rle.JTOT_OBJECT2_CODE,rle.OBJECT2_ID1, rle.OBJECT2_ID2),1,240) JTOT_OBJECT2_val ,substrb(OKC_RULE_PUB.get_object_dsc(rle.JTOT_OBJECT2_CODE,rle.OBJECT2_ID1, rle.OBJECT2_ID2),1,240) JTOT_OBJECT2_dsc ,rle.JTOT_OBJECT3_CODE ,rle.OBJECT3_ID1 ,rle.OBJECT3_ID2 ,substrb(OKC_RULE_PUB.get_object_val(rle.JTOT_OBJECT3_CODE,rle.OBJECT3_ID1, rle.OBJECT3_ID2),1,240) JTOT_OBJECT3_val ,substrb(OKC_RULE_PUB.get_object_dsc(rle.JTOT_OBJECT3_CODE,rle.OBJECT3_ID1, rle.OBJECT3_ID2),1,240) JTOT_OBJECT3_dsc ,rle.RULE_INFORMATION1 ,substrb(OKC_RULE_PUB.get_flex_val(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION1',rle.RULE_INFORMATION1),1,240) RULE_INFORMATION1_val ,substrb(OKC_RULE_PUB.get_flex_dsc(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION1',rle.RULE_INFORMATION1),1,240) RULE_INFORMATION1_dsc ,rle.RULE_INFORMATION2 ,substrb(OKC_RULE_PUB.get_flex_val(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION2',rle.RULE_INFORMATION2),1,240) RULE_INFORMATION2_val ,substrb(OKC_RULE_PUB.get_flex_dsc(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION2',rle.RULE_INFORMATION2),1,240) RULE_INFORMATION2_dsc ,rle.RULE_INFORMATION3 ,substrb(OKC_RULE_PUB.get_flex_val(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION3',rle.RULE_INFORMATION3),1,240) RULE_INFORMATION3_val ,substrb(OKC_RULE_PUB.get_flex_dsc(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION3',rle.RULE_INFORMATION3),1,240) RULE_INFORMATION3_dsc ,rle.RULE_INFORMATION4 ,substrb(OKC_RULE_PUB.get_flex_val(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION4',rle.RULE_INFORMATION4),1,240) RULE_INFORMATION4_val ,substrb(OKC_RULE_PUB.get_flex_dsc(rle.RULE_INFORMATION_CATEGORY,' RULE_INFORMATION4',rle.RULE_INFORMATION4),1,240) RULE_INFORMATION4_dsc ,rle.RULE_INFORMATION5 ,substrb(OKC_RULE_PUB.get_flex_val(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION5',rle.RULE_INFORMATION5),1,240) RULE_INFORMATION5_val ,substrb(OKC_RULE_PUB.get_flex_dsc(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION5',rle.RULE_INFORMATION5),1,240) RULE_INFORMATION5_dsc ,rle.RULE_INFORMATION6 ,substrb(OKC_RULE_PUB.get_flex_val(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION6',rle.RULE_INFORMATION6),1,240) RULE_INFORMATION6_val ,substrb(OKC_RULE_PUB.get_flex_dsc(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION6',rle.RULE_INFORMATION6),1,240) RULE_INFORMATION6_dsc ,rle.RULE_INFORMATION7 ,substrb(OKC_RULE_PUB.get_flex_val(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION7',rle.RULE_INFORMATION7),1,240) RULE_INFORMATION7_val ,substrb(OKC_RULE_PUB.get_flex_dsc(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION7',rle.RULE_INFORMATION7),1,240) RULE_INFORMATION7_dsc ,rle.RULE_INFORMATION8 ,substrb(OKC_RULE_PUB.get_flex_val(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION8',rle.RULE_INFORMATION8),1,240) RULE_INFORMATION8_val ,substrb(OKC_RULE_PUB.get_flex_dsc(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION8',rle.RULE_INFORMATION8),1,240) RULE_INFORMATION8_dsc ,rle.RULE_INFORMATION9 ,substrb(OKC_RULE_PUB.get_flex_val(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION9',rle.RULE_INFORMATION9),1,240) RULE_INFORMATION9_val ,substrb(OKC_RULE_PUB.get_flex_dsc(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION9',rle.RULE_INFORMATION9),1,240) RULE_INFORMATION9_dsc ,rle.RULE_INFORMATION10 ,substrb(OKC_RULE_PUB.get_flex_val(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION10',rle.RULE_INFORMATION10),1,240) RULE_INFORMATION10_val ,substrb(OKC_RULE_PUB.get_flex_dsc(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION10',rle.RULE_INFORMATION10),1,240) RULE_INFORMATION10_dsc ,rle.RULE_INFORMATION11 ,substrb(OKC_RULE_PUB.get_flex_val(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION11',rle.RULE_INFORMATION11),1,240) RULE_INFORMATION11_val ,substrb(OKC_RULE_PUB.get_flex_dsc(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION11',rle.RULE_INFORMATION11),1,240) RULE_INFORMATION11_dsc ,rle.RULE_INFORMATION12 ,substrb(OKC_RULE_PUB.get_flex_val(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION12',rle.RULE_INFORMATION12),1,240) RULE_INFORMATION12_val ,substrb(OKC_RULE_PUB.get_flex_dsc(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION12',rle.RULE_INFORMATION12),1,240) RULE_INFORMATION12_dsc ,rle.RULE_INFORMATION13 ,substrb(OKC_RULE_PUB.get_flex_val(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION13',rle.RULE_INFORMATION13),1,240) RULE_INFORMATION13_val ,substrb(OKC_RULE_PUB.get_flex_dsc(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION13',rle.RULE_INFORMATION13),1,240) RULE_INFORMATION13_dsc ,rle.RULE_INFORMATION14 ,substrb(OKC_RULE_PUB.get_flex_val(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION14',rle.RULE_INFORMATION14),1,240) RULE_INFORMATION14_val ,substrb(OKC_RULE_PUB.get_flex_dsc(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION14',rle.RULE_INFORMATION14),1,240) RULE_INFORMATION14_dsc ,rle.RULE_INFORMATION15 ,substrb(OKC_RULE_PUB.get_flex_val(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION15',rle.RULE_INFORMATION15),1,240) RULE_INFORMATION15_val ,substrb(OKC_RULE_PUB.get_flex_dsc(rle.RULE_INFORMATION_CATEGORY, 'RULE_INFORMATION15',rle.RULE_INFORMATION15),1,240) RULE_INFORMATION15_dsc ,rle.CREATED_BY ,rle.CREATION_DATE ,rle.LAST_UPDATED_BY ,rle.LAST_UPDATE_DATE ,rle.LAST_UPDATE_LOGIN ,rle.TEMPLATE_YN TEMPLATE_YN ,rle.ANS_SET_JTOT_OBJECT_CODE ANS_SET_JTOT_OBJECT_CODE ,rle.ANS_SET_JTOT_OBJECT_ID1 ANS_SET_JTOT_OBJECT_ID1 ,rle.ANS_SET_JTOT_OBJECT_ID2 ANS_SET_JTOT_OBJECT_ID2 ,rle.DISPLAY_SEQUENCE DISPLAY_SEQUENCE from okc_rules_v rle

View Text - HTML Formatted

SELECT RLE.RULE_INFORMATION_CATEGORY
, RLE.DNZ_CHR_ID
, RLE.RGP_ID
, RLE.ID
, RLE.OBJECT_VERSION_NUMBER
, RLE.JTOT_OBJECT1_CODE
, RLE.OBJECT1_ID1
, RLE.OBJECT1_ID2
, SUBSTRB(OKC_RULE_PUB.GET_OBJECT_VAL(RLE.JTOT_OBJECT1_CODE
, RLE.OBJECT1_ID1
, RLE .OBJECT1_ID2)
, 1
, 240) JTOT_OBJECT1_VAL
, SUBSTRB(OKC_RULE_PUB.GET_OBJECT_DSC(RLE.JTOT_OBJECT1_CODE
, RLE.OBJECT1_ID1
, RLE .OBJECT1_ID2)
, 1
, 240) JTOT_OBJECT1_DSC
, RLE.JTOT_OBJECT2_CODE
, RLE.OBJECT2_ID1
, RLE.OBJECT2_ID2
, SUBSTRB(OKC_RULE_PUB.GET_OBJECT_VAL(RLE.JTOT_OBJECT2_CODE
, RLE.OBJECT2_ID1
, RLE.OBJECT2_ID2)
, 1
, 240) JTOT_OBJECT2_VAL
, SUBSTRB(OKC_RULE_PUB.GET_OBJECT_DSC(RLE.JTOT_OBJECT2_CODE
, RLE.OBJECT2_ID1
, RLE.OBJECT2_ID2)
, 1
, 240) JTOT_OBJECT2_DSC
, RLE.JTOT_OBJECT3_CODE
, RLE.OBJECT3_ID1
, RLE.OBJECT3_ID2
, SUBSTRB(OKC_RULE_PUB.GET_OBJECT_VAL(RLE.JTOT_OBJECT3_CODE
, RLE.OBJECT3_ID1
, RLE.OBJECT3_ID2)
, 1
, 240) JTOT_OBJECT3_VAL
, SUBSTRB(OKC_RULE_PUB.GET_OBJECT_DSC(RLE.JTOT_OBJECT3_CODE
, RLE.OBJECT3_ID1
, RLE.OBJECT3_ID2)
, 1
, 240) JTOT_OBJECT3_DSC
, RLE.RULE_INFORMATION1
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_VAL(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION1'
, RLE.RULE_INFORMATION1)
, 1
, 240) RULE_INFORMATION1_VAL
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_DSC(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION1'
, RLE.RULE_INFORMATION1)
, 1
, 240) RULE_INFORMATION1_DSC
, RLE.RULE_INFORMATION2
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_VAL(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION2'
, RLE.RULE_INFORMATION2)
, 1
, 240) RULE_INFORMATION2_VAL
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_DSC(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION2'
, RLE.RULE_INFORMATION2)
, 1
, 240) RULE_INFORMATION2_DSC
, RLE.RULE_INFORMATION3
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_VAL(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION3'
, RLE.RULE_INFORMATION3)
, 1
, 240) RULE_INFORMATION3_VAL
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_DSC(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION3'
, RLE.RULE_INFORMATION3)
, 1
, 240) RULE_INFORMATION3_DSC
, RLE.RULE_INFORMATION4
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_VAL(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION4'
, RLE.RULE_INFORMATION4)
, 1
, 240) RULE_INFORMATION4_VAL
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_DSC(RLE.RULE_INFORMATION_CATEGORY
, ' RULE_INFORMATION4'
, RLE.RULE_INFORMATION4)
, 1
, 240) RULE_INFORMATION4_DSC
, RLE.RULE_INFORMATION5
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_VAL(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION5'
, RLE.RULE_INFORMATION5)
, 1
, 240) RULE_INFORMATION5_VAL
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_DSC(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION5'
, RLE.RULE_INFORMATION5)
, 1
, 240) RULE_INFORMATION5_DSC
, RLE.RULE_INFORMATION6
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_VAL(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION6'
, RLE.RULE_INFORMATION6)
, 1
, 240) RULE_INFORMATION6_VAL
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_DSC(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION6'
, RLE.RULE_INFORMATION6)
, 1
, 240) RULE_INFORMATION6_DSC
, RLE.RULE_INFORMATION7
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_VAL(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION7'
, RLE.RULE_INFORMATION7)
, 1
, 240) RULE_INFORMATION7_VAL
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_DSC(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION7'
, RLE.RULE_INFORMATION7)
, 1
, 240) RULE_INFORMATION7_DSC
, RLE.RULE_INFORMATION8
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_VAL(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION8'
, RLE.RULE_INFORMATION8)
, 1
, 240) RULE_INFORMATION8_VAL
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_DSC(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION8'
, RLE.RULE_INFORMATION8)
, 1
, 240) RULE_INFORMATION8_DSC
, RLE.RULE_INFORMATION9
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_VAL(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION9'
, RLE.RULE_INFORMATION9)
, 1
, 240) RULE_INFORMATION9_VAL
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_DSC(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION9'
, RLE.RULE_INFORMATION9)
, 1
, 240) RULE_INFORMATION9_DSC
, RLE.RULE_INFORMATION10
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_VAL(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION10'
, RLE.RULE_INFORMATION10)
, 1
, 240) RULE_INFORMATION10_VAL
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_DSC(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION10'
, RLE.RULE_INFORMATION10)
, 1
, 240) RULE_INFORMATION10_DSC
, RLE.RULE_INFORMATION11
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_VAL(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION11'
, RLE.RULE_INFORMATION11)
, 1
, 240) RULE_INFORMATION11_VAL
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_DSC(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION11'
, RLE.RULE_INFORMATION11)
, 1
, 240) RULE_INFORMATION11_DSC
, RLE.RULE_INFORMATION12
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_VAL(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION12'
, RLE.RULE_INFORMATION12)
, 1
, 240) RULE_INFORMATION12_VAL
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_DSC(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION12'
, RLE.RULE_INFORMATION12)
, 1
, 240) RULE_INFORMATION12_DSC
, RLE.RULE_INFORMATION13
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_VAL(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION13'
, RLE.RULE_INFORMATION13)
, 1
, 240) RULE_INFORMATION13_VAL
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_DSC(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION13'
, RLE.RULE_INFORMATION13)
, 1
, 240) RULE_INFORMATION13_DSC
, RLE.RULE_INFORMATION14
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_VAL(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION14'
, RLE.RULE_INFORMATION14)
, 1
, 240) RULE_INFORMATION14_VAL
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_DSC(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION14'
, RLE.RULE_INFORMATION14)
, 1
, 240) RULE_INFORMATION14_DSC
, RLE.RULE_INFORMATION15
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_VAL(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION15'
, RLE.RULE_INFORMATION15)
, 1
, 240) RULE_INFORMATION15_VAL
, SUBSTRB(OKC_RULE_PUB.GET_FLEX_DSC(RLE.RULE_INFORMATION_CATEGORY
, 'RULE_INFORMATION15'
, RLE.RULE_INFORMATION15)
, 1
, 240) RULE_INFORMATION15_DSC
, RLE.CREATED_BY
, RLE.CREATION_DATE
, RLE.LAST_UPDATED_BY
, RLE.LAST_UPDATE_DATE
, RLE.LAST_UPDATE_LOGIN
, RLE.TEMPLATE_YN TEMPLATE_YN
, RLE.ANS_SET_JTOT_OBJECT_CODE ANS_SET_JTOT_OBJECT_CODE
, RLE.ANS_SET_JTOT_OBJECT_ID1 ANS_SET_JTOT_OBJECT_ID1
, RLE.ANS_SET_JTOT_OBJECT_ID2 ANS_SET_JTOT_OBJECT_ID2
, RLE.DISPLAY_SEQUENCE DISPLAY_SEQUENCE
FROM OKC_RULES_V RLE