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_MASSTFR_PKG SQL Statements

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

Line: 71


        SELECT famt.*
        FROM   FA_MASS_TRANSFERS  famt
        WHERE  MASS_TRANSFER_ID = p_mass_transfer_id;

Line: 77


      select faad.asset_id,
             faad.asset_number,
             fadh.distribution_id,
             fadh.assigned_to,
             fadh.location_id,
             fadh.code_combination_id,
             fadh.units_assigned
      from fa_books fabk,
           gl_code_combinations gcc,
           fa_additions_b faad,
           fa_distribution_history fadh
      where    (fadh.code_combination_id = gcc.code_combination_id)
      AND (fadh.asset_id = faad.asset_id)
      AND (fabk.asset_id = faad.asset_id)
      AND (fadh.book_type_code = l_book_type_code)
      AND (fabk.book_type_code = fadh.book_type_code)
      AND (faad.asset_category_id = nvl(l_category_id,faad.asset_category_id))
      AND (faad.asset_type <> 'GROUP')
      AND (nvl(l_from_loc,fadh.location_id) = fadh.location_id)
      AND (nvl(l_from_emp,nvl(fadh.assigned_to,-99)) = nvl(fadh.assigned_to,-99))
      AND (fadh.transaction_header_id_out is null)
      AND (fadh.retirement_id is null)
      AND (fabk.date_ineffective is null)
      AND (fabk.period_counter_fully_retired is null)
      AND (gcc.segment1 is NULL or
           gcc.segment1 BETWEEN nvl(mtfr_rec.segment1_Low,gcc.segment1) AND nvl(mtfr_rec.segment1_High,gcc.segment1))
      AND (gcc.segment2 is NULL or
           gcc.segment2 BETWEEN nvl(mtfr_rec.segment2_Low,gcc.segment2) AND nvl(mtfr_rec.segment2_High,gcc.segment2))
      AND (gcc.segment3 is NULL or
           gcc.segment3 BETWEEN nvl(mtfr_rec.segment3_Low,gcc.segment3) AND nvl(mtfr_rec.segment3_High,gcc.segment3))
      AND (gcc.segment4 is NULL or
           gcc.segment4 BETWEEN nvl(mtfr_rec.segment4_Low,gcc.segment4) AND nvl(mtfr_rec.segment4_High,gcc.segment4))
      AND (gcc.segment5 is NULL or
           gcc.segment5 BETWEEN nvl(mtfr_rec.segment5_Low,gcc.segment5) AND nvl(mtfr_rec.segment5_High,gcc.segment5))
      AND (gcc.segment6 is NULL or
           gcc.segment6 BETWEEN nvl(mtfr_rec.segment6_Low,gcc.segment6) AND nvl(mtfr_rec.segment6_High,gcc.segment6))
      AND (gcc.segment7 is NULL or
           gcc.segment7 BETWEEN nvl(mtfr_rec.segment7_Low,gcc.segment7) AND nvl(mtfr_rec.segment7_High,gcc.segment7))
      AND (gcc.segment8 is NULL or
           gcc.segment8 BETWEEN nvl(mtfr_rec.segment8_Low,gcc.segment8) AND nvl(mtfr_rec.segment8_High,gcc.segment8))
      AND (gcc.segment9 is NULL or
           gcc.segment9 BETWEEN nvl(mtfr_rec.segment9_Low,gcc.segment9) AND nvl(mtfr_rec.segment9_High,gcc.segment9))
      AND (gcc.segment10 is NULL or
           gcc.segment10 BETWEEN nvl(mtfr_rec.segment10_Low,gcc.segment10) AND nvl(mtfr_rec.segment10_High,gcc.segment10))
      AND (gcc.segment11 is NULL or
           gcc.segment11 BETWEEN nvl(mtfr_rec.segment11_Low,gcc.segment11) AND nvl(mtfr_rec.segment11_High,gcc.segment11))
      AND (gcc.segment12 is NULL or
           gcc.segment12 BETWEEN nvl(mtfr_rec.segment12_Low,gcc.segment12) AND nvl(mtfr_rec.segment12_High,gcc.segment12))
      AND (gcc.segment13 is NULL or
           gcc.segment13 BETWEEN nvl(mtfr_rec.segment13_Low,gcc.segment13) AND nvl(mtfr_rec.segment13_High,gcc.segment13))
      AND (gcc.segment14 is NULL or
           gcc.segment14 BETWEEN nvl(mtfr_rec.segment14_Low,gcc.segment14) AND nvl(mtfr_rec.segment14_High,gcc.segment14))
      AND (gcc.segment15 is NULL or
           gcc.segment15 BETWEEN nvl(mtfr_rec.segment15_Low,gcc.segment15) AND nvl(mtfr_rec.segment15_High,gcc.segment15))
      AND (gcc.segment16 is NULL or
           gcc.segment16 BETWEEN nvl(mtfr_rec.segment16_Low,gcc.segment16) AND nvl(mtfr_rec.segment16_High,gcc.segment16))
      AND (gcc.segment17 is NULL or
           gcc.segment17 BETWEEN nvl(mtfr_rec.segment17_Low,gcc.segment17) AND nvl(mtfr_rec.segment17_High,gcc.segment17))
      AND (gcc.segment18 is NULL or
           gcc.segment18 BETWEEN nvl(mtfr_rec.segment18_Low,gcc.segment18) AND nvl(mtfr_rec.segment18_High,gcc.segment18))
      AND (gcc.segment19 is NULL or
           gcc.segment19 BETWEEN nvl(mtfr_rec.segment19_Low,gcc.segment19) AND nvl(mtfr_rec.segment19_High,gcc.segment19))
      AND (gcc.segment20 is NULL or
           gcc.segment20 BETWEEN nvl(mtfr_rec.segment20_Low,gcc.segment20) AND nvl(mtfr_rec.segment20_High,gcc.segment20))
      AND (gcc.segment21 is NULL or
           gcc.segment21 BETWEEN nvl(mtfr_rec.segment21_Low,gcc.segment21) AND nvl(mtfr_rec.segment21_High,gcc.segment21))
      AND (gcc.segment22 is NULL or
           gcc.segment22 BETWEEN nvl(mtfr_rec.segment22_Low,gcc.segment22) AND nvl(mtfr_rec.segment22_High,gcc.segment22))
      AND (gcc.segment23 is NULL or
           gcc.segment23 BETWEEN nvl(mtfr_rec.segment23_Low,gcc.segment23) AND nvl(mtfr_rec.segment23_High,gcc.segment23))
      AND (gcc.segment24 is NULL or
           gcc.segment24 BETWEEN nvl(mtfr_rec.segment24_Low,gcc.segment24) AND nvl(mtfr_rec.segment24_High,gcc.segment24))
      AND (gcc.segment25 is NULL or
           gcc.segment25 BETWEEN nvl(mtfr_rec.segment25_Low,gcc.segment25) AND nvl(mtfr_rec.segment25_High,gcc.segment25))
      AND (gcc.segment26 is NULL or
           gcc.segment26 BETWEEN nvl(mtfr_rec.segment26_Low,gcc.segment26) AND nvl(mtfr_rec.segment26_High,gcc.segment26))
      AND (gcc.segment27 is NULL or
           gcc.segment27 BETWEEN nvl(mtfr_rec.segment27_Low,gcc.segment27) AND nvl(mtfr_rec.segment27_High,gcc.segment27))
      AND (gcc.segment28 is NULL or
           gcc.segment28 BETWEEN nvl(mtfr_rec.segment28_Low,gcc.segment28) AND nvl(mtfr_rec.segment28_High,gcc.segment28))
      AND (gcc.segment29 is NULL or
           gcc.segment29 BETWEEN nvl(mtfr_rec.segment29_Low,gcc.segment29) AND nvl(mtfr_rec.segment29_High,gcc.segment29))
      AND (gcc.segment30 is NULL or
           gcc.segment30 BETWEEN nvl(mtfr_rec.segment30_Low,gcc.segment30) AND nvl(mtfr_rec.segment30_High,gcc.segment30))
      AND not exists (select 1
                      from   FA_ASSET_HIERARCHY ASH
                      where  ASH.ASSET_ID            = FAAD.ASSET_ID
                      and    ASH.PARENT_HIERARCHY_ID is not null
)
      AND faad.asset_id > px_max_asset_id
      AND MOD(faad.asset_id, p_total_requests) = (p_request_number - 1)
      order by faad.asset_id;

