APPS.FA_DEPRN_TAX_REP_PKG dependencies on FA_ASSET_HISTORY

Line 308: -- Get total asset untis from FA_ASSET_HISTORY at target_date

304: AND dtn2.year < p_year)
305: group by dtn.year;
306:
307: --
308: -- Get total asset untis from FA_ASSET_HISTORY at target_date
309: CURSOR c_total_units_cost (
310: p_book_type_code VARCHAR2,
311: p_asset_id NUMBER,
312: p_target_date DATE)

Line 317: from FA_ASSET_HISTORY AH,

313:
314: is
315: select AH.UNITS,
316: bk.cost
317: from FA_ASSET_HISTORY AH,
318: FA_BOOKS BK
319: Where AH.ASSET_ID = p_asset_id
320: and AH.ASSET_ID = BK.ASSET_ID
321: and BK.BOOK_TYPE_CODE = p_book_type_code

Line 324: from FA_ASSET_HISTORY AH,

320: and AH.ASSET_ID = BK.ASSET_ID
321: and BK.BOOK_TYPE_CODE = p_book_type_code
322: and AH.DATE_EFFECTIVE =
323: (select max(AH.DATE_EFFECTIVE )
324: from FA_ASSET_HISTORY AH,
325: FA_TRANSACTION_HEADERS TH1,
326: FA_TRANSACTION_HEADERS TH2
327: where AH.ASSET_ID = p_asset_id
328: and AH.TRANSACTION_HEADER_ID_IN =TH1.TRANSACTION_HEADER_ID

Line 385: from FA_ASSET_HISTORY ah1 ,

381:
382: cursor c_ah_max_date_effective(p_asset_id number,
383: p_prior_date date) is
384: SELECT MAX(ah1.date_effective)
385: from FA_ASSET_HISTORY ah1 ,
386: FA_TRANSACTION_HEADERS TH1,
387: FA_TRANSACTION_HEADERS TH2
388: where ah1.asset_id= p_asset_id
389: and ah1.transaction_header_id_in = TH1.transaction_header_id

Line 425: from FA_ASSET_HISTORY ah1

421:
422: cursor c_ah_max_thid_in(p_asset_id number,
423: p_date_effective date) is
424: SELECT MAX(ah1.transaction_header_id_in)
425: from FA_ASSET_HISTORY ah1
426: where ah1.asset_id= p_asset_id
427: and ah1.date_effective = p_date_effective;
428:
429: h_prior_bk_thid_in number;

Line 587: |--------------|FA_ADDITIONS (AD)|----|FA_ASSET_HISTORY (AH) |

583: ,p_log_level_rec => p_log_level_rec)|
584: | +-----------------------------+
585: |
586: | +-----------------+ +----------------------+
587: |--------------|FA_ADDITIONS (AD)|----|FA_ASSET_HISTORY (AH) |
588: | +-----------------+ +----------------------+
589: | | |
590: +--------------+ | | +--------------------+
591: |TEMP VIEW (SM)| | |-|FA_CATEGORIES (CAT

Line 792: FA_ASSET_HISTORY AH,

788: ' From
789: FA_ADDITIONS AD,
790: FA_BOOKS BK,
791: FA_DISTRIBUTION_HISTORY DH,
792: FA_ASSET_HISTORY AH,
793: FA_TRANSACTION_HEADERS THA1,
794: FA_TRANSACTION_HEADERS THA2,
795: FA_TRANSACTION_HEADERS THB1,
796: FA_TRANSACTION_HEADERS THB2,

Line 889: FA_ASSET_HISTORY AH,

885: l_from_nbv :=
886: 'From
887: FA_ADDITIONS AD,
888: FA_BOOKS BK,
889: FA_ASSET_HISTORY AH,
890: FA_CATEGORIES CAT,
891: FA_METHODS MTH,
892: FA_DEPRN_TAX_REP_NBVS NBV
893: ';

Line 988: FA_ASSET_HISTORY AH,

984: BK.ASSET_ID
985: From FA_BOOKS BK,
986: FA_ADDITIONS AD,
987: FA_DISTRIBUTION_HISTORY DH,
988: FA_ASSET_HISTORY AH,
989: FA_LOCATIONS LOC,
990: FA_CATEGORIES CAT,
991: FA_METHODS MTH,
992: FA_TRANSACTION_HEADERS TH1,