APPS.INV_LOT_API_PKG SQL Statements

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

Line: 35

  SELECT  lot_control_code,
          child_lot_flag
    FROM  mtl_system_items
   WHERE  inventory_item_id =  p_inventory_item_id
     AND  organization_id   =  p_organization_id;

Line: 181

   SELECT  copy_lot_attribute_flag,
           lot_number_generation
     FROM  mtl_parameters
    WHERE  organization_id = cp_organization_id;

Line: 190

   SELECT  lot_number
     FROM  mtl_lot_numbers
    WHERE  lot_number        = cp_lot_number AND
           inventory_item_id = cp_inventory_item_id AND
           organization_id   = cp_organization_id ;

Line: 199

   SELECT  *
     FROM  mtl_lot_numbers
    WHERE  lot_number = cp_lot_number ;

Line: 314

             SELECT copy_lot_attribute_flag INTO l_copy_lot_attribute_flag
             FROM mtl_system_items
             WHERE inventory_item_id = p_lot_rec.inventory_item_id
             AND   organization_id   = p_lot_rec.organization_id;

Line: 600

   SELECT  grade_control_flag
           , default_grade
           , shelf_life_code
           , shelf_life_days
           , expiration_action_code
           , expiration_action_interval
           , retest_interval
           , maturity_days
           , hold_days
           , default_lot_status_id --bug10257769
    FROM   mtl_system_items_b
    WHERE  organization_id   = cp_organization_id
    AND    inventory_item_id = cp_inventory_item_id;

Line: 617

   SELECT  grade_code
           , expiration_date
           , expiration_action_code
           , expiration_action_date
	   , origination_date
	   , origination_type
           , retest_date
           , maturity_date
           , hold_date
    FROM   mtl_lot_numbers
    WHERE  organization_id   = cp_organization_id
    AND    inventory_item_id = cp_inventory_item_id
    AND    lot_number = cp_lot_number;

Line: 637

       SELECT * FROM mtl_transactions_interface
       WHERE transaction_interface_id = c_mti_hdr_id;

Line: 641

       SELECT * FROM mtl_transaction_lots_interface
       WHERE ROWID = c_mtli_hdr_id;

Line: 645

       SELECT * FROM mtl_material_transactions_temp
       WHERE transaction_header_id = c_mmtt_hdr_id;

Line: 649

       SELECT * FROM mtl_transaction_lots_temp
       WHERE ROWID = c_mtlt_hdr_id;

Line: 911

       select nvl(allow_different_status,2)
         into l_allow_different_status
         from mtl_parameters
        where organization_id = p_lot_rec.organization_id;

Line: 1247

          SELECT   shelf_life_days
                  , shelf_life_code
            INTO  l_shelf_life_days
                  , l_shelf_life_code
            FROM  mtl_system_items
           WHERE  inventory_item_id = p_inventory_item_id
             AND  organization_id   = p_organization_id;

Line: 1284

          SELECT SYSDATE + l_shelf_life_days
             INTO l_expiration_date
             FROM DUAL;

Line: 1351

        SELECT  lot_status_enabled , default_lot_status_id
          INTO  l_lot_status_flag  , l_def_lot_status
          FROM  mtl_system_items
         WHERE  organization_id   =  p_organization_id
           AND  inventory_item_id =  p_inventory_item_id ;

Line: 1618

    x_lot_rec.last_update_date              :=    SYSDATE;

Line: 1619

    x_lot_rec.last_updated_by               :=    fnd_global.user_id;

Line: 1687

   SELECT  *
     FROM  mtl_lot_numbers
    WHERE  lot_number        = p_lot_number
      AND  inventory_item_id = p_inventory_item_id
      AND  organization_id   = p_organization_id;

Line: 1696

   SELECT  *
     FROM  mtl_system_items
    WHERE  organization_id   = p_organization_id
      AND  inventory_item_id = p_inventory_item_id ;

Line: 2177

  PROCEDURE Delete_Lot(
    x_return_status          OUT    NOCOPY VARCHAR2
  , x_msg_count              OUT    NOCOPY NUMBER
  , x_msg_data               OUT    NOCOPY VARCHAR2
  , p_inventory_item_id     IN     NUMBER
  , p_organization_id        IN     NUMBER
  , p_lot_number             IN     VARCHAR2

   ) IS

   CURSOR  c_lot_rec  IS
   SELECT  *
     FROM  mtl_lot_numbers
    WHERE  inventory_item_id = p_inventory_item_id
      AND  organization_id   = p_organization_id
      AND  lot_number        = p_lot_number ;

Line: 2197

   SELECT  *
     FROM  mtl_object_genealogy
    WHERE  object_id = cp_gen_obj_id ;

Line: 2205

   SELECT  *
     FROM  mtl_lot_uom_class_conversions
    WHERE  lot_number = p_lot_number ;

Line: 2219

   SAVEPOINT inv_delete_lot ;

Line: 2311

       DELETE  FROM mtl_lot_numbers
        WHERE  inventory_item_id = p_inventory_item_id
          AND  organization_id   = p_organization_id
          AND  lot_number        = p_lot_number ;

Line: 2324

        print_debug('Delete_Lot. After deleting Lot Record', 9);

Line: 2331

        DELETE  FROM mtl_object_genealogy
         WHERE  object_id = l_gen_obj_id ;

Line: 2337

         print_debug('Delete_Lot. After deleting Geneology Record', 9);

Line: 2344

        DELETE  FROM mtl_lot_uom_class_conversions
         WHERE  lot_number = p_lot_number ;

Line: 2350

         print_debug('Delete_Lot. After deleting UOM Conversion Record', 9);

Line: 2354

         print_debug('End of the program Delete_Lot. Program has completed successfully ', 9);

Line: 2360

      ROLLBACK TO inv_delete_lot;

Line: 2365

      print_debug('In Delete_Lot, No data found ' || SQLERRM, 9);

Line: 2368

      ROLLBACK TO inv_delete_lot;

Line: 2373

      print_debug('In Delete_Lot, g_exc_error ' || SQLERRM, 9);

Line: 2376

      ROLLBACK TO inv_delete_lot;

Line: 2381

      print_debug('In Delete_Lot, g_exc_unexpected_error ' || SQLERRM, 9);

Line: 2384

      ROLLBACK TO inv_delete_lot;

Line: 2389

      print_debug('In Delete_Lot, Others ' || SQLERRM, 9);

Line: 2391

 END Delete_Lot;

Line: 2407

        SELECT  count('1')
        INTO    l_exists
        FROM    mtl_lot_numbers
        WHERE   inventory_item_id = p_inventory_item_id
        AND     organization_id = p_org_id
        AND     lot_number = p_lot_number
        AND     ROWNUM = 1;