Line: 172


      select faad.asset_id,
             faad.asset_number,
             fadh.distribution_id,
             fadh.assigned_to,
             fadh.location_id,
             fadh.code_combination_id,
             fadh.units_assigned
      from fa_books fabk,
           fa_additions_b faad,
           gl_code_combinations gcc,
           fa_distribution_history fadh
      where (fadh.code_combination_id = gcc.code_combination_id)
      AND (fadh.asset_id = faad.asset_id)
      AND (fabk.asset_id = faad.asset_id)
      AND (fadh.book_type_code = l_book_type_code)
      AND (fabk.book_type_code = fadh.book_type_code)
      AND (faad.asset_category_id = nvl(l_category_id,faad.asset_category_id))
      AND (faad.asset_type <> 'GROUP')
      AND (nvl(l_from_loc,fadh.location_id) = fadh.location_id)
      AND (nvl(l_from_emp,nvl(fadh.assigned_to,-99)) = nvl(fadh.assigned_to,-99))
      AND (fadh.transaction_header_id_out is null)
      AND (fadh.retirement_id is null)
      AND (fabk.date_ineffective is null)
      AND (fabk.period_counter_fully_retired is null)
      AND (gcc.segment1 is NULL or
           gcc.segment1 BETWEEN nvl(mtfr_rec.segment1_Low,gcc.segment1) AND nvl(mtfr_rec.segment1_High,gcc.segment1))
      AND (gcc.segment2 is NULL or
           gcc.segment2 BETWEEN nvl(mtfr_rec.segment2_Low,gcc.segment2) AND nvl(mtfr_rec.segment2_High,gcc.segment2))
      AND (gcc.segment3 is NULL or
           gcc.segment3 BETWEEN nvl(mtfr_rec.segment3_Low,gcc.segment3) AND nvl(mtfr_rec.segment3_High,gcc.segment3))
      AND (gcc.segment4 is NULL or
           gcc.segment4 BETWEEN nvl(mtfr_rec.segment4_Low,gcc.segment4) AND nvl(mtfr_rec.segment4_High,gcc.segment4))
      AND (gcc.segment5 is NULL or
           gcc.segment5 BETWEEN nvl(mtfr_rec.segment5_Low,gcc.segment5) AND nvl(mtfr_rec.segment5_High,gcc.segment5))
      AND (gcc.segment6 is NULL or
           gcc.segment6 BETWEEN nvl(mtfr_rec.segment6_Low,gcc.segment6) AND nvl(mtfr_rec.segment6_High,gcc.segment6))
      AND (gcc.segment7 is NULL or
           gcc.segment7 BETWEEN nvl(mtfr_rec.segment7_Low,gcc.segment7) AND nvl(mtfr_rec.segment7_High,gcc.segment7))
      AND (gcc.segment8 is NULL or
           gcc.segment8 BETWEEN nvl(mtfr_rec.segment8_Low,gcc.segment8) AND nvl(mtfr_rec.segment8_High,gcc.segment8))
      AND (gcc.segment9 is NULL or
           gcc.segment9 BETWEEN nvl(mtfr_rec.segment9_Low,gcc.segment9) AND nvl(mtfr_rec.segment9_High,gcc.segment9))
      AND (gcc.segment10 is NULL or
           gcc.segment10 BETWEEN nvl(mtfr_rec.segment10_Low,gcc.segment10) AND nvl(mtfr_rec.segment10_High,gcc.segment10))
      AND (gcc.segment11 is NULL or
           gcc.segment11 BETWEEN nvl(mtfr_rec.segment11_Low,gcc.segment11) AND nvl(mtfr_rec.segment11_High,gcc.segment11))
      AND (gcc.segment12 is NULL or
           gcc.segment12 BETWEEN nvl(mtfr_rec.segment12_Low,gcc.segment12) AND nvl(mtfr_rec.segment12_High,gcc.segment12))
      AND (gcc.segment13 is NULL or
           gcc.segment13 BETWEEN nvl(mtfr_rec.segment13_Low,gcc.segment13) AND nvl(mtfr_rec.segment13_High,gcc.segment13))
      AND (gcc.segment14 is NULL or
           gcc.segment14 BETWEEN nvl(mtfr_rec.segment14_Low,gcc.segment14) AND nvl(mtfr_rec.segment14_High,gcc.segment14))
      AND (gcc.segment15 is NULL or
           gcc.segment15 BETWEEN nvl(mtfr_rec.segment15_Low,gcc.segment15) AND nvl(mtfr_rec.segment15_High,gcc.segment15))
      AND (gcc.segment16 is NULL or
           gcc.segment16 BETWEEN nvl(mtfr_rec.segment16_Low,gcc.segment16) AND nvl(mtfr_rec.segment16_High,gcc.segment16))
      AND (gcc.segment17 is NULL or
           gcc.segment17 BETWEEN nvl(mtfr_rec.segment17_Low,gcc.segment17) AND nvl(mtfr_rec.segment17_High,gcc.segment17))
      AND (gcc.segment18 is NULL or
           gcc.segment18 BETWEEN nvl(mtfr_rec.segment18_Low,gcc.segment18) AND nvl(mtfr_rec.segment18_High,gcc.segment18))
      AND (gcc.segment19 is NULL or
           gcc.segment19 BETWEEN nvl(mtfr_rec.segment19_Low,gcc.segment19) AND nvl(mtfr_rec.segment19_High,gcc.segment19))
      AND (gcc.segment20 is NULL or
           gcc.segment20 BETWEEN nvl(mtfr_rec.segment20_Low,gcc.segment20) AND nvl(mtfr_rec.segment20_High,gcc.segment20))
      AND (gcc.segment21 is NULL or
           gcc.segment21 BETWEEN nvl(mtfr_rec.segment21_Low,gcc.segment21) AND nvl(mtfr_rec.segment21_High,gcc.segment21))
      AND (gcc.segment22 is NULL or
           gcc.segment22 BETWEEN nvl(mtfr_rec.segment22_Low,gcc.segment22) AND nvl(mtfr_rec.segment22_High,gcc.segment22))
      AND (gcc.segment23 is NULL or
           gcc.segment23 BETWEEN nvl(mtfr_rec.segment23_Low,gcc.segment23) AND nvl(mtfr_rec.segment23_High,gcc.segment23))
      AND (gcc.segment24 is NULL or
           gcc.segment24 BETWEEN nvl(mtfr_rec.segment24_Low,gcc.segment24) AND nvl(mtfr_rec.segment24_High,gcc.segment24))
      AND (gcc.segment25 is NULL or
           gcc.segment25 BETWEEN nvl(mtfr_rec.segment25_Low,gcc.segment25) AND nvl(mtfr_rec.segment25_High,gcc.segment25))
      AND (gcc.segment26 is NULL or
           gcc.segment26 BETWEEN nvl(mtfr_rec.segment26_Low,gcc.segment26) AND nvl(mtfr_rec.segment26_High,gcc.segment26))
      AND (gcc.segment27 is NULL or
           gcc.segment27 BETWEEN nvl(mtfr_rec.segment27_Low,gcc.segment27) AND nvl(mtfr_rec.segment27_High,gcc.segment27))
      AND (gcc.segment28 is NULL or
           gcc.segment28 BETWEEN nvl(mtfr_rec.segment28_Low,gcc.segment28) AND nvl(mtfr_rec.segment28_High,gcc.segment28))
      AND (gcc.segment29 is NULL or
           gcc.segment29 BETWEEN nvl(mtfr_rec.segment29_Low,gcc.segment29) AND nvl(mtfr_rec.segment29_High,gcc.segment29))
      AND (gcc.segment30 is NULL or
           gcc.segment30 BETWEEN nvl(mtfr_rec.segment30_Low,gcc.segment30) AND nvl(mtfr_rec.segment30_High,gcc.segment30))
      AND faad.asset_id > px_max_asset_id
      AND MOD(faad.asset_id, p_total_requests) = (p_request_number - 1)
      order by faad.asset_id;

Line: 378


               select count(*)
               into l_rowcount
               from per_periods_of_service s, per_people_f p
               where p.person_id = s.person_id
               and trunc(l_trans_date) between
               p.effective_start_date and p.effective_end_date
               and nvl(s.actual_termination_date,l_trans_date) >= l_trans_date
               and p.person_id = l_assigned_to(l_count);

Line: 404


         l_asset_dist_tbl.delete;

Line: 406


         l_trans_rec.who_info.last_update_date   := sysdate;

Line: 407


         l_trans_rec.who_info.last_updated_by    := FND_GLOBAL.USER_ID;

Line: 410


         l_trans_rec.who_info.last_update_login  := FND_GLOBAL.CONC_LOGIN_ID;