[Home] [Help]
112: fnd_file.put_line(fnd_file.log,'Begin Original Amount::');
113:
114: SELECT NVL(fdd.cost,0)
115: INTO ln_amount
116: FROM fa_deprn_detail fdd
117: ,fa_distribution_history fdh
118: ,fa_asset_history fah
119: ,fa_transaction_headers fth
120: WHERE fdd.period_counter = (
118: ,fa_asset_history fah
119: ,fa_transaction_headers fth
120: WHERE fdd.period_counter = (
121: SELECT MAX(fdd1.period_counter)
122: FROM fa_deprn_detail fdd1
123: WHERE fdd1.book_type_code = P_BOOK_NAME
124: AND fdd1.distribution_id = fdd.distribution_id
125: AND fdd1.asset_id = fdd.asset_id
126: AND fdd1.period_counter < gn_lex_begin_period_counter)
143: AND fah.date_effective < gd_per_open_date))
144: AND fdh.code_combination_id = p_ccid_in
145: AND fdd.distribution_id = (
146: SELECT MAX(fdd1.distribution_id)
147: FROM fa_deprn_detail fdd1
148: ,fa_distribution_history fdh1
149: WHERE fdd1.book_type_code = fdd.book_type_code
150: AND fdd1.asset_id = fdd.asset_id
151: AND fdd1.distribution_id = fdh1.distribution_id
295: ,fa_asset_history fah1
296: ,fa_distribution_history fdh
297: WHERE EXISTS (
298: SELECT 1
299: FROM fa_deprn_detail fdd
300: WHERE fdd.asset_id = fth.asset_id
301: AND fdd.book_type_code = P_BOOK_NAME
302: AND fdd.deprn_source_code = 'D'
303: )
337: ,fa_asset_history fah2
338: ,fa_distribution_history fdh
339: WHERE EXISTS (
340: SELECT 1
341: FROM fa_deprn_detail fdd
342: WHERE fdd.asset_id = fth.asset_id
343: AND fdd.book_type_code = P_BOOK_NAME
344: AND fdd.deprn_source_code = 'D'
345: )
505: BEGIN
506: SELECT fdd.deprn_reserve
507: INTO ln_amount
508: FROM fa_deprn_summary fds
509: ,fa_deprn_detail fdd
510: ,fa_distribution_history fdh
511: WHERE fds.book_type_code = fdd.book_type_code
512: AND fds.asset_id = fdd.asset_id
513: AND fds.period_counter = fdd.period_counter
521: AND fdh.location_id = p_location_id_in
522: AND fds.period_counter = (
523: SELECT MAX(fds1.period_counter)
524: FROM fa_deprn_summary fds1
525: ,fa_deprn_detail fdd1
526: ,fa_distribution_history fdh1
527: WHERE fds1.book_type_code = fdd1.book_type_code
528: AND fds1.asset_id = fdd1.asset_id
529: AND fds1.period_counter = fdd1.period_counter
541: BEGIN
542: SELECT fdd.deprn_reserve
543: INTO ln_amount
544: FROM fa_deprn_summary fds
545: ,fa_deprn_detail fdd
546: ,fa_distribution_history fdh
547: ,fa_books fb
548: WHERE fds.book_type_code = fdd.book_type_code
549: AND fds.asset_id = fdd.asset_id
561: AND fb.period_counter_life_complete IS NOT NULL
562: AND fds.period_counter = (
563: SELECT MAX(fds1.period_counter)
564: FROM fa_deprn_summary fds1
565: ,fa_deprn_detail fdd1
566: ,fa_distribution_history fdh1
567: WHERE fds1.book_type_code = fdd1.book_type_code
568: AND fds1.asset_id = fdd1.asset_id
569: AND fds1.period_counter = fdd1.period_counter
584: WHEN TOO_MANY_ROWS THEN
585: SELECT MAX(fdd.deprn_reserve)
586: INTO ln_amount
587: FROM fa_deprn_summary fds
588: ,fa_deprn_detail fdd
589: ,fa_distribution_history fdh
590: WHERE fds.book_type_code = fdd.book_type_code
591: AND fds.asset_id = fdd.asset_id
592: AND fds.period_counter = fdd.period_counter
600: AND fdh.location_id = p_location_id_in
601: AND fds.period_counter = (
602: SELECT MAX(fds1.period_counter)
603: FROM fa_deprn_summary fds1
604: ,fa_deprn_detail fdd1
605: ,fa_distribution_history fdh1
606: WHERE fds1.book_type_code = fdd1.book_type_code
607: AND fds1.asset_id = fdd1.asset_id
608: AND fds1.period_counter = fdd1.period_counter
639: BEGIN
640: SELECT SUM(DECODE(fdd.deprn_source_code,'B',fdd.deprn_reserve,fdd.deprn_amount))
641: INTO ln_amount
642: FROM fa_deprn_summary fds
643: ,fa_deprn_detail fdd
644: ,fa_distribution_history fdh
645: WHERE fds.book_type_code = fdd.book_type_code
646: AND fds.asset_id = fdd.asset_id
647: AND fds.period_counter = fdd.period_counter
681: SELECT fdd.deprn_reserve
682: INTO ln_amount
683: FROM fa_books fb
684: ,fa_deprn_summary fds
685: ,fa_deprn_detail fdd
686: ,fa_distribution_history fdh
687: WHERE fb.book_type_code = P_BOOK_NAME
688: AND fb.date_ineffective IS NULL
689: AND fb.book_type_code = fds.book_type_code
721: BEGIN
722: BEGIN
723: SELECT SUM(fdd.deprn_amount - fdd.deprn_adjustment_amount + NVL(fx.adjustment_amount,0))
724: INTO ln_amount
725: FROM fa_deprn_detail fdd
726: ,fa_distribution_history fdh
727: ,(SELECT fadj.distribution_id
728: ,fadj.period_counter_created
729: ,SUM(DECODE(fth.transaction_subtype,'APPREC',0,