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

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

Line: 71


        px_adj.insertion_order   := null;

Line: 95


        px_adj.insertion_order   := p_impair_loss_acct;

Line: 106


        px_adj.insertion_order   := null;

Line: 411


        select IMPAIRMENT_AMOUNT
             , REVAL_RESERVE
             , NVL(SPLIT_IMPAIR_FLAG, 'N')
             , SPLIT1_PERCENT
             , SPLIT2_PERCENT
             , SPLIT3_PERCENT
             , ASSET_ID
             , SPLIT1_IMPAIR_CLASS
             , SPLIT2_IMPAIR_CLASS
             , SPLIT3_IMPAIR_CLASS
        from   fa_mc_itf_impairments
        where  impairment_id = c_impairment_id
        and    book_type_code = c_book_type_code
        and    nvl(goodwill_asset_flag, 'N') <> 'Y'
        and    set_of_books_id = p_set_of_books_id;

Line: 429


        select IMPAIRMENT_AMOUNT
             , REVAL_RESERVE
             , NVL(SPLIT_IMPAIR_FLAG, 'N')
             , SPLIT1_PERCENT
             , SPLIT2_PERCENT
             , SPLIT3_PERCENT
             , ASSET_ID
             , SPLIT1_IMPAIR_CLASS
             , SPLIT2_IMPAIR_CLASS
             , SPLIT3_IMPAIR_CLASS
        from   fa_itf_impairments
        where  impairment_id = c_impairment_id
        and    book_type_code = c_book_type_code
        and    nvl(goodwill_asset_flag, 'N') <> 'Y';

Line: 723


                    UPDATE FA_MC_ITF_IMPAIRMENTS ITF
                    SET SPLIT1_LOSS_AMOUNT = l_split1_loss_amount
                     ,  SPLIT2_LOSS_AMOUNT = l_split2_loss_amount
                     ,  SPLIT3_LOSS_AMOUNT = l_split3_loss_amount
                     ,  CAPITAL_ADJUSTMENT = NVL(CAPITAL_ADJUSTMENT,0) + NVL(IMPAIRMENT_AMOUNT,0)
                     ,  GENERAL_FUND       = NVL(GENERAL_FUND,0) + NVL(IMPAIRMENT_AMOUNT,0)
                     ,  SPLIT1_PROCESS_ORDER = 0
                     ,  SPLIT2_PROCESS_ORDER = 0
                     ,  SPLIT3_PROCESS_ORDER = 0
                     ,  SPLIT1_REVAL_RESERVE = 0
                     ,  SPLIT2_REVAL_RESERVE = 0
                     ,  SPLIT3_REVAL_RESERVE = 0
                    WHERE  IMPAIRMENT_ID = p_impairment_id
                    AND    book_type_code = p_book_type_code
                    AND    asset_id = t_asset_id(i)
                    AND    nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
                    and    set_of_books_id = p_set_of_books_id;

Line: 741


                    UPDATE FA_ITF_IMPAIRMENTS ITF
                    SET SPLIT1_LOSS_AMOUNT = l_split1_loss_amount
                     ,  SPLIT2_LOSS_AMOUNT = l_split2_loss_amount
                     ,  SPLIT3_LOSS_AMOUNT = l_split3_loss_amount
                     ,  CAPITAL_ADJUSTMENT = NVL(CAPITAL_ADJUSTMENT,0) + NVL(IMPAIRMENT_AMOUNT,0)
                     ,  GENERAL_FUND       = NVL(GENERAL_FUND,0) + NVL(IMPAIRMENT_AMOUNT,0)
                     ,  SPLIT1_PROCESS_ORDER = 0
                     ,  SPLIT2_PROCESS_ORDER = 0
                     ,  SPLIT3_PROCESS_ORDER = 0
                     ,  SPLIT1_REVAL_RESERVE = 0
                     ,  SPLIT2_REVAL_RESERVE = 0
                     ,  SPLIT3_REVAL_RESERVE = 0
                    WHERE  IMPAIRMENT_ID = p_impairment_id
                    AND    book_type_code = p_book_type_code
                    AND    asset_id = t_asset_id(i)
                    AND    nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y';

Line: 761


                    fa_debug_pkg.add(l_calling_fn,'Updated FA_ITF_IMPAIRMENTS', 'UPDATED', p_log_level_rec => p_log_level_rec);

