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.IGI_IAC_REVAL_UTILITIES dependencies on FA_DEPRN_PERIODS

Line 482: from fa_deprn_summary fds, fa_deprn_periods fdp

478:
479: cursor c_deprn_asset is
480: select fds.asset_id, fds.book_type_code, fds.period_counter + 1, abs(fds.ytd_deprn) ytd_deprn, fdp.fiscal_year
481: , fadd.current_units total_units
482: from fa_deprn_summary fds, fa_deprn_periods fdp
483: , fa_additions fadd
484: where fds.book_type_code = fp_book_type_code
485: and fdp.book_type_code = fds.book_type_code
486: and fdp.period_counter = fds.period_counter

Line 515: from fa_deprn_periods fdp

511: nvl(fdh.units_assigned,0) + nvl(fdh.transaction_units,0) units_active,
512: 'ACTIVE' status,
513: (fdh.units_assigned/fadd.current_units) ytd_prorate_factor,
514: (fdh.units_assigned/fadd.current_units) normal_prorate_factor
515: from fa_deprn_periods fdp
516: , fa_distribution_history fdh
517: , fa_additions fadd
518: , fa_transaction_headers fth
519: where fth.book_type_code = cp_book_type_code

Line 552: , fa_deprn_periods fdp

548: 'ACTIVE' status,
549: (fdh.units_assigned/cp_total_units) ytd_prorate_factor,
550: (fdh.units_assigned/cp_total_units) normal_prorate_factor
551: from fa_deprn_detail fdd
552: , fa_deprn_periods fdp
553: , fa_distribution_history fdh
554: where fdd.book_type_code = cp_book_type_code
555: and fdp.book_type_code = fdd.book_type_code
556: and fdp.period_counter = fdd.period_counter

Line 648: fa_deprn_periods fdp

644: nvl(fdh.units_assigned,0) + nvl(fdh.transaction_units,0) units_active,
645: fdp.period_counter period_counter_created,
646: fdp.fiscal_year fiscal_year
647: FROM fa_distribution_history fdh,
648: fa_deprn_periods fdp
649: WHERE fdh.book_type_code = fp_book_type_code
650: AND fdh.asset_id = fp_asset_id
651: AND fdh.transaction_header_id_out IS NULL
652: AND fdp.book_type_code = fp_book_type_code

Line 843: fa_deprn_periods fdp

839: fdp.period_counter period_counter_created,
840: Null period_counter_closed ,
841: fdp.fiscal_year fiscal_year,'Y' Active_flag
842: FROM fa_distribution_history fdh,
843: fa_deprn_periods fdp
844: WHERE fdh.book_type_code = fp_book_type_code
845: AND fdh.asset_id = fp_asset_id
846: AND fdh.transaction_header_id_out IS NULL
847: AND fdp.book_type_code = fp_book_type_code

Line 857: fa_deprn_periods fdp1,

853: fdp2.period_counter period_counter_created,
854: fdp3.period_counter period_counter_closed,
855: fdp2.fiscal_year fiscal_year,'N' Active_flag
856: FROM fa_distribution_history fdh,
857: fa_deprn_periods fdp1,
858: fa_deprn_periods fdp2,
859: fa_deprn_periods fdp3
860: WHERE fdh.book_type_code = fp_book_type_code
861: AND fdh.asset_id = fp_asset_id

Line 858: fa_deprn_periods fdp2,

854: fdp3.period_counter period_counter_closed,
855: fdp2.fiscal_year fiscal_year,'N' Active_flag
856: FROM fa_distribution_history fdh,
857: fa_deprn_periods fdp1,
858: fa_deprn_periods fdp2,
859: fa_deprn_periods fdp3
860: WHERE fdh.book_type_code = fp_book_type_code
861: AND fdh.asset_id = fp_asset_id
862: AND fdh.transaction_header_id_out IS Not NULL

Line 859: fa_deprn_periods fdp3

855: fdp2.fiscal_year fiscal_year,'N' Active_flag
856: FROM fa_distribution_history fdh,
857: fa_deprn_periods fdp1,
858: fa_deprn_periods fdp2,
859: fa_deprn_periods fdp3
860: WHERE fdh.book_type_code = fp_book_type_code
861: AND fdh.asset_id = fp_asset_id
862: AND fdh.transaction_header_id_out IS Not NULL
863: AND fdp1.book_type_code = fdh.book_type_code

Line 865: from fa_deprn_periods fdep

861: AND fdh.asset_id = fp_asset_id
862: AND fdh.transaction_header_id_out IS Not NULL
863: AND fdp1.book_type_code = fdh.book_type_code
864: AND fdp1.period_counter = (select min(period_counter)
865: from fa_deprn_periods fdep
866: where book_type_code = fp_book_type_code
867: and fiscal_year=cp_fiscal_year)
868: AND fdp2.book_type_code = fdh.book_type_code
869: AND fdh.date_effective between fdp2.period_open_date and nvl(fdp2.period_close_date,fdh.date_effective)

Line 1391: From fa_deprn_periods

1387: END IF;
1388:
1389: Select calendar_period_close_date
1390: into l_validation_date
1391: From fa_deprn_periods
1392: where book_type_code = p_book_type_code
1393: and period_counter = p_period_counter;
1394:
1395: l_result := FAFLEX_PKG_WF.START_PROCESS(