[Home] [Help]
12: BEGIN
13:
14: SELECT NVL(SUM(fdh.units_assigned),0)
15: INTO ln_units
16: FROM fa_distribution_history fdh
17: WHERE fdh.asset_id = p_asset_id_in
18: AND fdh.book_type_code = P_DIST_SOURCE_BOOK
19: AND fdh.code_combination_id = p_ccid_in
20: AND fdh.transaction_header_id_in =
18: AND fdh.book_type_code = P_DIST_SOURCE_BOOK
19: AND fdh.code_combination_id = p_ccid_in
20: AND fdh.transaction_header_id_in =
21: (SELECT MAX(fdh1.transaction_header_id_in)
22: FROM fa_distribution_history fdh1
23: ,fa_transaction_headers fth1
24: WHERE fdh1.asset_id = p_asset_id_in
25: AND fdh1.book_type_code = P_DIST_SOURCE_BOOK /* why P_BOOK_NAME it should be P_BOOK_TYPE_CODE, both are not synonymous */
26: AND fdh1.code_combination_id = p_ccid_in
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 = (
61: SELECT MAX(fdd1.period_counter)
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
92: AND fdh1.code_combination_id = fdh.code_combination_id
122: INTO ln_amount
123: FROM fa_transaction_headers fth
124: ,fa_adjustments fadj
125: ,fa_asset_history fah
126: ,fa_distribution_history fdh
127: WHERE fth.asset_id = fah.asset_id
128: AND fth.asset_id = fdh.asset_id
129: AND fdh.distribution_id = fadj.distribution_id
130: AND fdh.transaction_header_id_in = p_transaction_header_id
186: FROM fa_books fb
187: ,fa_transaction_headers fth
188: ,fa_adjustments fadj
189: ,fa_asset_history fah
190: ,fa_distribution_history fdh
191: WHERE fth.asset_id = fah.asset_id
192: AND fth.asset_id = fdh.asset_id
193: AND fah.asset_type = p_asset_type_in
194: AND fdh.distribution_id = fadj.distribution_id
241: SELECT NVL(DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount, fadj.adjustment_amount),0) all_transferred
242: FROM fa_transaction_headers fth
243: ,fa_adjustments fadj
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
283: , fadj.adjustment_amount),0)),0) all_transferred
284: FROM fa_transaction_headers fth
285: ,fa_adjustments fadj
286: ,fa_asset_history fah
287: ,fa_distribution_history fdh
288: WHERE fth.asset_id = fah.asset_id
289: AND fth.asset_id = fdh.asset_id
290: AND fdh.distribution_id = fadj.distribution_id
291: AND fdh.transaction_header_id_in = p_transaction_header_id
318: , fadj.adjustment_amount), 0)),0)) all_transferred
319: FROM fa_transaction_headers fth
320: ,fa_adjustments fadj
321: ,fa_asset_history fah
322: ,fa_distribution_history fdh
323: WHERE fth.asset_id = fah.asset_id
324: AND fth.asset_id = fdh.asset_id
325: AND fdh.distribution_id = fadj.distribution_id
326: AND fdh.transaction_header_id_in = p_transaction_header_id
354: FROM fa_transaction_headers fth
355: ,fa_adjustments fadj
356: ,fa_asset_history fah1
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
425: INTO ln_amount
426: FROM fa_transaction_headers fth
427: ,fa_adjustments fadj
428: ,fa_asset_history fah
429: ,fa_distribution_history fdh
430: WHERE fth.asset_id = fah.asset_id
431: AND fth.asset_id = fdh.asset_id
432: AND fdh.distribution_id = fadj.distribution_id
433: AND fdh.transaction_header_id_in = p_transaction_header_id
476: FROM fa_books fb
477: ,fa_transaction_headers fth
478: ,fa_adjustments fadj
479: ,fa_asset_history fah
480: ,fa_distribution_history fdh
481: WHERE fth.asset_id = fah.asset_id
482: AND fth.asset_id = fdh.asset_id
483: AND fdh.distribution_id = fadj.distribution_id
484: AND fdh.transaction_header_id_in = p_transaction_header_id
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
534: AND fdd.distribution_id = fdh.distribution_id
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
550: AND fdd1.distribution_id = fdh1.distribution_id
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
570: AND fds.period_counter = fdd.period_counter
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
590: AND fdd1.distribution_id = fdh1.distribution_id
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
613: AND fdd.distribution_id = fdh.distribution_id
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
629: AND fdd1.distribution_id = fdh1.distribution_id
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
669: AND fdd.distribution_id = fdh.distribution_id
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
712: AND fb.asset_id = fds.asset_id
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,
753: DECODE(fadj.debit_credit_flag,'CR',-1*fadj.adjustment_amount
804: FROM fa_books fb
805: ,fa_transaction_headers fth
806: ,fa_adjustments fadj
807: ,fa_asset_history fah
808: ,fa_distribution_history fdh
809: WHERE fth.asset_id = fah.asset_id
810: AND fth.asset_id = fdh.asset_id
811: AND fah.asset_type = p_asset_type_in
812: AND fdh.distribution_id = fadj.distribution_id