Line: 807


                                UPDATE FA_MC_ITF_IMPAIRMENTS ITF
                                SET SPLIT1_LOSS_AMOUNT = t_split_process_order(j).split_loss_amount
                                                         - t_split_process_order(j).reval_reserve
                                 ,  SPLIT1_REVAL_RESERVE = t_split_process_order(j).reval_reserve
                                 ,  SPLIT1_PROCESS_ORDER = j
                                WHERE  IMPAIRMENT_ID = p_impairment_id
                                AND    book_type_code = p_book_type_code
                                AND    asset_id = t_asset_id(i)
                                AND    nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
                                and    set_of_books_id = p_set_of_books_id;

Line: 818


                                UPDATE FA_ITF_IMPAIRMENTS ITF
                                SET SPLIT1_LOSS_AMOUNT = t_split_process_order(j).split_loss_amount
                                                         - t_split_process_order(j).reval_reserve
                                 ,  SPLIT1_REVAL_RESERVE = t_split_process_order(j).reval_reserve
                                 ,  SPLIT1_PROCESS_ORDER = j
                                WHERE  IMPAIRMENT_ID = p_impairment_id
                                AND    book_type_code = p_book_type_code
                                AND    asset_id = t_asset_id(i)
                                AND    nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y';

Line: 831


                                UPDATE FA_MC_ITF_IMPAIRMENTS ITF
                                SET SPLIT2_LOSS_AMOUNT = t_split_process_order(j).split_loss_amount
                                                         - t_split_process_order(j).reval_reserve
                                 ,  SPLIT2_REVAL_RESERVE = t_split_process_order(j).reval_reserve
                                 ,  SPLIT2_PROCESS_ORDER = j
                                WHERE  IMPAIRMENT_ID = p_impairment_id
                                AND    book_type_code = p_book_type_code
                                AND    asset_id = t_asset_id(i)
                                AND    nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
                                and    set_of_books_id = p_set_of_books_id;

Line: 842


                                UPDATE FA_ITF_IMPAIRMENTS ITF
                                SET SPLIT2_LOSS_AMOUNT = t_split_process_order(j).split_loss_amount
                                                         - t_split_process_order(j).reval_reserve
                                 ,  SPLIT2_REVAL_RESERVE = t_split_process_order(j).reval_reserve
                                 ,  SPLIT2_PROCESS_ORDER = j
                                WHERE  IMPAIRMENT_ID = p_impairment_id
                                AND    book_type_code = p_book_type_code
                                AND    asset_id = t_asset_id(i)
                                AND    nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y';

Line: 855


                                UPDATE FA_MC_ITF_IMPAIRMENTS ITF
                                SET SPLIT3_LOSS_AMOUNT = t_split_process_order(j).split_loss_amount
                                                         - t_split_process_order(j).reval_reserve
                                 ,  SPLIT3_REVAL_RESERVE = t_split_process_order(j).reval_reserve
                                 ,  SPLIT3_PROCESS_ORDER = j
                                WHERE  IMPAIRMENT_ID = p_impairment_id
                                AND    book_type_code = p_book_type_code
                                AND    asset_id = t_asset_id(i)
                                AND    nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
                                and    set_of_books_id = p_set_of_books_id;

Line: 866


                                UPDATE FA_ITF_IMPAIRMENTS ITF
                                SET SPLIT3_LOSS_AMOUNT = t_split_process_order(j).split_loss_amount
                                                         - t_split_process_order(j).reval_reserve
                                 ,  SPLIT3_REVAL_RESERVE = t_split_process_order(j).reval_reserve
                                 ,  SPLIT3_PROCESS_ORDER = j
                                WHERE  IMPAIRMENT_ID = p_impairment_id
                                AND    book_type_code = p_book_type_code
                                AND    asset_id = t_asset_id(i)
                                AND    nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y';

