eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKS_RULES_DFF_DFV

Source

View Text - Preformatted


SELECT ROWID, RULE_INFORMATION_CATEGORY, JTOT_OBJECT1_CODE, RULE_INFORMATION1, RULE_INFORMATION2, RULE_INFORMATION1, RULE_INFORMATION1, (DECODE (RULE_INFORMATION_CATEGORY, 'CCR', TO_DATE(RULE_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'CCR', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), NULL)), RULE_INFORMATION4, RULE_INFORMATION1, RULE_INFORMATION1, (DECODE (RULE_INFORMATION_CATEGORY, 'RRU', RULE_INFORMATION9, 'ERN', RULE_INFORMATION1, NULL)), RULE_INFORMATION2, (DECODE (RULE_INFORMATION_CATEGORY, 'RRU', RULE_INFORMATION10, 'ERN', RULE_INFORMATION3, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'GPR', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1), NULL)), RULE_INFORMATION2, RULE_INFORMATION1, (DECODE (RULE_INFORMATION_CATEGORY, 'IBR', TO_DATE(RULE_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), RULE_INFORMATION3, RULE_INFORMATION1, RULE_INFORMATION2, RULE_INFORMATION3, (DECODE (RULE_INFORMATION_CATEGORY, 'IRT', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION4), NULL)), RULE_INFORMATION5, (DECODE (RULE_INFORMATION_CATEGORY, 'IRT', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION6), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'QRE', RULE_INFORMATION11, 'LMT', RULE_INFORMATION1, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'LMT', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION2), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'LMT', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'LMT', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION4), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'LMT', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION5), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'LMT', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION6), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'LMT', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION7), NULL)), RULE_INFORMATION1, JTOT_OBJECT1_CODE, JTOT_OBJECT2_CODE, (DECODE (RULE_INFORMATION_CATEGORY, 'PDL', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'PDL', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION2), NULL)), RULE_INFORMATION7, (DECODE (RULE_INFORMATION_CATEGORY, 'PDL', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'PDL', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION4), NULL)), RULE_INFORMATION5, (DECODE (RULE_INFORMATION_CATEGORY, 'PDL', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION6), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'PDL', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION8), NULL)), RULE_INFORMATION9, (DECODE (RULE_INFORMATION_CATEGORY, 'PDL', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION10), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'PDL', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION11), NULL)), RULE_INFORMATION12, (DECODE (RULE_INFORMATION_CATEGORY, 'PDL', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION13), NULL)), JTOT_OBJECT1_CODE, JTOT_OBJECT2_CODE, RULE_INFORMATION1, (DECODE (RULE_INFORMATION_CATEGORY, 'PMP', RULE_INFORMATION1, 'PMA', RULE_INFORMATION2, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'PMP', RULE_INFORMATION2, 'PMA', RULE_INFORMATION3, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'PMP', JTOT_OBJECT1_CODE, 'PMA', JTOT_OBJECT3_CODE, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'PML', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'PML', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION2), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'PML', TO_DATE(RULE_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'PML', TO_DATE(RULE_INFORMATION4, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'PML', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION5), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'RSL', RULE_INFORMATION1, 'PML', RULE_INFORMATION6, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'PML', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION7), NULL)), RULE_INFORMATION8, RULE_INFORMATION9, JTOT_OBJECT1_CODE, JTOT_OBJECT2_CODE, (DECODE (RULE_INFORMATION_CATEGORY, 'QRE', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1), NULL)), RULE_INFORMATION2, (DECODE (RULE_INFORMATION_CATEGORY, 'QRE', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'QRE', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION4), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'QRE', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION5), NULL)), RULE_INFORMATION6, (DECODE (RULE_INFORMATION_CATEGORY, 'QRE', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION7), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'QRE', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION8), NULL)), RULE_INFORMATION9, RULE_INFORMATION10, (DECODE (RULE_INFORMATION_CATEGORY, 'QRE', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION12), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'QRE', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION13), NULL)), JTOT_OBJECT1_CODE, JTOT_OBJECT2_CODE, RULE_INFORMATION1, RULE_INFORMATION2, RULE_INFORMATION3, RULE_INFORMATION1, RULE_INFORMATION2, RULE_INFORMATION3, RULE_INFORMATION4, JTOT_OBJECT1_CODE, (DECODE (RULE_INFORMATION_CATEGORY, 'RER', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'RER', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION2), NULL)), RULE_INFORMATION3, (DECODE (RULE_INFORMATION_CATEGORY, 'RRU', RULE_INFORMATION3, 'RPO', RULE_INFORMATION1, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'RRU', RULE_INFORMATION4, 'RPT', RULE_INFORMATION1, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'RRU', JTOT_OBJECT1_CODE, 'RPT', JTOT_OBJECT1_CODE, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'RRU', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION5), 'RPT', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION2), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'RRE', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1), 'RPT', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'RRE', RULE_INFORMATION2, 'RPT', RULE_INFORMATION4, NULL)), RULE_INFORMATION1, RULE_INFORMATION2, (DECODE (RULE_INFORMATION_CATEGORY, 'RRU', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION6), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'RRU', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION7), NULL)), RULE_INFORMATION8, (DECODE (RULE_INFORMATION_CATEGORY, 'RRU', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION11), NULL)), RULE_INFORMATION12, (DECODE (RULE_INFORMATION_CATEGORY, 'RRU', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION13), NULL)), RULE_INFORMATION14, (DECODE (RULE_INFORMATION_CATEGORY, 'RSL', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION2), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'RSL', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), NULL)), RULE_INFORMATION4, JTOT_OBJECT1_CODE, RULE_INFORMATION1, RULE_INFORMATION2, RULE_INFORMATION3, RULE_INFORMATION4, JTOT_OBJECT1_CODE, (DECODE (RULE_INFORMATION_CATEGORY, 'RVE', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'RVE', TO_DATE(RULE_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'SBG', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1), NULL)), RULE_INFORMATION2, (DECODE (RULE_INFORMATION_CATEGORY, 'SBG', TO_DATE(RULE_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'SBG', TO_DATE(RULE_INFORMATION4, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'SBG', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION5), NULL)), RULE_INFORMATION6, (DECODE (RULE_INFORMATION_CATEGORY, 'SBG', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION7), NULL)), RULE_INFORMATION8, RULE_INFORMATION9, RULE_INFORMATION10, RULE_INFORMATION11, JTOT_OBJECT1_CODE, RULE_INFORMATION12, RULE_INFORMATION13, JTOT_OBJECT1_CODE, JTOT_OBJECT2_CODE, RULE_INFORMATION1, JTOT_OBJECT1_CODE, JTOT_OBJECT2_CODE, RULE_INFORMATION1, (DECODE (RULE_INFORMATION_CATEGORY, 'SLL', TO_DATE(RULE_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), RULE_INFORMATION3, RULE_INFORMATION4, RULE_INFORMATION5, RULE_INFORMATION6, RULE_INFORMATION7, RULE_INFORMATION8, RULE_INFORMATION9, RULE_INFORMATION10, RULE_INFORMATION11, RULE_INFORMATION12, RULE_INFORMATION1, RULE_INFORMATION2, RULE_INFORMATION1, RULE_INFORMATION2, RULE_INFORMATION3, JTOT_OBJECT1_CODE, JTOT_OBJECT2_CODE, RULE_INFORMATION1, (DECODE (RULE_INFORMATION_CATEGORY, 'USV', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'USV', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION2), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'USV', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), NULL)), RULE_INFORMATION1,  
 (DECODE (RULE_INFORMATION_CATEGORY,  
      'ARL', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE,  
      'BPF', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2,  
      'BTD', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,  
      'CCR', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4,  
      'CVE', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,  
      'CVR', RULE_INFORMATION_CATEGORY,  
      'ECE', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,  
      'ERN', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3,  
      'GPR', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2,  
      'IBR', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3,  
      'IRT', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6,  
      'LMT', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6 || '.' || RULE_INFORMATION7,  
      'OFS', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,  
      'PDL', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE || '.' || JTOT_OBJECT2_CODE || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION7 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6 || '.' || RULE_INFORMATION8 || '.' || RULE_INFORMATION9 || '.' || RULE_INFORMATION10 || '.' || RULE_INFORMATION11 || '.' || RULE_INFORMATION12 || '.' || RULE_INFORMATION13,  
      'PMA', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE || '.' || JTOT_OBJECT2_CODE || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || JTOT_OBJECT3_CODE,  
      'PML', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6 || '.' || RULE_INFORMATION7 || '.' || RULE_INFORMATION8 || '.' || RULE_INFORMATION9 || '.' || JTOT_OBJECT1_CODE || '.' || JTOT_OBJECT2_CODE,  
      'PMP', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2,  
      'QRE', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6 || '.' || RULE_INFORMATION7 || '.' || RULE_INFORMATION8 || '.' || RULE_INFORMATION9 || '.' || RULE_INFORMATION10 || '.' || RULE_INFORMATION11 || '.' || RULE_INFORMATION12 || '.' || RULE_INFORMATION13,  
      'QTO', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE || '.' || JTOT_OBJECT2_CODE || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3,  
      'RCN', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || JTOT_OBJECT1_CODE,  
      'RER', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3,  
      'RPO', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,  
      'RPT', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || JTOT_OBJECT1_CODE || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4,  
      'RRE', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2,  
      'RRU', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || JTOT_OBJECT1_CODE || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6 || '.' || RULE_INFORMATION7 || '.' || RULE_INFORMATION8 || '.' || RULE_INFORMATION9 || '.' || RULE_INFORMATION10 || '.' || RULE_INFORMATION11 || '.' || RULE_INFORMATION12 || '.' || RULE_INFORMATION13 || '.' || RULE_INFORMATION14,  
      'RSL', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || JTOT_OBJECT1_CODE,  
      'RSN', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || JTOT_OBJECT1_CODE,  
      'RVE', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2,  
      'SBG', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6 || '.' || RULE_INFORMATION7 || '.' || RULE_INFORMATION8 || '.' || RULE_INFORMATION9 || '.' || RULE_INFORMATION10 || '.' || RULE_INFORMATION11 || '.' || JTOT_OBJECT1_CODE || '.' || RULE_INFORMATION12 || '.' || RULE_INFORMATION13,  
      'SLH', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE || '.' || JTOT_OBJECT2_CODE || '.' || RULE_INFORMATION1,  
      'SLL', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE || '.' || JTOT_OBJECT2_CODE || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6 || '.' || RULE_INFORMATION7 || '.' || RULE_INFORMATION8 || '.' || RULE_INFORMATION9 || '.' || RULE_INFORMATION10 || '.' || RULE_INFORMATION11 || '.' || RULE_INFORMATION12,  
      'SPO', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2,  
      'STR', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,  
      'TAX', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || JTOT_OBJECT1_CODE || '.' || JTOT_OBJECT2_CODE,  
      'UGE', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,  
      'USV', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3,  
      'WHE', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1, NULL)) 
 FROM OKS_RULES_DFF

