APPS.OEXVWLIN SQL Statements

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

Line: 36

      SELECT NVL(SUM( (NVL( ORDERED_QUANTITY, 0 ) -
                       NVL( CANCELLED_QUANTITY, 0 )) *
                      NVL(SELLING_PRICE, 0 ))
                    , 0)
      INTO   order_line_total
      FROM   SO_LINES
      WHERE  SHIPMENT_SCHEDULE_LINE_ID = ORDER_LINE_ID;

Line: 45

      SELECT NVL(SUM((NVL( ORDERED_QUANTITY, 0 ) -
                     NVL( CANCELLED_QUANTITY, 0 )) *
                    NVL(SELLING_PRICE, 0 ))
                 , 0)
      INTO   order_line_total
      FROM   SO_LINES
      WHERE  (ROWID = ORDER_ROWID
      OR     PARENT_LINE_ID = ORDER_LINE_ID
      OR     SERVICE_PARENT_LINE_ID = ORDER_LINE_ID );

Line: 65

      SELECT NVL(SUM((NVL( ORDERED_QUANTITY, 0 ) -
                      NVL( CANCELLED_QUANTITY, 0 )) *
                     NVL(SELLING_PRICE, 0 ))
                 , 0)
      INTO   order_line_total
      FROM   SO_LINES
      WHERE  (ROWID = ORDER_ROWID
      OR     SERVICE_PARENT_LINE_ID = ORDER_LINE_ID );

Line: 99

  SELECT DECODE( NVL( SUM( DECODE( SLD.SCHEDULE_STATUS_CODE,
                                  'RESERVED', SLD.QUANTITY, 0 ) ), 0),
                0,
                DECODE( NVL( SUM( DECODE( SLD.SCHEDULE_STATUS_CODE,
                            'SUPPLY RESERVED', SLD.QUANTITY, 0 ) ), 0),
                        0,
                        DECODE( NVL( SUM( DECODE(
                                      SLD.SCHEDULE_STATUS_CODE,
                                      'DEMANDED', SLD.QUANTITY, 0 ) ),0 ),
                                0, NULL,
                                'DEMANDED' ),
                        'SUPPLY RESERVED' ),
                 'RESERVED' )
  INTO schedule_status_code
  FROM SO_LINE_DETAILS SLD
  WHERE SLD.LINE_ID = ORDER_LINE_ID;

Line: 118

     select meaning
     into  schedule_status
     from   so_lookups
     where  lookup_code =  schedule_status_code
     and    lookup_type = 'SCHEDULE STATUS';

Line: 144

  select sum( decode( SCHEDULE_STATUS_CODE,
                      'RESERVED', QUANTITY,
                      0))
  into RESERVED_QTY
  from SO_LINE_DETAILS
  where line_id = ORDER_LINE_ID
  and NVL(INCLUDED_ITEM_FLAG, 'N')='N';

Line: 172

   SELECT DECODE( NVL(SUM(DECODE( HOLD_RELEASE_ID, NULL, 1, 0)),0),
           0,'N', 'Y')
   INTO   HOLD_FLAG
   FROM   SO_ORDER_HOLDS_ALL
   WHERE  LINE_ID = ORDER_LINE_ID
   OR    (LINE_ID IS NULL AND HEADER_ID = ORDER_HEADER_ID);

Line: 205

         SELECT LINE_NUMBER
         INTO   SHIP_NUMBER
         FROM   SO_LINES
         WHERE  LINE_ID = ORDER_PARENT_LINE_ID;

Line: 239

         SELECT LINE_NUMBER
         INTO   LINES_NUMBER
         FROM   SO_LINES
         WHERE  LINE_ID = ORDER_PARENT_LINE_ID;

Line: 245

      SELECT LINE_NUMBER
      INTO   LINES_NUMBER
      FROM   SO_LINES
      WHERE  LINE_ID = ORDER_SHIP_SCHEDULE_LINE_ID;

Line: 269

  SELECT CONCATENATED_SEGMENTS
  INTO   ITEM_NAME
  FROM   MTL_SYSTEM_ITEMS_KFV
  WHERE  INVENTORY_ITEM_ID = ITEM_ID
  AND    ORGANIZATION_ID = ORG_ID;

Line: 295

  SELECT NAME
  INTO   ORDER_TYPE
  FROM   SO_ORDER_TYPES
  WHERE  ORDER_TYPE_ID = ID;