APPS.CSE_ASSET_WIP_PKG SQL Statements

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

Line: 10

PROCEDURE update_comp_assets(
  p_top_instance_id       IN        NUMBER
, x_return_status         OUT NOCOPY       VARCHAR2
, x_error_msg             OUT NOCOPY       VARCHAR2
  )
IS
l_relationship_tbl         csi_datastructures_pub.ii_relationship_tbl ;

Line: 36

SELECT instance_id,
       instance_usage_code,
       inventory_item_id,
       quantity,
       serial_number
FROM   csi_item_instances
WHERE  instance_id = c_comp_instance_id ;

Line: 46

SELECT transaction_id,
       ABS(quantity)
FROM   csi_inst_txn_details_v
WHERE  instance_id = c_instance_id
AND    source_transaction_type = 'WIP_ISSUE' ;

Line: 54

SELECT cia.fa_asset_id,
       cia.fa_book_type_code,
       cia.fa_location_id,
       fdh.units_assigned,
       cia.update_status,
       fdh.code_combination_id,
       fdh.assigned_to
FROM  csi_i_assets cia,
      fa_distribution_history fdh
WHERE instance_id = c_instance_id
AND   update_status = 'IN_SERVICE'
AND   asset_quantity > 0
AND   TRUNC(active_start_date) <= l_sysdate
AND   NVL(TRUNC(active_end_date), l_sysdate) >= l_sysdate
AND   fdh.asset_id = cia.fa_asset_id
AND   fdh.book_type_code = cia.fa_book_type_code
AND   fdh.location_id = cia.fa_location_id
AND   fdh.date_ineffective IS NULL
ORDER BY cia.fa_asset_id ;

Line: 77

SELECT fab.cost,
       faa.current_units
FROM   fa_additions faa,
       fa_books fab
WHERE  fab.book_type_code = c_book_type_code
AND    fab.asset_id = c_asset_id
AND    faa.asset_id = fab.asset_id ;

Line: 86

     cse_util_pkg.write_log('Begin  update_comp_assets for top instance :'
        || p_top_instance_id);

Line: 88

     SELECT TRUNC(SYSDATE) INTO l_sysdate FROM DUAL ;

Line: 207

END update_comp_assets ;

Line: 236

SELECT  fab.date_placed_in_service ,
        faa.description,
        faa.asset_category_id,
        faa.asset_key_ccid
FROM   fa_books fab ,
       fa_additions faa
WHERE fab.book_type_code = p_book_type_code
AND   fab.asset_id = p_asset_id
AND   faa.asset_id = fab.asset_id
AND   fab.date_ineffective IS NULL ;

Line: 267

    SELECT SYSDATE INTO l_sysdate FROM DUAL ;

Line: 287

    l_mass_add_rec.last_update_date := l_sysdate;

Line: 289

    l_mass_add_rec.last_updated_by := fnd_global.user_id ;

Line: 290

    l_mass_add_rec.last_update_login := fnd_global.login_id ;

Line: 291

    l_mass_add_rec.last_update_login := fnd_global.login_id ;

Line: 293

    cse_asset_util_pkg.insert_mass_add(
         p_api_version => 1.0
        ,p_commit => FND_API.G_FALSE
        ,p_init_msg_list => FND_API.G_TRUE
        ,p_mass_add_rec => l_mass_add_rec
        ,x_return_status => l_return_status
        ,x_msg_count => l_msg_count
        ,x_msg_data => l_msg_data );