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_DEPRN_SUMMARY

Line 537: FROM fa_deprn_summary_mrc_v a

533:
534: BEGIN
535: SELECT NVL(a.deprn_reserve - a.ytd_deprn,0)
536: INTO p_accum_depr_begin_period
537: FROM fa_deprn_summary_mrc_v a
538: WHERE a.book_type_code = p_hist_book_type_code
539: AND a.asset_id = p_asset_id
540: AND a.period_counter between p_period_counter_from AND p_period_counter_to
541: AND a.deprn_source_code = 'BOOKS';

Line 553: FROM fa_deprn_summary_mrc_v a

549: IF p_accum_depr_begin_period = 0 THEN
550: BEGIN
551: SELECT NVL(a.deprn_reserve,0)
552: INTO p_accum_depr_begin_period
553: FROM fa_deprn_summary_mrc_v a
554: WHERE a.book_type_code = p_hist_book_type_code
555: AND a.asset_id = p_asset_id
556: AND a.period_counter in (SELECT max(b.period_counter)
557: FROM fa_deprn_summary_mrc_v b

Line 557: FROM fa_deprn_summary_mrc_v b

553: FROM fa_deprn_summary_mrc_v a
554: WHERE a.book_type_code = p_hist_book_type_code
555: AND a.asset_id = p_asset_id
556: AND a.period_counter in (SELECT max(b.period_counter)
557: FROM fa_deprn_summary_mrc_v b
558: WHERE b.book_type_code = p_hist_book_type_code
559: AND b.asset_id = p_asset_id
560: AND b.period_counter <= p_period_counter_from - 1);
561: EXCEPTION

Line 628: FROM fa_deprn_summary_mrc_v a

624: --
625: BEGIN
626: SELECT NVL(a.deprn_reserve,0)
627: INTO p_hist_accum_depr_end_period
628: FROM fa_deprn_summary_mrc_v a
629: WHERE a.book_type_code = p_hist_book_type_code
630: AND a.asset_id = p_asset_id
631: AND a.period_counter in (SELECT max(b.period_counter)
632: FROM fa_deprn_summary_mrc_v b

Line 632: FROM fa_deprn_summary_mrc_v b

628: FROM fa_deprn_summary_mrc_v a
629: WHERE a.book_type_code = p_hist_book_type_code
630: AND a.asset_id = p_asset_id
631: AND a.period_counter in (SELECT max(b.period_counter)
632: FROM fa_deprn_summary_mrc_v b
633: WHERE b.book_type_code = p_hist_book_type_code
634: AND b.asset_id = p_asset_id
635: AND b.period_counter <= p_period_counter_to);
636: EXCEPTION

Line 644: FROM fa_deprn_summary_mrc_v a

640:
641: BEGIN
642: SELECT NVL(a.deprn_reserve,0)
643: INTO p_adj_accum_depr_end_period
644: FROM fa_deprn_summary_mrc_v a
645: WHERE a.book_type_code = p_adj_book_type_code
646: AND a.asset_id = p_asset_id
647: AND a.period_counter in (SELECT max(b.period_counter)
648: FROM fa_deprn_summary_mrc_v b

Line 648: FROM fa_deprn_summary_mrc_v b

644: FROM fa_deprn_summary_mrc_v a
645: WHERE a.book_type_code = p_adj_book_type_code
646: AND a.asset_id = p_asset_id
647: AND a.period_counter in (SELECT max(b.period_counter)
648: FROM fa_deprn_summary_mrc_v b
649: WHERE b.book_type_code = p_adj_book_type_code
650: AND b.asset_id = p_asset_id
651: AND b.period_counter <= p_period_counter_to);
652: EXCEPTION

Line 665: FROM fa_deprn_summary_mrc_v a

661: p_depr_rpt_period := 0;
662: BEGIN
663: SELECT NVL(a.ytd_deprn,0)
664: INTO l_depr_rpt_period
665: FROM fa_deprn_summary_mrc_v a
666: WHERE a.book_type_code = p_hist_book_type_code
667: AND a.asset_id = p_asset_id
668: AND a.deprn_source_code = 'BOOKS'
669: AND a.period_counter between p_period_counter_from and p_period_counter_to;

Line 681: FROM fa_deprn_summary_mrc_v a

677:
678: BEGIN
679: SELECT NVL(SUM(NVL(a.deprn_amount,0)),0)
680: INTO p_depr_rpt_period
681: FROM fa_deprn_summary_mrc_v a
682: WHERE a.book_type_code = p_hist_book_type_code
683: AND a.asset_id = p_asset_id
684: AND a.deprn_source_code = 'DEPRN'
685: AND a.period_counter between p_period_counter_from and p_period_counter_to;

Line 752: FROM fa_deprn_summary a

748:
749: BEGIN
750: SELECT NVL(a.deprn_reserve - a.ytd_deprn,0)
751: INTO p_accum_depr_begin_period
752: FROM fa_deprn_summary a
753: WHERE a.book_type_code = p_hist_book_type_code
754: AND a.asset_id = p_asset_id
755: AND a.period_counter between p_period_counter_from AND p_period_counter_to
756: AND a.deprn_source_code = 'BOOKS';

Line 773: FROM fa_deprn_summary a

769: IF p_accum_depr_begin_period = 0 THEN
770: BEGIN
771: SELECT NVL(a.deprn_reserve,0)
772: INTO p_accum_depr_begin_period
773: FROM fa_deprn_summary a
774: WHERE a.book_type_code = p_hist_book_type_code
775: AND a.asset_id = p_asset_id
776: AND a.period_counter in (SELECT max(b.period_counter)
777: FROM fa_deprn_summary b

Line 777: FROM fa_deprn_summary b

773: FROM fa_deprn_summary a
774: WHERE a.book_type_code = p_hist_book_type_code
775: AND a.asset_id = p_asset_id
776: AND a.period_counter in (SELECT max(b.period_counter)
777: FROM fa_deprn_summary b
778: WHERE b.book_type_code = p_hist_book_type_code
779: AND b.asset_id = p_asset_id
780: AND b.period_counter <= p_period_counter_from - 1);
781: EXCEPTION

Line 861: FROM fa_deprn_summary a

857: --
858: BEGIN
859: SELECT NVL(a.deprn_reserve,0)
860: INTO p_hist_accum_depr_end_period
861: FROM fa_deprn_summary a
862: WHERE a.book_type_code = p_hist_book_type_code
863: AND a.asset_id = p_asset_id
864: AND a.period_counter in (SELECT max(b.period_counter)
865: FROM fa_deprn_summary b

Line 865: FROM fa_deprn_summary b

861: FROM fa_deprn_summary a
862: WHERE a.book_type_code = p_hist_book_type_code
863: AND a.asset_id = p_asset_id
864: AND a.period_counter in (SELECT max(b.period_counter)
865: FROM fa_deprn_summary b
866: WHERE b.book_type_code = p_hist_book_type_code
867: AND b.asset_id = p_asset_id
868: AND b.period_counter <= p_period_counter_to);
869: EXCEPTION

Line 877: FROM fa_deprn_summary a

873:
874: BEGIN
875: SELECT NVL(a.deprn_reserve,0)
876: INTO p_adj_accum_depr_end_period
877: FROM fa_deprn_summary a
878: WHERE a.book_type_code = p_adj_book_type_code
879: AND a.asset_id = p_asset_id
880: AND a.period_counter in (SELECT max(b.period_counter)
881: FROM fa_deprn_summary b

Line 881: FROM fa_deprn_summary b

877: FROM fa_deprn_summary a
878: WHERE a.book_type_code = p_adj_book_type_code
879: AND a.asset_id = p_asset_id
880: AND a.period_counter in (SELECT max(b.period_counter)
881: FROM fa_deprn_summary b
882: WHERE b.book_type_code = p_adj_book_type_code
883: AND b.asset_id = p_asset_id
884: AND b.period_counter <= p_period_counter_to);
885: EXCEPTION

Line 898: FROM fa_deprn_summary a

894: p_depr_rpt_period := 0;
895: BEGIN
896: SELECT NVL(a.ytd_deprn,0)
897: INTO l_depr_rpt_period
898: FROM fa_deprn_summary a
899: WHERE a.book_type_code = p_hist_book_type_code
900: AND a.asset_id = p_asset_id
901: AND a.deprn_source_code = 'BOOKS'
902: AND a.period_counter between p_period_counter_from and p_period_counter_to;

Line 914: FROM fa_deprn_summary a

910:
911: BEGIN
912: SELECT NVL(SUM(NVL(a.deprn_amount,0)),0)
913: INTO p_depr_rpt_period
914: FROM fa_deprn_summary a
915: WHERE a.book_type_code = p_hist_book_type_code
916: AND a.asset_id = p_asset_id
917: AND a.deprn_source_code = 'DEPRN'
918: AND a.period_counter between p_period_counter_from and p_period_counter_to;