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_TRANSACTION_HEADERS

Line 23: ,fa_transaction_headers fth1

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
27: AND fdh1.transaction_header_id_in = fth1.transaction_header_id

Line 59: ,fa_transaction_headers fth

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)
62: FROM fa_deprn_detail fdd1
63: WHERE fdd1.book_type_code = P_BOOK_NAME

Line 123: FROM fa_transaction_headers fth

119: BEGIN
120: SELECT NVL(SUM(NVL(DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount
121: , fadj.adjustment_amount), 0)),0) additions
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

Line 187: ,fa_transaction_headers fth

183: BEGIN
184: SELECT NVL(SUM(NVL(DECODE(fadj.debit_credit_flag, 'DR',(-1)*fadj.adjustment_amount,fadj.adjustment_amount), 0)),0) retirements
185: INTO ln_amount
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

Line 242: FROM fa_transaction_headers fth

238: SELECT NVL(SUM(x.all_transferred),0)
239: INTO ln_amount
240: FROM (
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 (

Line 284: FROM fa_transaction_headers fth

280: AND fth.transaction_header_id < NVL(fah1.transaction_header_id_out, fth.transaction_header_id + 1)
281: UNION ALL -- Added this query as part of the fix to the SR 7284007.992
282: SELECT NVL(SUM(NVL(DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount
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

Line 319: FROM fa_transaction_headers fth

315: )))
316: UNION ALL
317: SELECT (-1)*(NVL(SUM(NVL(DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount -- Added this query as part of the fix to the SR 7284007.992
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

Line 344: ,fa_transaction_headers fth1

340: AND fdh.location_id = p_location_id_in
341: AND (EXISTS (
342: SELECT 'Y'
343: FROM fa_asset_history fah1
344: ,fa_transaction_headers fth1
345: WHERE fah1.asset_type='CAPITALIZED'
346: AND fah1.transaction_header_id_in = fah.transaction_header_id_out
347: AND fah1.asset_id = fah.asset_id
348: AND fth1.transaction_header_id = fah1.transaction_header_id_in

Line 354: FROM fa_transaction_headers fth

350: AND fth1.transaction_date_entered BETWEEN gd_period_open_date AND gd_period_close_date
351: ))
352: UNION ALL
353: SELECT NVL(DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount, fadj.adjustment_amount),0) all_transferred
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

Line 426: FROM fa_transaction_headers fth

422: BEGIN
423: BEGIN
424: SELECT NVL(SUM(DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount, fadj.adjustment_amount)),0)
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

Line 477: ,fa_transaction_headers fth

473: BEGIN
474: SELECT NVL(SUM(DECODE(fadj.debit_credit_flag, 'CR', -1 * fadj.adjustment_amount, fadj.adjustment_amount)),0)
475: INTO ln_amount
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

Line 756: ,fa_transaction_headers fth

752: ,SUM(DECODE(fth.transaction_subtype,'APPREC',0,
753: DECODE(fadj.debit_credit_flag,'CR',-1*fadj.adjustment_amount
754: ,fadj.adjustment_amount))) adjustment_amount
755: FROM fa_adjustments fadj
756: ,fa_transaction_headers fth
757: WHERE fadj.transaction_header_id = fth.transaction_header_id(+)
758: and fth.transaction_type_code IN ('ADJUSTMENT','ADDITION')
759: and fadj.adjustment_type(+) = 'EXPENSE'
760: and fadj.book_type_code = P_BOOK_NAME

Line 805: ,fa_transaction_headers fth

801: BEGIN
802: SELECT NVL(SUM(NVL(DECODE(fadj.debit_credit_flag, 'DR',(-1)*fadj.adjustment_amount,fadj.adjustment_amount), 0)),0) retirements
803: INTO ln_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