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.AMS_CAMPAIGN_SCHEDULES_B1_DFV

Source

View Text - Preformatted


SELECT ROWID, ACTIVITY_ID, (DECODE (ACTIVITY_ID, '50', ACTIVITY_ATTRIBUTE5, '150', ACTIVITY_ATTRIBUTE1, '140', ACTIVITY_ATTRIBUTE3, '130', ACTIVITY_ATTRIBUTE1, NULL)), ACTIVITY_ATTRIBUTE2, ACTIVITY_ATTRIBUTE1, ACTIVITY_ATTRIBUTE2, ACTIVITY_ATTRIBUTE2, ACTIVITY_ATTRIBUTE1, (DECODE (ACTIVITY_ID, '60', ACTIVITY_ATTRIBUTE2, '50', ACTIVITY_ATTRIBUTE2, '470', ACTIVITY_ATTRIBUTE2, '290', ACTIVITY_ATTRIBUTE2, '170', ACTIVITY_ATTRIBUTE2, NULL)), (DECODE (ACTIVITY_ID, '60', ACTIVITY_ATTRIBUTE3, '50', ACTIVITY_ATTRIBUTE3, '470', ACTIVITY_ATTRIBUTE3, '290', ACTIVITY_ATTRIBUTE3, '170', ACTIVITY_ATTRIBUTE3, NULL)), (DECODE (ACTIVITY_ID, '60', ACTIVITY_ATTRIBUTE4, '50', ACTIVITY_ATTRIBUTE4, '470', ACTIVITY_ATTRIBUTE4, '290', ACTIVITY_ATTRIBUTE4, '170', ACTIVITY_ATTRIBUTE4, NULL)), (DECODE (ACTIVITY_ID, '60', ACTIVITY_ATTRIBUTE5, '290', ACTIVITY_ATTRIBUTE5, '170', ACTIVITY_ATTRIBUTE5, NULL)), (DECODE (ACTIVITY_ID, '410', ACTIVITY_ATTRIBUTE1, '400', ACTIVITY_ATTRIBUTE1, '40', ACTIVITY_ATTRIBUTE1, '390', ACTIVITY_ATTRIBUTE1, '370', ACTIVITY_ATTRIBUTE1, '210', ACTIVITY_ATTRIBUTE1, '190', ACTIVITY_ATTRIBUTE1, '180', ACTIVITY_ATTRIBUTE1, NULL)), (DECODE (ACTIVITY_ID, '410', ACTIVITY_ATTRIBUTE2, '400', ACTIVITY_ATTRIBUTE2, '40', ACTIVITY_ATTRIBUTE2, '390', ACTIVITY_ATTRIBUTE2, '370', ACTIVITY_ATTRIBUTE2, '210', ACTIVITY_ATTRIBUTE2, '190', ACTIVITY_ATTRIBUTE2, '180', ACTIVITY_ATTRIBUTE2, NULL)), (DECODE (ACTIVITY_ID, '410', ACTIVITY_ATTRIBUTE3, '400', ACTIVITY_ATTRIBUTE3, '40', ACTIVITY_ATTRIBUTE3, '390', ACTIVITY_ATTRIBUTE3, '370', ACTIVITY_ATTRIBUTE3, '210', ACTIVITY_ATTRIBUTE3, '190', ACTIVITY_ATTRIBUTE3, '180', ACTIVITY_ATTRIBUTE3, NULL)), ACTIVITY_ATTRIBUTE1, ACTIVITY_ATTRIBUTE1, (DECODE (ACTIVITY_ID, '50', ACTIVITY_ATTRIBUTE1, '470', ACTIVITY_ATTRIBUTE1, NULL)), ACTIVITY_ATTRIBUTE1, (DECODE (ACTIVITY_ID, '80', ACTIVITY_ATTRIBUTE1, '70', ACTIVITY_ATTRIBUTE1, NULL)), (DECODE (ACTIVITY_ID, '80', ACTIVITY_ATTRIBUTE2, '70', ACTIVITY_ATTRIBUTE2, NULL)), (DECODE (ACTIVITY_ID, '80', ACTIVITY_ATTRIBUTE3, '70', ACTIVITY_ATTRIBUTE3, NULL)), (DECODE (ACTIVITY_ID, '80', ACTIVITY_ATTRIBUTE4, '70', ACTIVITY_ATTRIBUTE4, NULL)),  
 (DECODE (ACTIVITY_ID,  
      '130', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2,  
      '140', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3,  
      '150', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2,  
      '170', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3 || '.' || ACTIVITY_ATTRIBUTE4 || '.' || ACTIVITY_ATTRIBUTE5,  
      '180', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3,  
      '190', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3,  
      '210', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3,  
      '260', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1,  
      '290', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3 || '.' || ACTIVITY_ATTRIBUTE4 || '.' || ACTIVITY_ATTRIBUTE5,  
      '370', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3,  
      '390', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3,  
      '40', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3,  
      '400', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3,  
      '410', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3,  
      '470', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3 || '.' || ACTIVITY_ATTRIBUTE4,  
      '50', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3 || '.' || ACTIVITY_ATTRIBUTE4 || '.' || ACTIVITY_ATTRIBUTE5,  
      '60', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3 || '.' || ACTIVITY_ATTRIBUTE4 || '.' || ACTIVITY_ATTRIBUTE5,  
      '70', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3 || '.' || ACTIVITY_ATTRIBUTE4,  
      '80', ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3 || '.' || ACTIVITY_ATTRIBUTE4, NULL)) 
 FROM AMS_CAMPAIGN_SCHEDULES_B