View Text - HTML Formatted

SELECT ROWID
, RULE_INFORMATION_CATEGORY
, JTOT_OBJECT1_CODE
, RULE_INFORMATION1
, RULE_INFORMATION2
, RULE_INFORMATION1
, RULE_INFORMATION1
, (DECODE (RULE_INFORMATION_CATEGORY
, 'CCR'
, TO_DATE(RULE_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'CCR'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, NULL))
, RULE_INFORMATION4
, RULE_INFORMATION1
, RULE_INFORMATION1
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RRU'
, RULE_INFORMATION9
, 'ERN'
, RULE_INFORMATION1
, NULL))
, RULE_INFORMATION2
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RRU'
, RULE_INFORMATION10
, 'ERN'
, RULE_INFORMATION3
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'GPR'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1)
, NULL))
, RULE_INFORMATION2
, RULE_INFORMATION1
, (DECODE (RULE_INFORMATION_CATEGORY
, 'IBR'
, TO_DATE(RULE_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, RULE_INFORMATION3
, RULE_INFORMATION1
, RULE_INFORMATION2
, RULE_INFORMATION3
, (DECODE (RULE_INFORMATION_CATEGORY
, 'IRT'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION4)
, NULL))
, RULE_INFORMATION5
, (DECODE (RULE_INFORMATION_CATEGORY
, 'IRT'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION6)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'QRE'
, RULE_INFORMATION11
, 'LMT'
, RULE_INFORMATION1
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'LMT'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION2)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'LMT'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'LMT'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION4)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'LMT'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION5)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'LMT'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION6)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'LMT'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION7)
, NULL))
, RULE_INFORMATION1
, JTOT_OBJECT1_CODE
, JTOT_OBJECT2_CODE
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PDL'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PDL'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION2)
, NULL))
, RULE_INFORMATION7
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PDL'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PDL'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION4)
, NULL))
, RULE_INFORMATION5
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PDL'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION6)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PDL'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION8)
, NULL))
, RULE_INFORMATION9
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PDL'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION10)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PDL'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION11)
, NULL))
, RULE_INFORMATION12
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PDL'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION13)
, NULL))
, JTOT_OBJECT1_CODE
, JTOT_OBJECT2_CODE
, RULE_INFORMATION1
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PMP'
, RULE_INFORMATION1
, 'PMA'
, RULE_INFORMATION2
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PMP'
, RULE_INFORMATION2
, 'PMA'
, RULE_INFORMATION3
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PMP'
, JTOT_OBJECT1_CODE
, 'PMA'
, JTOT_OBJECT3_CODE
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PML'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PML'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION2)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PML'
, TO_DATE(RULE_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PML'
, TO_DATE(RULE_INFORMATION4
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PML'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION5)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RSL'
, RULE_INFORMATION1
, 'PML'
, RULE_INFORMATION6
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PML'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION7)
, NULL))
, RULE_INFORMATION8
, RULE_INFORMATION9
, JTOT_OBJECT1_CODE
, JTOT_OBJECT2_CODE
, (DECODE (RULE_INFORMATION_CATEGORY
, 'QRE'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1)
, NULL))
, RULE_INFORMATION2
, (DECODE (RULE_INFORMATION_CATEGORY
, 'QRE'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'QRE'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION4)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'QRE'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION5)
, NULL))
, RULE_INFORMATION6
, (DECODE (RULE_INFORMATION_CATEGORY
, 'QRE'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION7)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'QRE'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION8)
, NULL))
, RULE_INFORMATION9
, RULE_INFORMATION10
, (DECODE (RULE_INFORMATION_CATEGORY
, 'QRE'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION12)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'QRE'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION13)
, NULL))
, JTOT_OBJECT1_CODE
, JTOT_OBJECT2_CODE
, RULE_INFORMATION1
, RULE_INFORMATION2
, RULE_INFORMATION3
, RULE_INFORMATION1
, RULE_INFORMATION2
, RULE_INFORMATION3
, RULE_INFORMATION4
, JTOT_OBJECT1_CODE
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RER'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RER'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION2)
, NULL))
, RULE_INFORMATION3
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RRU'
, RULE_INFORMATION3
, 'RPO'
, RULE_INFORMATION1
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RRU'
, RULE_INFORMATION4
, 'RPT'
, RULE_INFORMATION1
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RRU'
, JTOT_OBJECT1_CODE
, 'RPT'
, JTOT_OBJECT1_CODE
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RRU'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION5)
, 'RPT'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION2)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RRE'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1)
, 'RPT'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RRE'
, RULE_INFORMATION2
, 'RPT'
, RULE_INFORMATION4
, NULL))
, RULE_INFORMATION1
, RULE_INFORMATION2
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RRU'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION6)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RRU'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION7)
, NULL))
, RULE_INFORMATION8
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RRU'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION11)
, NULL))
, RULE_INFORMATION12
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RRU'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION13)
, NULL))
, RULE_INFORMATION14
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RSL'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION2)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RSL'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, NULL))
, RULE_INFORMATION4
, JTOT_OBJECT1_CODE
, RULE_INFORMATION1
, RULE_INFORMATION2
, RULE_INFORMATION3
, RULE_INFORMATION4
, JTOT_OBJECT1_CODE
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RVE'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'RVE'
, TO_DATE(RULE_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'SBG'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1)
, NULL))
, RULE_INFORMATION2
, (DECODE (RULE_INFORMATION_CATEGORY
, 'SBG'
, TO_DATE(RULE_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'SBG'
, TO_DATE(RULE_INFORMATION4
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'SBG'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION5)
, NULL))
, RULE_INFORMATION6
, (DECODE (RULE_INFORMATION_CATEGORY
, 'SBG'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION7)
, NULL))
, RULE_INFORMATION8
, RULE_INFORMATION9
, RULE_INFORMATION10
, RULE_INFORMATION11
, JTOT_OBJECT1_CODE
, RULE_INFORMATION12
, RULE_INFORMATION13
, JTOT_OBJECT1_CODE
, JTOT_OBJECT2_CODE
, RULE_INFORMATION1
, JTOT_OBJECT1_CODE
, JTOT_OBJECT2_CODE
, RULE_INFORMATION1
, (DECODE (RULE_INFORMATION_CATEGORY
, 'SLL'
, TO_DATE(RULE_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, RULE_INFORMATION3
, RULE_INFORMATION4
, RULE_INFORMATION5
, RULE_INFORMATION6
, RULE_INFORMATION7
, RULE_INFORMATION8
, RULE_INFORMATION9
, RULE_INFORMATION10
, RULE_INFORMATION11
, RULE_INFORMATION12
, RULE_INFORMATION1
, RULE_INFORMATION2
, RULE_INFORMATION1
, RULE_INFORMATION2
, RULE_INFORMATION3
, JTOT_OBJECT1_CODE
, JTOT_OBJECT2_CODE
, RULE_INFORMATION1
, (DECODE (RULE_INFORMATION_CATEGORY
, 'USV'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'USV'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION2)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'USV'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, NULL))
, RULE_INFORMATION1
, (DECODE (RULE_INFORMATION_CATEGORY
, 'ARL'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE
, 'BPF'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2
, 'BTD'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
, 'CCR'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4
, 'CVE'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
, 'CVR'
, RULE_INFORMATION_CATEGORY
, 'ECE'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
, 'ERN'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3
, 'GPR'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2
, 'IBR'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3
, 'IRT'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6
, 'LMT'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6 || '.' || RULE_INFORMATION7
, 'OFS'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
, 'PDL'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE || '.' || JTOT_OBJECT2_CODE || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION7 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6 || '.' || RULE_INFORMATION8 || '.' || RULE_INFORMATION9 || '.' || RULE_INFORMATION10 || '.' || RULE_INFORMATION11 || '.' || RULE_INFORMATION12 || '.' || RULE_INFORMATION13
, 'PMA'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE || '.' || JTOT_OBJECT2_CODE || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || JTOT_OBJECT3_CODE
, 'PML'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6 || '.' || RULE_INFORMATION7 || '.' || RULE_INFORMATION8 || '.' || RULE_INFORMATION9 || '.' || JTOT_OBJECT1_CODE || '.' || JTOT_OBJECT2_CODE
, 'PMP'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2
, 'QRE'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6 || '.' || RULE_INFORMATION7 || '.' || RULE_INFORMATION8 || '.' || RULE_INFORMATION9 || '.' || RULE_INFORMATION10 || '.' || RULE_INFORMATION11 || '.' || RULE_INFORMATION12 || '.' || RULE_INFORMATION13
, 'QTO'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE || '.' || JTOT_OBJECT2_CODE || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3
, 'RCN'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || JTOT_OBJECT1_CODE
, 'RER'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3
, 'RPO'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
, 'RPT'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || JTOT_OBJECT1_CODE || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4
, 'RRE'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2
, 'RRU'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || JTOT_OBJECT1_CODE || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6 || '.' || RULE_INFORMATION7 || '.' || RULE_INFORMATION8 || '.' || RULE_INFORMATION9 || '.' || RULE_INFORMATION10 || '.' || RULE_INFORMATION11 || '.' || RULE_INFORMATION12 || '.' || RULE_INFORMATION13 || '.' || RULE_INFORMATION14
, 'RSL'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || JTOT_OBJECT1_CODE
, 'RSN'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || JTOT_OBJECT1_CODE
, 'RVE'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2
, 'SBG'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6 || '.' || RULE_INFORMATION7 || '.' || RULE_INFORMATION8 || '.' || RULE_INFORMATION9 || '.' || RULE_INFORMATION10 || '.' || RULE_INFORMATION11 || '.' || JTOT_OBJECT1_CODE || '.' || RULE_INFORMATION12 || '.' || RULE_INFORMATION13
, 'SLH'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE || '.' || JTOT_OBJECT2_CODE || '.' || RULE_INFORMATION1
, 'SLL'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE || '.' || JTOT_OBJECT2_CODE || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6 || '.' || RULE_INFORMATION7 || '.' || RULE_INFORMATION8 || '.' || RULE_INFORMATION9 || '.' || RULE_INFORMATION10 || '.' || RULE_INFORMATION11 || '.' || RULE_INFORMATION12
, 'SPO'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2
, 'STR'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
, 'TAX'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || JTOT_OBJECT1_CODE || '.' || JTOT_OBJECT2_CODE
, 'UGE'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
, 'USV'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3
, 'WHE'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
, NULL))
FROM OKS_RULES_DFF