Line: 882


                        UPDATE FA_MC_ITF_IMPAIRMENTS ITF
                        SET YTD_IMPAIRMENT    = NVL(YTD_IMPAIRMENT,0) - (IMPAIRMENT_AMOUNT-
                                                (NVL(SPLIT1_LOSS_AMOUNT,0) + NVL(SPLIT2_LOSS_AMOUNT,0) + NVL(SPLIT3_LOSS_AMOUNT,0)))
                          , IMPAIRMENT_AMOUNT = NVL(SPLIT1_LOSS_AMOUNT,0) + NVL(SPLIT2_LOSS_AMOUNT,0) + NVL(SPLIT3_LOSS_AMOUNT,0)
                          , REVAL_RESERVE_ADJ_AMOUNT = REVAL_RESERVE - t_reval_reserve(i)
                          , REVAL_RESERVE = t_reval_reserve(i)
                          , GENERAL_FUND = NVL(GENERAL_FUND,0) + NVL(SPLIT1_LOSS_AMOUNT,0) + NVL(SPLIT2_LOSS_AMOUNT,0) + NVL(SPLIT3_LOSS_AMOUNT,0)
                                         + NVL(DEPRN_ADJUSTMENT_AMOUNT,0)
                          , CAPITAL_ADJUSTMENT = NVL(CAPITAL_ADJUSTMENT,0) + NVL(SPLIT1_LOSS_AMOUNT,0)
                                               + NVL(SPLIT2_LOSS_AMOUNT,0) + NVL(SPLIT3_LOSS_AMOUNT,0)                                                                                          + NVL(DEPRN_ADJUSTMENT_AMOUNT,0)
                        WHERE  IMPAIRMENT_ID = p_impairment_id
                        AND    book_type_code = p_book_type_code
                        AND    asset_id = t_asset_id(i)
                        AND    nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
                        and    set_of_books_id = p_set_of_books_id;

Line: 898


                        UPDATE FA_ITF_IMPAIRMENTS ITF
                        SET YTD_IMPAIRMENT    = NVL(YTD_IMPAIRMENT,0) - (IMPAIRMENT_AMOUNT-
                                                (NVL(SPLIT1_LOSS_AMOUNT,0) + NVL(SPLIT2_LOSS_AMOUNT,0) + NVL(SPLIT3_LOSS_AMOUNT,0)))
                          , IMPAIRMENT_AMOUNT = NVL(SPLIT1_LOSS_AMOUNT,0) + NVL(SPLIT2_LOSS_AMOUNT,0) + NVL(SPLIT3_LOSS_AMOUNT,0)
                          , REVAL_RESERVE_ADJ_AMOUNT = REVAL_RESERVE - t_reval_reserve(i)
                          , REVAL_RESERVE = t_reval_reserve(i)
                          , GENERAL_FUND = NVL(GENERAL_FUND,0) + NVL(SPLIT1_LOSS_AMOUNT,0) + NVL(SPLIT2_LOSS_AMOUNT,0) + NVL(SPLIT3_LOSS_AMOUNT,0)
                                         + NVL(DEPRN_ADJUSTMENT_AMOUNT,0)
                          , CAPITAL_ADJUSTMENT = NVL(CAPITAL_ADJUSTMENT,0) + NVL(SPLIT1_LOSS_AMOUNT,0)
                                               + NVL(SPLIT2_LOSS_AMOUNT,0) + NVL(SPLIT3_LOSS_AMOUNT,0)
                                               + NVL(DEPRN_ADJUSTMENT_AMOUNT,0)
                        WHERE  IMPAIRMENT_ID = p_impairment_id
                        AND    book_type_code = p_book_type_code
                        AND    asset_id = t_asset_id(i)
                        AND    nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y';

Line: 931


                    UPDATE FA_MC_ITF_IMPAIRMENTS ITF
                    SET
                        REVAL_RESERVE            = NVL(REVAL_RESERVE,0) - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
                      , REVAL_RESERVE_ADJ_AMOUNT = least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
                      , CAPITAL_ADJUSTMENT       = NVL(CAPITAL_ADJUSTMENT,0) + NVL(IMPAIRMENT_AMOUNT,0) - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
                                                 + NVL(DEPRN_ADJUSTMENT_AMOUNT,0)
                      , GENERAL_FUND             = NVL(GENERAL_FUND,0) + NVL(IMPAIRMENT_AMOUNT,0)
                                                 - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
                                                 + NVL(DEPRN_ADJUSTMENT_AMOUNT,0)
                      , IMPAIRMENT_AMOUNT        = NVL(IMPAIRMENT_AMOUNT,0)
                                                 - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
                      , YTD_IMPAIRMENT           = NVL(YTD_IMPAIRMENT,0)
                                                 - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
                      , SPLIT1_PROCESS_ORDER = -1
                      , SPLIT2_PROCESS_ORDER = -1
                      , SPLIT3_PROCESS_ORDER = -1
                    WHERE  IMPAIRMENT_ID = p_impairment_id
                    AND    book_type_code = p_book_type_code
                    AND    asset_id = t_asset_id(i)
                    AND    nvl(REVAL_RESERVE, 0) <> 0
                    AND    nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
                    and    set_of_books_id = p_set_of_books_id;

