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.

APPS.JTFB_PICASSO_DEMO SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 95


     FOR i IN 1..jtfb_dcf.get_multiselect_count(l_p_objects) LOOP
       l_object := jtfb_dcf.get_multiselect_value(l_p_objects,i);

Line: 99


         INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'CAMPAIGNS', 'Campaigns', '67', '4.0');

Line: 103


         INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'LEADS', 'Leads', '2,523', '-5.1');

Line: 107


         INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'OPPORTUNITIES', 'Opportunities', '1522', '4.1');

Line: 111


         INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'QUOTES', 'Quotes', '954', '3.19');

Line: 115


         INSERT INTO jtfb_temp_bin(bin_code, col1, col2, col4, col6) VALUES(l_bin_code, 'CUSTOMERS', 'Customers', '3,154', '6.5');

Line: 121


   jtfb_temp_bin_pkg.insert_row(
        x_rowid     => l_rowid
      , x_bin_code  => l_bin_code
      , x_col1      => 'CAMPAIGNS'
      , x_col2      => 'Campaigns'
      , x_col4      => '67'
      , x_col6      => '4.0'
   );

Line: 130


   jtfb_temp_bin_pkg.insert_row(
        x_rowid     => l_rowid
      , x_bin_code  => l_bin_code
      , x_col1      => 'LEADS'
      , x_col2      => 'Leads'
      , x_col4      => '2523'
      , x_col6      => '-5.1'
   );

Line: 139


   jtfb_temp_bin_pkg.insert_row(
        x_rowid     => l_rowid
      , x_bin_code  => l_bin_code
      , x_col1      => 'OPPORTUNITIES'
      , x_col2      => 'Opportunities'
      , x_col4      => '1522'
      , x_col6      => '4.1'
   );

Line: 148


   jtfb_temp_bin_pkg.insert_row(
        x_rowid     => l_rowid
      , x_bin_code  => l_bin_code
      , x_col1      => 'QUOTES'
      , x_col2      => 'Quotes'
      , x_col4      => '954'
      , x_col6      => '3.19'
   );

Line: 157


   jtfb_temp_bin_pkg.insert_row(
        x_rowid     => l_rowid
      , x_bin_code  => l_bin_code
      , x_col1      => 'CUSTOMERS'
      , x_col2      => 'Customers'
      , x_col4      => '3154'
      , x_col6      => '6.5'
   );

Line: 180


   insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
      values(l_bin_code, 'APR-01', 'APR-01', '6', '4.0');

Line: 182


   insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
      values(l_bin_code, 'MAR-01', 'MAR-01', '4', '2.1');

Line: 184


   insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
      values(l_bin_code, 'FEB-01', 'FEB-01', '2', '5.0');

Line: 186


   insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
      values(l_bin_code, 'JAN-01', 'JAN-01', '12', '8.0');

Line: 188


   insert into jtfb_temp_bin(bin_code, col1, col2, col4, col6)
      values(l_bin_code, 'DEC-00', 'DEC-00', '0', '0.0');

Line: 212


      jtfb_temp_report_pkg.insert_row(
           x_rowid     => l_rowid
         , x_report_code  => l_report_code
         , x_col1      => 'TOTAL'
         , x_col2      => 'Total'
         , x_col4      => '514'
         , x_col6      => '648'
         , x_col8      => '484'
         , x_col10     => '500'
         , x_col12     => '30.37'
      );

Line: 224


      jtfb_temp_report_pkg.insert_row(
           x_rowid     => l_rowid
         , x_report_code  => l_report_code
         , x_col1      => '10'
         , x_col2      => 'Think Customer'
         , x_col4      => '200'
         , x_col6      => '327'
         , x_col8      => '168'
         , x_col10     => '250'
         , x_col12     => '35.97'
      );

Line: 236


      jtfb_temp_report_pkg.insert_row(
           x_rowid     => l_rowid
         , x_report_code  => l_report_code
         , x_col1      => '20'
         , x_col2      => 'CRM in 90 Days'
         , x_col4      => '150'
         , x_col6      => '260'
         , x_col8      => '130'
         , x_col10     => '150'
         , x_col12     => '27.77'
      );

Line: 248


      jtfb_temp_report_pkg.insert_row(
           x_rowid     => l_rowid
         , x_report_code  => l_report_code
         , x_col1      => '30'
         , x_col2      => 'Interaction Center Push'
         , x_col4      => '400'
         , x_col6      => '345'
         , x_col8      => '140'
         , x_col10     => '365'
         , x_col12     => '41.24'
      );

Line: 262


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, 'TOTAL', 'Total'
            , '466', '44','574','33','1117');

Line: 266


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, '10', 'France'
            , '116','11','123','4','254');

Line: 270


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, '20', 'Canada'
            , '120','10','151','6','287');

Line: 274


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, '30', 'UK'
            , '90','8','140','8','246');

Line: 278


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, '40', 'US'
            , '140','15','160','15','330');

Line: 285


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, 'TOTAL', 'Total', '20'
            , '21','49','59','149');

Line: 289


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, '10', 'US Defense'
            , '9','10','22','24','65');

Line: 293


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, '20', 'Drainage Canal'
            , '5','3','12','14','34');

Line: 297


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, '30', 'Water and Sanitary'
            , '6','8','15','21','50');

Line: 304


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, 'TOTAL', 'Total'
            , '42', '72','107','121','343');

Line: 308


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, '10', 'Oracle Australia'
            , '15','20','40','43','118');

Line: 312


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, '20', 'Oracle Argentina'
            , '5','10','12','16','43');

Line: 316


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, '30', 'Oracle Canada'
            , '22','42','55','62','182');

Line: 323


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, 'TOTAL', 'Total'
            ,  '448', '520','200','363','30.37');

Line: 327


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, '10', 'Compaq'
            ,'50', '60','110','150','370');

Line: 331


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, '20', 'Xerox'
            ,'70', '50','130','150','400');

Line: 335


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, '30', 'GE Medical'
            ,'45', '80','140','240','505');

Line: 339


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, '30', 'HP'
            ,'45', '80','140','140','405');

Line: 343


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, '30', 'Papa Jones'
            ,'70', '80','140','280','570');

Line: 349


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, 'TOTAL', 'Total'
            , '514', '648','484','500','30.37');

Line: 353


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, '10', 'Think Customer'
            , '200','327','168','250','35.97');

Line: 357


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, '20', 'CRM in 90 Days'
            , '150','260','130','150','27.77');

Line: 361


      insert into jtfb_temp_report(report_code, col1, col2
            , col4, col6, col8, col10, col12)
         values(l_report_code, '30', 'Interaction Center Push'
            , '400','345','140','365','41.24');