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.INV_CALCULATE_EXP_DATE SQL Statements

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

Line: 138


         g_mti_tbl.DELETE;

Line: 185


         g_mti_tbl.DELETE;

Line: 223


         g_mmtt_tbl.DELETE;

Line: 270


         g_mmtt_tbl.DELETE;

Line: 345


         SELECT origination_date
           INTO x_orig_date
           FROM mtl_lot_numbers
          WHERE inventory_item_id = p_inventory_item_id
           AND lot_number = p_lot_number
           AND organization_id = p_organization_id;

Line: 354


               SELECT a.origination_date
                 INTO x_orig_date
                 FROM mtl_transaction_lots_temp a
                    , mtl_material_transactions_temp b
                WHERE b.inventory_item_id = p_inventory_item_id
                  AND a.lot_number = p_lot_number
                  AND a.transaction_temp_id = b.transaction_temp_id
                  AND ROWNUM = 1
                  AND b.organization_id = p_organization_id;

Line: 392


         SELECT 1
           INTO l_lot_exists
           FROM mtl_lot_numbers
          WHERE inventory_item_id = p_inventory_item_id
           AND lot_number = p_lot_number
           AND organization_id = p_organization_id;

Line: 434


        SELECT msi.shelf_life_code, msi.shelf_life_days
        FROM mtl_system_items msi
        WHERE msi.inventory_item_id = c_inventory_item_id
        AND    msi.organization_id = c_organization_id;

Line: 509


   PROCEDURE update_inv_lot_attr(
    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
  , p_source                 IN            NUMBER
  , p_expiration_date        IN            DATE DEFAULT NULL
  , p_grade_code             IN            VARCHAR2 DEFAULT NULL
  , p_origination_date       IN            DATE DEFAULT NULL
  , p_origination_type       IN            NUMBER DEFAULT NULL
  , p_status_id              IN            NUMBER DEFAULT NULL
  , p_retest_date            IN            DATE DEFAULT NULL
  , p_maturity_date          IN            DATE DEFAULT NULL
  , p_supplier_lot_number    IN            VARCHAR2 DEFAULT NULL
  , p_expiration_action_code IN            VARCHAR2 DEFAULT NULL
  , p_expiration_action_date IN            DATE DEFAULT NULL
  , p_hold_date              IN            DATE DEFAULT NULL
  , p_c_attribute1           IN            VARCHAR2 := NULL
  , p_c_attribute2           IN            VARCHAR2 := NULL
  , p_c_attribute3           IN            VARCHAR2 := NULL
  , p_c_attribute4           IN            VARCHAR2 := NULL
  , p_c_attribute5           IN            VARCHAR2 := NULL
  , p_c_attribute6           IN            VARCHAR2 := NULL
  , p_c_attribute7           IN            VARCHAR2 := NULL
  , p_c_attribute8           IN            VARCHAR2 := NULL
  , p_c_attribute9           IN            VARCHAR2 := NULL
  , p_c_attribute10          IN            VARCHAR2 := NULL
  , p_c_attribute11          IN            VARCHAR2 := NULL
  , p_c_attribute12          IN            VARCHAR2 := NULL
  , p_c_attribute13          IN            VARCHAR2 := NULL
  , p_c_attribute14          IN            VARCHAR2 := NULL
  , p_c_attribute15          IN            VARCHAR2 := NULL
  , p_c_attribute16          IN            VARCHAR2 := NULL
  , p_c_attribute17          IN            VARCHAR2 := NULL
  , p_c_attribute18          IN            VARCHAR2 := NULL
  , p_c_attribute19          IN            VARCHAR2 := NULL
  , p_c_attribute20          IN            VARCHAR2 := NULL
  , p_d_attribute1           IN            DATE := NULL
  , p_d_attribute2           IN            DATE := NULL
  , p_d_attribute3           IN            DATE := NULL
  , p_d_attribute4           IN            DATE := NULL
  , p_d_attribute5           IN            DATE := NULL
  , p_d_attribute6           IN            DATE := NULL
  , p_d_attribute7           IN            DATE := NULL
  , p_d_attribute8           IN            DATE := NULL
  , p_d_attribute9           IN            DATE := NULL
  , p_d_attribute10          IN            DATE := NULL
  , p_n_attribute1           IN            NUMBER := NULL
  , p_n_attribute2           IN            NUMBER := NULL
  , p_n_attribute3           IN            NUMBER := NULL
  , p_n_attribute4           IN            NUMBER := NULL
  , p_n_attribute5           IN            NUMBER := NULL
  , p_n_attribute6           IN            NUMBER := NULL
  , p_n_attribute7           IN            NUMBER := NULL
  , p_n_attribute8           IN            NUMBER := NULL
  , p_n_attribute9           IN            NUMBER := NULL
  , p_n_attribute10          IN            NUMBER := NULL
   -- bug#6073680 START. Added following parameters to handle WMS Attributes
  , p_description            IN            VARCHAR2 := NULL
  , p_vendor_name            IN            VARCHAR2 := NULL
  , p_date_code              IN            VARCHAR2 := NULL
  , p_change_date            IN            DATE := NULL
  , p_age                    IN            NUMBER := NULL
  , p_item_size              IN            NUMBER := NULL
  , p_color                  IN            VARCHAR2 := NULL
  , p_volume                 IN            NUMBER := NULL
  , p_volume_uom             IN            VARCHAR2 := NULL
  , p_place_of_origin        IN            VARCHAR2 := NULL
  , p_best_by_date           IN            DATE := NULL
  , p_length                 IN            NUMBER := NULL
  , p_length_uom             IN            VARCHAR2 := NULL
  , p_recycled_content       IN            NUMBER := NULL
  , p_thickness              IN            NUMBER := NULL
  , p_thickness_uom          IN            VARCHAR2 := NULL
  , p_width                  IN            NUMBER := NULL
  , p_width_uom              IN            VARCHAR2 := NULL
  , p_curl_wrinkle_fold      IN            VARCHAR2 := NULL
  , p_lot_attribute_category IN            VARCHAR2 := NULL
  , p_territory_code         IN            VARCHAR2 := NULL
  , p_vendor_id              IN            VARCHAR2 := NULL
  , p_parent_lot_number      IN            VARCHAR2 := NULL
   -- bug#6073680 END. Added following parameters to handle WMS Attributes
  ) IS
   l_in_lot_rec            MTL_LOT_NUMBERS%ROWTYPE;

