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_DEPRN_TAX_REP_PKG dependencies on FA_BOOKS

Line 327: FA_BOOKS BK

323: is
324: select AH.UNITS,
325: bk.cost
326: from FA_ASSET_HISTORY AH,
327: FA_BOOKS BK
328: Where AH.ASSET_ID = p_asset_id
329: and AH.ASSET_ID = BK.ASSET_ID
330: and BK.BOOK_TYPE_CODE = p_book_type_code
331: and AH.TRANSACTION_HEADER_ID_IN =

Line 345: from FA_BOOKS bk ,

341: > p_target_date
342: )
343: and bk.TRANSACTION_HEADER_ID_IN =
344: (SELECT MAX(bk.TRANSACTION_HEADER_ID_IN)
345: from FA_BOOKS bk ,
346: FA_TRANSACTION_HEADERS TH1,
347: FA_TRANSACTION_HEADERS TH2
348: where bk.asset_id= p_asset_id
349: and bk.book_type_code= p_book_type_code

Line 381: from FA_BOOKS bk ,

377: cursor c_bk_max_date_effective(p_asset_id number,
378: p_book varchar2,
379: p_prior_date date) is
380: SELECT MAX(bk.date_effective)
381: from FA_BOOKS bk ,
382: FA_TRANSACTION_HEADERS TH1,
383: FA_TRANSACTION_HEADERS TH2
384: where bk.asset_id= p_asset_id
385: and bk.book_type_code= p_book

Line 426: from FA_BOOKS bk

422: cursor c_bk_max_thid_in(p_asset_id number,
423: p_book varchar2,
424: p_date_effective date) is
425: SELECT MAX(bk.transaction_header_id_in)
426: from FA_BOOKS bk
427: where bk.asset_id= p_asset_id
428: and bk.book_type_code= p_book
429: and bk.date_effective = p_date_effective;
430:

Line 665: |--------------|FA_BOOKS(BK) |------------|FA_METHODS (MTH) |

661: | | | +-----------------------------+
662: | | |-|FA_TRANSACTION_HEADERS (THA2)|
663: | | +-----------------------------+
664: | +-------------+ +-----------------------------+
665: |--------------|FA_BOOKS(BK) |------------|FA_METHODS (MTH) |
666: +-------------+ | +-----------------------------+
667: | +-----------------------------+
668: |------|FA_TRANSACTION_HEADERS (THB1)|
669: | +-----------------------------+

Line 851: FA_BOOKS BK,

847:
848: l_from_stmt :=
849: ' From
850: FA_ADDITIONS AD,
851: FA_BOOKS BK,
852: FA_DISTRIBUTION_HISTORY DH,
853: FA_ASSET_HISTORY AH,
854: FA_TRANSACTION_HEADERS THA1,
855: FA_TRANSACTION_HEADERS THA2,

Line 963: FA_BOOKS BK,

959:
960: l_from_nbv :=
961: 'From
962: FA_ADDITIONS AD,
963: FA_BOOKS BK,
964: FA_ASSET_HISTORY AH,
965: FA_CATEGORIES CAT,
966: FA_METHODS MTH,
967: FA_DEPRN_TAX_REP_NBVS NBV

Line 1060: From FA_BOOKS BK,

1056: /* Changed sub_sql to check the state range */
1057: l_sub_sql :=
1058: 'Select distinct
1059: BK.ASSET_ID
1060: From FA_BOOKS BK,
1061: FA_ADDITIONS AD,
1062: FA_DISTRIBUTION_HISTORY DH,
1063: FA_ASSET_HISTORY AH,
1064: FA_LOCATIONS LOC,

Line 1432: -- Set asset cost and Units from FA_BOOKS at prior date

1428: fetch c_total_units_cost into l_total_prior_units, l_total_prior_cost;
1429: close c_total_units_cost;
1430:
1431: /*
1432: -- Set asset cost and Units from FA_BOOKS at prior date
1433: l_total_prior_cost := h_prior_total_cost;
1434: l_total_prior_units := h_prior_total_units;
1435:
1436: -- Set asset cost from FA_BOOKS at target date

Line 1436: -- Set asset cost from FA_BOOKS at target date

1432: -- Set asset cost and Units from FA_BOOKS at prior date
1433: l_total_prior_cost := h_prior_total_cost;
1434: l_total_prior_units := h_prior_total_units;
1435:
1436: -- Set asset cost from FA_BOOKS at target date
1437: l_total_cost := h_total_cost;
1438: l_total_units := h_total_units;
1439: */
1440: