[Home] [Help]
52: fnd_file.put_line(fnd_file.log,'Begin Original Amount::');
53:
54: SELECT NVL(fdd.cost,0)
55: INTO ln_amount
56: FROM fa_deprn_detail fdd
57: ,fa_distribution_history fdh
58: ,fa_asset_history fah
59: ,fa_transaction_headers fth
60: WHERE fdd.period_counter = (
58: ,fa_asset_history fah
59: ,fa_transaction_headers fth
60: WHERE fdd.period_counter = (
61: SELECT MAX(fdd1.period_counter)
62: FROM fa_deprn_detail fdd1
63: WHERE fdd1.book_type_code = P_BOOK_NAME
64: AND fdd1.distribution_id = fdd.distribution_id
65: AND fdd1.asset_id = fdd.asset_id
66: AND fdd1.period_counter < gn_lex_begin_period_counter)
83: AND fah.date_effective < gd_per_open_date))
84: AND fdh.code_combination_id = p_ccid_in
85: AND fdd.distribution_id = (
86: SELECT MAX(fdd1.distribution_id)
87: FROM fa_deprn_detail fdd1
88: ,fa_distribution_history fdh1
89: WHERE fdd1.book_type_code = fdd.book_type_code
90: AND fdd1.asset_id = fdd.asset_id
91: AND fdd1.distribution_id = fdh1.distribution_id
244: ,fa_asset_history fah1
245: ,fa_distribution_history fdh
246: WHERE EXISTS (
247: SELECT 1
248: FROM fa_deprn_detail fdd
249: WHERE fdd.asset_id = fth.asset_id
250: AND fdd.book_type_code = P_BOOK_NAME
251: AND fdd.deprn_source_code = 'D'
252: )
357: ,fa_asset_history fah2
358: ,fa_distribution_history fdh
359: WHERE EXISTS (
360: SELECT 1
361: FROM fa_deprn_detail fdd
362: WHERE fdd.asset_id = fth.asset_id
363: AND fdd.book_type_code = P_BOOK_NAME
364: AND fdd.deprn_source_code = 'D'
365: )
525: BEGIN
526: SELECT NVL(fdd.deprn_reserve,0)
527: INTO ln_amount
528: FROM fa_deprn_summary fds
529: ,fa_deprn_detail fdd
530: ,fa_distribution_history fdh
531: WHERE fds.book_type_code = fdd.book_type_code
532: AND fds.asset_id = fdd.asset_id
533: AND fds.period_counter = fdd.period_counter
541: AND fdh.location_id = p_location_id_in
542: AND fds.period_counter = (
543: SELECT MAX(fds1.period_counter)
544: FROM fa_deprn_summary fds1
545: ,fa_deprn_detail fdd1
546: ,fa_distribution_history fdh1
547: WHERE fds1.book_type_code = fdd1.book_type_code
548: AND fds1.asset_id = fdd1.asset_id
549: AND fds1.period_counter = fdd1.period_counter
561: BEGIN
562: SELECT fdd.deprn_reserve
563: INTO ln_amount
564: FROM fa_deprn_summary fds
565: ,fa_deprn_detail fdd
566: ,fa_distribution_history fdh
567: ,fa_books fb
568: WHERE fds.book_type_code = fdd.book_type_code
569: AND fds.asset_id = fdd.asset_id
581: AND fb.period_counter_life_complete IS NOT NULL
582: AND fds.period_counter = (
583: SELECT MAX(fds1.period_counter)
584: FROM fa_deprn_summary fds1
585: ,fa_deprn_detail fdd1
586: ,fa_distribution_history fdh1
587: WHERE fds1.book_type_code = fdd1.book_type_code
588: AND fds1.asset_id = fdd1.asset_id
589: AND fds1.period_counter = fdd1.period_counter
604: WHEN TOO_MANY_ROWS THEN
605: SELECT NVL(MAX(fdd.deprn_reserve),0)
606: INTO ln_amount
607: FROM fa_deprn_summary fds
608: ,fa_deprn_detail fdd
609: ,fa_distribution_history fdh
610: WHERE fds.book_type_code = fdd.book_type_code
611: AND fds.asset_id = fdd.asset_id
612: AND fds.period_counter = fdd.period_counter
620: AND fdh.location_id = p_location_id_in
621: AND fds.period_counter = (
622: SELECT MAX(fds1.period_counter)
623: FROM fa_deprn_summary fds1
624: ,fa_deprn_detail fdd1
625: ,fa_distribution_history fdh1
626: WHERE fds1.book_type_code = fdd1.book_type_code
627: AND fds1.asset_id = fdd1.asset_id
628: AND fds1.period_counter = fdd1.period_counter
660: BEGIN
661: SELECT NVL(SUM(DECODE(fdd.deprn_source_code,'B',fdd.deprn_reserve,fdd.deprn_amount)),0)
662: INTO ln_amount
663: FROM fa_deprn_summary fds
664: ,fa_deprn_detail fdd
665: ,fa_distribution_history fdh
666: WHERE fds.book_type_code = fdd.book_type_code
667: AND fds.asset_id = fdd.asset_id
668: AND fds.period_counter = fdd.period_counter
703: SELECT NVL(fdd.deprn_reserve,0)
704: INTO ln_amount
705: FROM fa_books fb
706: ,fa_deprn_summary fds
707: ,fa_deprn_detail fdd
708: ,fa_distribution_history fdh
709: WHERE fb.book_type_code = P_BOOK_NAME
710: AND fb.date_ineffective IS NULL
711: AND fb.book_type_code = fds.book_type_code
744: BEGIN
745: BEGIN
746: SELECT NVL(SUM(fdd.deprn_amount - fdd.deprn_adjustment_amount + NVL(fx.adjustment_amount,0)),0)
747: INTO ln_amount
748: FROM fa_deprn_detail fdd
749: ,fa_distribution_history fdh
750: ,(SELECT fadj.distribution_id
751: ,fadj.period_counter_created
752: ,SUM(DECODE(fth.transaction_subtype,'APPREC',0,