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.

[Home] [Help]

VIEW: APPS.OKC_RULES_B_DFV

Source

View Text - Preformatted


SELECT ROWID, RULE_INFORMATION_CATEGORY, (DECODE (RULE_INFORMATION_CATEGORY, 'AVE', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'AVE', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION2), NULL)), RULE_INFORMATION3, (DECODE (RULE_INFORMATION_CATEGORY, 'STO', JTOT_OBJECT2_CODE, 'CAN', JTOT_OBJECT1_CODE, 'BTO', JTOT_OBJECT2_CODE, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'STO', JTOT_OBJECT1_CODE, 'BTO', JTOT_OBJECT1_CODE, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'CC_REFUND', TO_DATE(RULE_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), 'CC_FORFAITURE', TO_DATE(RULE_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), 'CC_FISCAL_FUNDING', TO_DATE(RULE_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), 'CC_CANCELLATION', TO_DATE(RULE_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), 'CC_ACCEPTANCE', TO_DATE(RULE_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'CC_REFUND', RULE_INFORMATION2, 'CC_FORFAITURE', RULE_INFORMATION2, 'CC_FISCAL_FUNDING', RULE_INFORMATION2, 'CC_CANCELLATION', RULE_INFORMATION2, 'CC_ACCEPTANCE', RULE_INFORMATION2, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'CC_REFUND', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), 'CC_FORFAITURE', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), 'CC_FISCAL_FUNDING', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), 'CC_CANCELLATION', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), 'CC_ACCEPTANCE', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'CC_REFUND', RULE_INFORMATION4, 'CC_FORFAITURE', RULE_INFORMATION4, 'CC_FISCAL_FUNDING', RULE_INFORMATION4, 'CC_CANCELLATION', RULE_INFORMATION4, 'CC_ACCEPTANCE', RULE_INFORMATION4, NULL)), JTOT_OBJECT1_CODE, (DECODE (RULE_INFORMATION_CATEGORY, 'CVN', TO_DATE(RULE_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'CVN', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'CVN', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), NULL)), JTOT_OBJECT1_CODE, RULE_INFORMATION1, RULE_INFORMATION1, RULE_INFORMATION1, RULE_INFORMATION1, JTOT_OBJECT1_CODE, RULE_INFORMATION1, JTOT_OBJECT1_CODE, RULE_INFORMATION1, RULE_INFORMATION2, (DECODE (RULE_INFORMATION_CATEGORY, 'NTN', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), NULL)), RULE_INFORMATION4, (DECODE (RULE_INFORMATION_CATEGORY, 'NTN', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION5), NULL)), RULE_INFORMATION6, RULE_INFORMATION7, JTOT_OBJECT1_CODE, JTOT_OBJECT1_CODE, JTOT_OBJECT1_CODE, RULE_INFORMATION1, RULE_INFORMATION2, (DECODE (RULE_INFORMATION_CATEGORY, 'REN', TO_DATE(RULE_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), RULE_INFORMATION1, RULE_INFORMATION1,  
 (DECODE (RULE_INFORMATION_CATEGORY,  
      'AVE', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3,  
      'BTO', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT2_CODE || '.' || JTOT_OBJECT1_CODE,  
      'CAN', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE,  
      'CC_ACCEPTANCE', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4,  
      'CC_CANCELLATION', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4,  
      'CC_FISCAL_FUNDING', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4,  
      'CC_FORFAITURE', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4,  
      'CC_REFUND', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4,  
      'CVN', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION3,  
      'DST', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE,  
      'EXC', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,  
      'EXL_OPN', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,  
      'FOB', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,  
      'FRT', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,  
      'IRE', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE,  
      'LRT', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,  
      'MDR', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE,  
      'NTN', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6 || '.' || RULE_INFORMATION7,  
      'PRE', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE,  
      'PTO', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE,  
      'PTR', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE,  
      'REN', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3,  
      'SMD', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,  
      'STO', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT2_CODE || '.' || JTOT_OBJECT1_CODE,  
      'TER', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1, NULL)) 
 FROM OKC_RULES_B

View Text - HTML Formatted

SELECT ROWID
, RULE_INFORMATION_CATEGORY
, (DECODE (RULE_INFORMATION_CATEGORY
, 'AVE'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'AVE'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION2)
, NULL))
, RULE_INFORMATION3
, (DECODE (RULE_INFORMATION_CATEGORY
, 'STO'
, JTOT_OBJECT2_CODE
, 'CAN'
, JTOT_OBJECT1_CODE
, 'BTO'
, JTOT_OBJECT2_CODE
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'STO'
, JTOT_OBJECT1_CODE
, 'BTO'
, JTOT_OBJECT1_CODE
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'CC_REFUND'
, TO_DATE(RULE_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, 'CC_FORFAITURE'
, TO_DATE(RULE_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, 'CC_FISCAL_FUNDING'
, TO_DATE(RULE_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, 'CC_CANCELLATION'
, TO_DATE(RULE_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, 'CC_ACCEPTANCE'
, TO_DATE(RULE_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'CC_REFUND'
, RULE_INFORMATION2
, 'CC_FORFAITURE'
, RULE_INFORMATION2
, 'CC_FISCAL_FUNDING'
, RULE_INFORMATION2
, 'CC_CANCELLATION'
, RULE_INFORMATION2
, 'CC_ACCEPTANCE'
, RULE_INFORMATION2
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'CC_REFUND'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, 'CC_FORFAITURE'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, 'CC_FISCAL_FUNDING'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, 'CC_CANCELLATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, 'CC_ACCEPTANCE'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'CC_REFUND'
, RULE_INFORMATION4
, 'CC_FORFAITURE'
, RULE_INFORMATION4
, 'CC_FISCAL_FUNDING'
, RULE_INFORMATION4
, 'CC_CANCELLATION'
, RULE_INFORMATION4
, 'CC_ACCEPTANCE'
, RULE_INFORMATION4
, NULL))
, JTOT_OBJECT1_CODE
, (DECODE (RULE_INFORMATION_CATEGORY
, 'CVN'
, TO_DATE(RULE_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'CVN'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'CVN'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, NULL))
, JTOT_OBJECT1_CODE
, RULE_INFORMATION1
, RULE_INFORMATION1
, RULE_INFORMATION1
, RULE_INFORMATION1
, JTOT_OBJECT1_CODE
, RULE_INFORMATION1
, JTOT_OBJECT1_CODE
, RULE_INFORMATION1
, RULE_INFORMATION2
, (DECODE (RULE_INFORMATION_CATEGORY
, 'NTN'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, NULL))
, RULE_INFORMATION4
, (DECODE (RULE_INFORMATION_CATEGORY
, 'NTN'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION5)
, NULL))
, RULE_INFORMATION6
, RULE_INFORMATION7
, JTOT_OBJECT1_CODE
, JTOT_OBJECT1_CODE
, JTOT_OBJECT1_CODE
, RULE_INFORMATION1
, RULE_INFORMATION2
, (DECODE (RULE_INFORMATION_CATEGORY
, 'REN'
, TO_DATE(RULE_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, RULE_INFORMATION1
, RULE_INFORMATION1
, (DECODE (RULE_INFORMATION_CATEGORY
, 'AVE'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3
, 'BTO'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT2_CODE || '.' || JTOT_OBJECT1_CODE
, 'CAN'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE
, 'CC_ACCEPTANCE'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4
, 'CC_CANCELLATION'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4
, 'CC_FISCAL_FUNDING'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4
, 'CC_FORFAITURE'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4
, 'CC_REFUND'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4
, 'CVN'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION3
, 'DST'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE
, 'EXC'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
, 'EXL_OPN'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
, 'FOB'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
, 'FRT'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
, 'IRE'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE
, 'LRT'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
, 'MDR'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE
, 'NTN'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6 || '.' || RULE_INFORMATION7
, 'PRE'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE
, 'PTO'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE
, 'PTR'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE
, 'REN'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3
, 'SMD'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
, 'STO'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT2_CODE || '.' || JTOT_OBJECT1_CODE
, 'TER'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
, NULL))
FROM OKC_RULES_B