SELECT   MSI.INVENTORY_ITEM_ID,
         V.PID_CODE,
         SDATE,
         NVL (TOTAL_V_REV, 0),
         NVL (TOTAL_V_NREV, 0),
         PUBLISH_DATE
  FROM   WEEKLY_table V, SYSTEM_ITEMS MSI, ITEMS DT
 WHERE       MSI.AUTO_CREATED_CONFIG_FLAG = 'N'
         AND MSI.INVENTORY_ITEM_ID = DT.INVENTORY_ITEM_ID
         AND MSI.ORGANIZATION_ID LIKE MSI.ORGANIZATION_ID
         AND MSI.ORGANIZATION_ID = 1
         AND MSI.INVENTORY_ITEM_STATUS_CODE NOT IN
                  ('DEA', 'E.O.L.', 'OBSOLETE')
         AND V.PID_CODE = MSI.SEGMENT1
         AND global_name LIKE global_name
         AND MSI.SEGMENT1 = DT.PID_CODE
         AND MSI.CUSTOMER_ORDER_FLAG = 'Y'
         AND MSI.BOM_ITEM_TYPE NOT IN (12, 13, 15)
         AND MSI.SERVICE_ITEM_FLAG = 'N'
         AND MSI.INVENTORY_ITEM_ID = DT.INVENTORY_ITEM_ID
         AND DT.HARD_SOFT = 'Hard'
         AND SDATE BETWEEN '02/13/2011 00:00:00' AND '05/06/2012 00:00:00'
         AND V.PUBLISH_DATE = (SELECT   MAX (PUBLISH_DATE) FROM WEEKLY_table)
         AND EXISTS
               (  SELECT   PID_CODE
                    FROM   WEEKLY_table V2
                   WHERE   V2.PUBLISH_DATE = V.PUBLISH_DATE
                           AND V2.PID_CODE = V.PID_CODE
                           AND SDATE BETWEEN '02/13/2011 00:00:00'
                                         AND  '05/06/2012 00:00:00'
                GROUP BY   V2.PID_CODE
                  HAVING   SUM (NVL (TOTAL_V_REV, 0)) > 0
                           OR SUM (NVL (TOTAL_V_NREV, 0)) > 0)

SQL Stmt : SELECT   MSI.INVENTORY_ITEM_ID,
         V.PID_CODE,
         SDATE,
         NVL (TOTAL_V_REV, 0),
         NVL (TOTAL_V_NREV, 0),
         PUBLISH_DATE
  FROM   WEEKLY_table V, SYSTEM_ITEMS MSI, ITEMS DT
 WHERE       MSI.AUTO_CREATED_CONFIG_FLAG = 'N'
         AND MSI.INVENTORY_ITEM_ID = DT.INVENTORY_ITEM_ID
         AND MSI.ORGANIZATION_ID LIKE MSI.ORGANIZATION_ID
         AND MSI.ORGANIZATION_ID = 1
         AND MSI.INVENTORY_ITEM_STATUS_CODE NOT IN
                  ('DEA', 'E.O.L.', 'OBSOLETE')
         AND V.PID_CODE = MSI.SEGMENT1
         AND global_name LIKE global_name
         AND MSI.SEGMENT1 = DT.PID_CODE
         AND MSI.CUSTOMER_ORDER_FLAG = 'Y'
         AND MSI.BOM_ITEM_TYPE NOT IN (12, 13, 15)
         AND MSI.SERVICE_ITEM_FLAG = 'N'
         AND MSI.INVENTORY_ITEM_ID = DT.INVENTORY_ITEM_ID
         AND DT.HARD_SOFT = 'Hard'
         AND SDATE BETWEEN '02/13/2011 00:00:00' AND '05/06/2012 00:00:00'
         AND V.PUBLISH_DATE = (SELECT   MAX (PUBLISH_DATE) FROM WEEKLY_table)
         AND EXISTS
               (  SELECT   PID_CODE
                    FROM   WEEKLY_table V2
                   WHERE   V2.PUBLISH_DATE = V.PUBLISH_DATE
                           AND V2.PID_CODE = V.PID_CODE
                           AND SDATE BETWEEN '02/13/2011 00:00:00'
                                         AND  '05/06/2012 00:00:00'
                GROUP BY   V2.PID_CODE
                  HAVING   SUM (NVL (TOTAL_V_REV, 0)) > 0
                           OR SUM (NVL (TOTAL_V_NREV, 0)) > 0)

The issue can occur when a index block delete is not completed.
ROWID's are found in the index block leaf.

SQL> create table t1 (id number primary key, res varchar2(10));

Table created.

SQL> insert into t1 
  2  select level, 'a' from dual connect by level <10;

9 rows created.

SQL> commit;

Commit complete.

SQL> declare
  2   id1 number;
  3   cursor curs is
  4    select t1.id from t1 where id<5 for update;
  5  begin
  6   open curs;
  7  loop
  8   exit when curs%notfound;
  9   fetch curs into id1;
 10    update t1 set res = 'b'||to_char(id1) where current of curs;
 11  end loop;
 12  close curs;
 13  end;
 14  /
declare
*
ERROR at line 1:
ORA-01410: invalid ROWID
ORA-06512: at line 10


SQL> 

exit when curs%notfound;

SQL> drop table t1;

Table dropped.

SQL> create table t1 (id number primary key, res varchar2(10));

Table created.

SQL> insert into t1 
  2  select level, 'a' from dual connect by level <10;

9 rows created.

SQL> commit;

Commit complete.

SQL> declare
  2   id1 number;
  3   cursor curs is
  4    select t1.id from t1 where id<5 for update;
  5  begin
  6   open curs;
  7  loop
  8   fetch curs into id1;
  9   exit when curs%notfound;
 10    update t1 set res = 'b'||to_char(id1) where current of curs;
 11  end loop;
 12  close curs;
 13  end;
 14  /

PL/SQL procedure successfully completed.

SQL>