Product: | OKC - Contracts Core |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKC_RULES1_BLK_V |
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