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.FA_ASSET_SUMM_RPT_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 79: FROM fa_distribution_history fdh

75: BEGIN
76:
77: SELECT NVL(SUM(fdh.units_assigned),0)
78: INTO ln_units
79: FROM fa_distribution_history fdh
80: WHERE fdh.asset_id = p_asset_id_in
81: AND fdh.book_type_code = P_BOOK_NAME
82: AND fdh.code_combination_id = p_ccid_in
83: AND fdh.transaction_header_id_in =

Line 85: FROM fa_distribution_history fdh1

81: AND fdh.book_type_code = P_BOOK_NAME
82: AND fdh.code_combination_id = p_ccid_in
83: AND fdh.transaction_header_id_in =
84: (SELECT MAX(fdh1.transaction_header_id_in)
85: FROM fa_distribution_history fdh1
86: ,fa_transaction_headers fth1
87: WHERE fdh1.asset_id = p_asset_id_in
88: AND fdh1.book_type_code = P_BOOK_NAME
89: AND fdh1.code_combination_id = p_ccid_in

Line 117: ,fa_distribution_history fdh

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 = (
121: SELECT MAX(fdd1.period_counter)

Line 148: ,fa_distribution_history fdh1

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
152: AND fdh1.code_combination_id = fdh.code_combination_id

Line 185: ,fa_distribution_history fdh

181: INTO ln_amount
182: FROM fa_transaction_headers fth
183: ,fa_adjustments fadj
184: ,fa_asset_history fah
185: ,fa_distribution_history fdh
186: WHERE fth.asset_id = fah.asset_id
187: AND fth.asset_id = fdh.asset_id
188: AND fdh.distribution_id = fadj.distribution_id
189: AND fdh.transaction_header_id_in = p_transaction_header_id

Line 242: ,fa_distribution_history fdh

238: FROM fa_books fb
239: ,fa_transaction_headers fth
240: ,fa_adjustments fadj
241: ,fa_asset_history fah
242: ,fa_distribution_history fdh
243: WHERE fth.asset_id = fah.asset_id
244: AND fth.asset_id = fdh.asset_id
245: AND fah.asset_type = p_asset_type_in
246: AND fdh.distribution_id = fadj.distribution_id

Line 296: ,fa_distribution_history fdh

292: SELECT DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount, fadj.adjustment_amount) all_transferred
293: FROM fa_transaction_headers fth
294: ,fa_adjustments fadj
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

Line 338: ,fa_distribution_history fdh

334: FROM fa_transaction_headers fth
335: ,fa_adjustments fadj
336: ,fa_asset_history fah1
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

Line 411: ,fa_distribution_history fdh

407: INTO ln_amount
408: FROM fa_transaction_headers fth
409: ,fa_adjustments fadj
410: ,fa_asset_history fah
411: ,fa_distribution_history fdh
412: WHERE fth.asset_id = fah.asset_id
413: AND fth.asset_id = fdh.asset_id
414: AND fdh.distribution_id = fadj.distribution_id
415: AND fdh.transaction_header_id_in = p_transaction_header_id

Line 461: ,fa_distribution_history fdh

457: FROM fa_books fb
458: ,fa_transaction_headers fth
459: ,fa_adjustments fadj
460: ,fa_asset_history fah
461: ,fa_distribution_history fdh
462: WHERE fth.asset_id = fah.asset_id
463: AND fth.asset_id = fdh.asset_id
464: AND fdh.distribution_id = fadj.distribution_id
465: AND fdh.transaction_header_id_in = p_transaction_header_id

Line 510: ,fa_distribution_history fdh

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
514: AND fdd.distribution_id = fdh.distribution_id

Line 526: ,fa_distribution_history fdh1

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
530: AND fdd1.distribution_id = fdh1.distribution_id

Line 546: ,fa_distribution_history fdh

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
550: AND fds.period_counter = fdd.period_counter

Line 566: ,fa_distribution_history fdh1

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
570: AND fdd1.distribution_id = fdh1.distribution_id

Line 589: ,fa_distribution_history fdh

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
593: AND fdd.distribution_id = fdh.distribution_id

Line 605: ,fa_distribution_history fdh1

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
609: AND fdd1.distribution_id = fdh1.distribution_id

Line 644: ,fa_distribution_history fdh

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
648: AND fdd.distribution_id = fdh.distribution_id

Line 686: ,fa_distribution_history fdh

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
690: AND fb.asset_id = fds.asset_id

Line 726: ,fa_distribution_history fdh

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,
730: DECODE(fadj.debit_credit_flag,'CR',-1*fadj.adjustment_amount

Line 784: ,fa_distribution_history fdh

780: FROM fa_books fb
781: ,fa_transaction_headers fth
782: ,fa_adjustments fadj
783: ,fa_asset_history fah
784: ,fa_distribution_history fdh
785: WHERE fth.asset_id = fah.asset_id
786: AND fth.asset_id = fdh.asset_id
787: AND fah.asset_type = p_asset_type_in
788: AND fdh.distribution_id = fadj.distribution_id