APPS.ONT_UPGRADE_EXCEPTION_REPORT SQL Statements

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

Line: 21

         SELECT SHIPMENT_SCHEDULE_LINE_ID,
                PARENT_LINE_ID,
                LINE_NUMBER
         INTO   V_SHIPMENT_SCHEDULE_LINE_ID,
                V_PARENT_LINE_ID,
                V_LINE_NUMBER
         FROM   SO_LINES_ALL
         WHERE  LINE_ID = P_SERVICE_PARENT_LINE_ID;

Line: 34

          SELECT  LINE_NUMBER
          INTO    BASE_LINE_NUMBER
          FROM    SO_LINES_ALL
          WHERE   LINE_ID = V_PARENT_LINE_ID;

Line: 40

     SELECT    LINE_NUMBER
     INTO BASE_LINE_NUMBER
     FROM SO_LINES_ALL
     WHERE     LINE_ID = V_SHIPMENT_SCHEDULE_LINE_ID;

Line: 72

         SELECT SHIPMENT_SCHEDULE_LINE_ID,
         PARENT_LINE_ID,
         LINE_NUMBER
         INTO   V_SHIPMENT_SCHEDULE_LINE_ID,
         V_PARENT_LINE_ID,
         V_LINE_NUMBER
         FROM   SO_LINES_ALL
         WHERE  LINE_ID = P_SERVICE_PARENT_LINE_ID;

Line: 85

          SELECT    LINE_NUMBER
          INTO SCHEDULE_LINE_NUMBER
          FROM SO_LINES_ALL
          WHERE     LINE_ID = V_PARENT_LINE_ID;

Line: 118

         SELECT SHIPMENT_SCHEDULE_LINE_ID,
                PARENT_LINE_ID,
                LINE_NUMBER
         INTO   V_SHIPMENT_SCHEDULE_LINE_ID,
                V_PARENT_LINE_ID,
                V_LINE_NUMBER
         FROM   SO_LINES_ALL
         WHERE  LINE_ID = P_SERVICE_PARENT_LINE_ID;