View Text - HTML Formatted

SELECT ROWID
, ACTIVITY_ID
, (DECODE (ACTIVITY_ID
, '50'
, ACTIVITY_ATTRIBUTE5
, '150'
, ACTIVITY_ATTRIBUTE1
, '140'
, ACTIVITY_ATTRIBUTE3
, '130'
, ACTIVITY_ATTRIBUTE1
, NULL))
, ACTIVITY_ATTRIBUTE2
, ACTIVITY_ATTRIBUTE1
, ACTIVITY_ATTRIBUTE2
, ACTIVITY_ATTRIBUTE2
, ACTIVITY_ATTRIBUTE1
, (DECODE (ACTIVITY_ID
, '60'
, ACTIVITY_ATTRIBUTE2
, '50'
, ACTIVITY_ATTRIBUTE2
, '470'
, ACTIVITY_ATTRIBUTE2
, '290'
, ACTIVITY_ATTRIBUTE2
, '170'
, ACTIVITY_ATTRIBUTE2
, NULL))
, (DECODE (ACTIVITY_ID
, '60'
, ACTIVITY_ATTRIBUTE3
, '50'
, ACTIVITY_ATTRIBUTE3
, '470'
, ACTIVITY_ATTRIBUTE3
, '290'
, ACTIVITY_ATTRIBUTE3
, '170'
, ACTIVITY_ATTRIBUTE3
, NULL))
, (DECODE (ACTIVITY_ID
, '60'
, ACTIVITY_ATTRIBUTE4
, '50'
, ACTIVITY_ATTRIBUTE4
, '470'
, ACTIVITY_ATTRIBUTE4
, '290'
, ACTIVITY_ATTRIBUTE4
, '170'
, ACTIVITY_ATTRIBUTE4
, NULL))
, (DECODE (ACTIVITY_ID
, '60'
, ACTIVITY_ATTRIBUTE5
, '290'
, ACTIVITY_ATTRIBUTE5
, '170'
, ACTIVITY_ATTRIBUTE5
, NULL))
, (DECODE (ACTIVITY_ID
, '410'
, ACTIVITY_ATTRIBUTE1
, '400'
, ACTIVITY_ATTRIBUTE1
, '40'
, ACTIVITY_ATTRIBUTE1
, '390'
, ACTIVITY_ATTRIBUTE1
, '370'
, ACTIVITY_ATTRIBUTE1
, '210'
, ACTIVITY_ATTRIBUTE1
, '190'
, ACTIVITY_ATTRIBUTE1
, '180'
, ACTIVITY_ATTRIBUTE1
, NULL))
, (DECODE (ACTIVITY_ID
, '410'
, ACTIVITY_ATTRIBUTE2
, '400'
, ACTIVITY_ATTRIBUTE2
, '40'
, ACTIVITY_ATTRIBUTE2
, '390'
, ACTIVITY_ATTRIBUTE2
, '370'
, ACTIVITY_ATTRIBUTE2
, '210'
, ACTIVITY_ATTRIBUTE2
, '190'
, ACTIVITY_ATTRIBUTE2
, '180'
, ACTIVITY_ATTRIBUTE2
, NULL))
, (DECODE (ACTIVITY_ID
, '410'
, ACTIVITY_ATTRIBUTE3
, '400'
, ACTIVITY_ATTRIBUTE3
, '40'
, ACTIVITY_ATTRIBUTE3
, '390'
, ACTIVITY_ATTRIBUTE3
, '370'
, ACTIVITY_ATTRIBUTE3
, '210'
, ACTIVITY_ATTRIBUTE3
, '190'
, ACTIVITY_ATTRIBUTE3
, '180'
, ACTIVITY_ATTRIBUTE3
, NULL))
, ACTIVITY_ATTRIBUTE1
, ACTIVITY_ATTRIBUTE1
, (DECODE (ACTIVITY_ID
, '50'
, ACTIVITY_ATTRIBUTE1
, '470'
, ACTIVITY_ATTRIBUTE1
, NULL))
, ACTIVITY_ATTRIBUTE1
, (DECODE (ACTIVITY_ID
, '80'
, ACTIVITY_ATTRIBUTE1
, '70'
, ACTIVITY_ATTRIBUTE1
, NULL))
, (DECODE (ACTIVITY_ID
, '80'
, ACTIVITY_ATTRIBUTE2
, '70'
, ACTIVITY_ATTRIBUTE2
, NULL))
, (DECODE (ACTIVITY_ID
, '80'
, ACTIVITY_ATTRIBUTE3
, '70'
, ACTIVITY_ATTRIBUTE3
, NULL))
, (DECODE (ACTIVITY_ID
, '80'
, ACTIVITY_ATTRIBUTE4
, '70'
, ACTIVITY_ATTRIBUTE4
, NULL))
, (DECODE (ACTIVITY_ID
, '130'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2
, '140'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3
, '150'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2
, '170'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3 || '.' || ACTIVITY_ATTRIBUTE4 || '.' || ACTIVITY_ATTRIBUTE5
, '180'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3
, '190'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3
, '210'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3
, '260'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1
, '290'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3 || '.' || ACTIVITY_ATTRIBUTE4 || '.' || ACTIVITY_ATTRIBUTE5
, '370'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3
, '390'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3
, '40'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3
, '400'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3
, '410'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3
, '470'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3 || '.' || ACTIVITY_ATTRIBUTE4
, '50'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3 || '.' || ACTIVITY_ATTRIBUTE4 || '.' || ACTIVITY_ATTRIBUTE5
, '60'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3 || '.' || ACTIVITY_ATTRIBUTE4 || '.' || ACTIVITY_ATTRIBUTE5
, '70'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3 || '.' || ACTIVITY_ATTRIBUTE4
, '80'
, ACTIVITY_ID || '.' || ACTIVITY_ATTRIBUTE1 || '.' || ACTIVITY_ATTRIBUTE2 || '.' || ACTIVITY_ATTRIBUTE3 || '.' || ACTIVITY_ATTRIBUTE4
, NULL))
FROM AMS_CAMPAIGN_SCHEDULES_B