Line: 625


     l_in_lot_rec.last_update_date              :=   SYSDATE ;

Line: 626


     l_in_lot_rec.last_updated_by               :=   FND_GLOBAL.USER_ID;

Line: 627


     l_in_lot_rec.last_update_login             :=   FND_GLOBAL.LOGIN_ID;

Line: 781


     inv_lot_api_pub.Update_Inv_lot(
           x_return_status     =>     l_return_status
         , x_msg_count         =>     l_msg_count
         , x_msg_data          =>     l_msg_data
         , x_lot_rec           =>     x_lot_rec
         , p_lot_rec           =>     l_in_lot_rec
         , p_source            =>     p_source
         , p_api_version       =>     l_api_version
         , p_init_msg_list     =>     l_init_msg_list
         , p_commit            =>     l_commit
          );

Line: 794


         mydebug('Program Update_Inv_lot return ' || l_return_status, 9);

Line: 798


         mydebug('Program Update_Inv_lot has failed with a user defined exception', 9);

Line: 803


         mydebug('Program Update_Inv_lot has failed with a Unexpected exception', 9);

Line: 806


       FND_MESSAGE.SET_TOKEN('PROG_NAME','Update_Inv_lot');

Line: 862


         mydebug(' LAST_UPDATE_DATE    '||TO_CHAR(p_mmtt_trx_rec.LAST_UPDATE_DATE, l_date_format));

Line: 863


         mydebug(' LAST_UPDATED_BY     '||p_mmtt_trx_rec.LAST_UPDATED_BY);

Line: 866


         mydebug(' LAST_UPDATE_LOGIN   '||p_mmtt_trx_rec.LAST_UPDATE_LOGIN);

Line: 870


         mydebug(' PROGRAM_UPDATE_DATE         '||TO_CHAR(p_mmtt_trx_rec.PROGRAM_UPDATE_DATE, l_date_format));

Line: 905


         mydebug(' SCHEDULE_UPDATE_CODE        '||p_mmtt_trx_rec.SCHEDULE_UPDATE_CODE);

Line: 1040


         mydebug(' LAST_UPDATE_DATE         '||TO_CHAR(p_mtlt_lot_rec.LAST_UPDATE_DATE, l_date_format));

Line: 1041


         mydebug(' LAST_UPDATED_BY  '||p_mtlt_lot_rec.LAST_UPDATED_BY);

Line: 1044


         mydebug(' LAST_UPDATE_LOGIN        '||p_mtlt_lot_rec.LAST_UPDATE_LOGIN);

Line: 1048


         mydebug(' PROGRAM_UPDATE_DATE      '||TO_CHAR(p_mtlt_lot_rec.PROGRAM_UPDATE_DATE, l_date_format));

Line: 1163


         mydebug(' LAST_UPDATE_DATE     '||TO_CHAR(p_mtlt_lot_rec.LAST_UPDATE_DATE, l_date_format));

Line: 1164


         mydebug(' LAST_UPDATED_BY  '||p_mti_trx_rec.LAST_UPDATED_BY);

Line: 1167


         mydebug(' LAST_UPDATE_LOGIN        '||p_mti_trx_rec.LAST_UPDATE_LOGIN);

Line: 1171


         mydebug(' PROGRAM_UPDATE_DATE     '||TO_CHAR(p_mtlt_lot_rec.PROGRAM_UPDATE_DATE, l_date_format));

Line: 1301


         mydebug(' SCHEDULE_UPDATE_CODE     '||p_mti_trx_rec.SCHEDULE_UPDATE_CODE);

Line: 1463


         mydebug(' LAST_UPDATE_DATE     '||TO_CHAR(p_mtlt_lot_rec.LAST_UPDATE_DATE, l_date_format));

Line: 1464


         mydebug(' LAST_UPDATED_BY       '||p_mtli_lot_rec.LAST_UPDATED_BY);

Line: 1467


         mydebug(' LAST_UPDATE_LOGIN     '||p_mtli_lot_rec.LAST_UPDATE_LOGIN);

Line: 1471


         mydebug(' PROGRAM_UPDATE_DATE     '||TO_CHAR(p_mtlt_lot_rec.PROGRAM_UPDATE_DATE, l_date_format));