Line: 954


                    UPDATE FA_ITF_IMPAIRMENTS ITF
                    SET
                        REVAL_RESERVE            = NVL(REVAL_RESERVE,0) - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
                      , REVAL_RESERVE_ADJ_AMOUNT = least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
                      , CAPITAL_ADJUSTMENT       = NVL(CAPITAL_ADJUSTMENT,0) + NVL(IMPAIRMENT_AMOUNT,0) - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
                                                 + NVL(DEPRN_ADJUSTMENT_AMOUNT,0)
                      , GENERAL_FUND             = NVL(GENERAL_FUND,0) + NVL(IMPAIRMENT_AMOUNT,0)
                                                 - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
                                                 + NVL(DEPRN_ADJUSTMENT_AMOUNT,0)
                      , IMPAIRMENT_AMOUNT        = NVL(IMPAIRMENT_AMOUNT,0)
                                                 - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
                      , YTD_IMPAIRMENT           = NVL(YTD_IMPAIRMENT,0)
                                                 - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
                      , SPLIT1_PROCESS_ORDER = -1
                      , SPLIT2_PROCESS_ORDER = -1
                      , SPLIT3_PROCESS_ORDER = -1
                    WHERE  IMPAIRMENT_ID = p_impairment_id
                    AND    book_type_code = p_book_type_code
                    AND    asset_id = t_asset_id(i)
                    AND    nvl(REVAL_RESERVE, 0) <> 0
                    AND    nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y';

Line: 978


                    UPDATE FA_MC_ITF_IMPAIRMENTS ITF
                    SET    CAPITAL_ADJUSTMENT       = NVL(CAPITAL_ADJUSTMENT,0) + NVL(IMPAIRMENT_AMOUNT,0)
                                                    + NVL(DEPRN_ADJUSTMENT_AMOUNT,0)
                         , GENERAL_FUND             = NVL(GENERAL_FUND,0) + NVL(IMPAIRMENT_AMOUNT,0)
                                                    + NVL(DEPRN_ADJUSTMENT_AMOUNT,0)
                         , REVAL_RESERVE_ADJ_AMOUNT = 0
                         , SPLIT1_PROCESS_ORDER = -1
                         , SPLIT2_PROCESS_ORDER = -1
                         , SPLIT3_PROCESS_ORDER = -1
                    WHERE  IMPAIRMENT_ID = p_impairment_id
                    AND    book_type_code = p_book_type_code
                    AND    asset_id = t_asset_id(i)
                    AND    nvl(REVAL_RESERVE,0) = 0
                    AND    nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y'
                    and    set_of_books_id = p_set_of_books_id;

Line: 994


                    UPDATE FA_ITF_IMPAIRMENTS ITF
                    SET    CAPITAL_ADJUSTMENT       = NVL(CAPITAL_ADJUSTMENT,0) + NVL(IMPAIRMENT_AMOUNT,0)
                                                    + NVL(DEPRN_ADJUSTMENT_AMOUNT,0)
                         , GENERAL_FUND             = NVL(GENERAL_FUND,0) + NVL(IMPAIRMENT_AMOUNT,0)
                                                    + NVL(DEPRN_ADJUSTMENT_AMOUNT,0)
                         , REVAL_RESERVE_ADJ_AMOUNT = 0
                         , SPLIT1_PROCESS_ORDER = -1
                         , SPLIT2_PROCESS_ORDER = -1
                         , SPLIT3_PROCESS_ORDER = -1
                    WHERE  IMPAIRMENT_ID = p_impairment_id
                    AND    book_type_code = p_book_type_code
                    AND    asset_id = t_asset_id(i)
                    AND    nvl(REVAL_RESERVE,0) = 0
                    AND    nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y';