Fixed Assets Query

SELECT distinct
fab.model_number,
FAB.ASSET_TYPE ASSET_CLASS,
FAB.ASSET_NUMBER ASSET,
FAT.DESCRIPTION ASSET_DESCRITPION,
FB.BOOK_TYPE_CODE BOOK,
FB.ORIGINAL_COST ASSET_COST,
FDS.DEPRN_RESERVE ACCUMULATED_DEPRECIATION,
fds.deprn_amount The_last_depreciation_amount,
(FB.ORIGINAL_COST-FDS.DEPRN_RESERVE) Net_Book_Value,
fb.salvage_value Residual_value,
to_char(fb.prorate_date,'DD-MON-RRRR') prorate_date,
fb.life_in_months||' Motnhs'  Life_of_asset,
FAB.SERIAL_NUMBER SERIAL_NUMBER,
round((DECODE (
          fb.period_counter_fully_retired,
          NULL, GREATEST (
                   NVL (fb.life_in_months, 0)
                   - TRUNC (
                        MONTHS_BETWEEN (SYSDATE,
                                        fb.date_placed_in_service)),
                   0),
          0)) /12,1)
          remaining_life_in_years
FROM
FA_ADDITIONS_B FAB,
FA_ADDITIONS_TL FAT,
FA_BOOKS FB,
FA_DISTRIBUTION_HISTORY FDH,
PER_ALL_PEOPLE_F PAPF,
FA_LOCATIONS_KFV FLK,
GL_CODE_COMBINATIONS_KFV GCCK,
FA_DEPRN_SUMMARY FDS,
GL_ledgers  GSOB
WHERE
FAB.ASSET_ID=FAT.ASSET_ID
AND FAB.ASSET_ID=FDH.ASSET_ID
AND FAB.ASSET_ID=FB.ASSET_ID
AND FDH.DATE_INEFFECTIVE IS NULL
AND FDS.ASSET_ID=FB.ASSET_ID
AND FDS.BOOK_TYPE_CODE = FB.BOOK_TYPE_CODE
AND FDS.DEPRN_SOURCE_CODE='DEPRN'
AND FDS.PERIOD_COUNTER =(SELECT MAX(PERIOD_COUNTER) FROM FA_DEPRN_SUMMARY FDSS WHERE FDSS.DEPRN_SOURCE_CODE='DEPRN' AND FDSS.ASSET_ID=FB.ASSET_ID AND FDSS.BOOK_TYPE_CODE=FB.BOOK_TYPE_CODE)
AND FB.TRANSACTION_HEADER_ID_IN=(SELECT MAX(TRANSACTION_HEADER_ID_IN) FROM FA_BOOKS FB1 WHERE FB1.ASSET_ID=FB.ASSET_ID AND FB1.BOOK_TYPE_CODE=FB.BOOK_TYPE_CODE)
AND FB.PERIOD_COUNTER_FULLY_RETIRED IS NULL
AND FDH.LOCATION_ID=FLK.LOCATION_ID
AND GCCK.CODE_COMBINATION_ID = FDH.CODE_COMBINATION_ID
AND GCCK.CHART_OF_ACCOUNTS_ID=GSOB.CHART_OF_ACCOUNTS_ID
AND FDH.ASSIGNED_TO = PAPF.PERSON_ID (+)
AND FAT.LANGUAGE = USERENV('LANG')
AND FB.BOOK_TYPE_CODE <>'ACE TAX'
and fb.asset_id = 3316768
and fb.book_type_code = 'NEW MTN'
ORDER BY fb.ASSET_ID ;

Detele Transaction in Account receivables

declare

   v_msg_data      varchar2(4000)  := null;
    v_msg_count     number          := 0;
    v_msg_index     number          := 0;
    v_ret_status    varchar2(1)     := null;  
    v_message_tbl   arp_trx_validate.message_tbl_type;
   
begin
    dbms_output.put_line('Detele Transaction...');
   
     ---- Setting the org context for the particular session
        apps.mo_global.set_policy_context('S', 5001);
       
         apps.fnd_global.apps_initialize(1281564,50828,222);   
       
       
       
       
         ar_invoice_api_pub.delete_transaction(
                                                 p_api_name             => 'Delete_Transaction',
                                                 p_api_version          => 1.0,
                                                 p_init_msg_list        => fnd_api.g_true,
                                                 p_commit               => fnd_api.g_true,
                                                 p_validation_level     => fnd_api.g_valid_level_full,
                                                 p_customer_trx_id      => 32340430,
                                                 p_return_status        => v_ret_status,
                                                 p_msg_count            => v_msg_count,
                                                 p_msg_data             => v_msg_data,
                                                 p_errors               => v_message_tbl
                                             );
                                           
                                           
                                           
     if v_ret_status <> 'S' then
            dbms_output.put_line( '   Status: '||v_ret_status);
            for i in 1 .. v_msg_count loop
                apps.fnd_msg_pub.get( i, apps.fnd_api.g_false, v_msg_data, v_msg_index);
                dbms_output.put_line( '   Error : '||v_msg_data);
            end loop;
            dbms_output.put_line ('   '||v_msg_data);
        else
            dbms_output.put_line ('   Deleted.');
          
         end if;      
       
        commit;
        exception
    when others then
        dbms_output.put_line('Error : '||sqlerrm);
end;