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.JL_ZZ_FA_FUNCTIONS_PKG dependencies on FA_ADJUSTMENTS

Line 444: FROM fa_adjustments_mrc_v

440: IF p_transaction_type in ('RECLASS','CIP RECLASS') THEN
441: BEGIN
442: SELECT nvl(sum(decode(debit_credit_flag,'DR',adjustment_amount,0)),0)
443: INTO p_adjustment
444: FROM fa_adjustments_mrc_v
445: WHERE book_type_code = p_book_type_code
446: AND asset_id = p_asset_id
447: AND period_counter_created = p_period_counter
448: AND source_type_code = l_source_type_code

Line 458: FROM fa_adjustments_mrc_v

454: ELSE
455: BEGIN
456: SELECT nvl(sum(decode(debit_credit_flag,'DR',adjustment_amount,-1 * adjustment_amount)),0)
457: INTO p_adjustment
458: FROM fa_adjustments_mrc_v
459: WHERE book_type_code = p_book_type_code
460: AND asset_id = p_asset_id
461: AND period_counter_created = p_period_counter
462: AND source_type_code = l_source_type_code

Line 474: FROM fa_adjustments

470: IF p_transaction_type in ('RECLASS','CIP RECLASS') THEN
471: BEGIN
472: SELECT nvl(sum(decode(debit_credit_flag,'DR',adjustment_amount,0)),0)
473: INTO p_adjustment
474: FROM fa_adjustments
475: WHERE book_type_code = p_book_type_code
476: AND asset_id = p_asset_id
477: AND period_counter_created = p_period_counter
478: AND source_type_code = l_source_type_code

Line 488: FROM fa_adjustments

484: ELSE
485: BEGIN
486: SELECT nvl(sum(decode(debit_credit_flag,'DR',adjustment_amount,-1 * adjustment_amount)),0)
487: INTO p_adjustment
488: FROM fa_adjustments
489: WHERE book_type_code = p_book_type_code
490: AND asset_id = p_asset_id
491: AND period_counter_created = p_period_counter
492: AND source_type_code = l_source_type_code