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_TRANSACTION_HEADERS

Line 334: FA_TRANSACTION_HEADERS TH1,

330: and BK.BOOK_TYPE_CODE = p_book_type_code
331: and AH.TRANSACTION_HEADER_ID_IN =
332: (select max(AH.TRANSACTION_HEADER_ID_IN )
333: from FA_ASSET_HISTORY AH,
334: FA_TRANSACTION_HEADERS TH1,
335: FA_TRANSACTION_HEADERS TH2
336: where AH.ASSET_ID = p_asset_id
337: and AH.TRANSACTION_HEADER_ID_IN =TH1.TRANSACTION_HEADER_ID
338: and AH.TRANSACTION_HEADER_ID_OUT=TH2.TRANSACTION_HEADER_ID(+)

Line 335: FA_TRANSACTION_HEADERS TH2

331: and AH.TRANSACTION_HEADER_ID_IN =
332: (select max(AH.TRANSACTION_HEADER_ID_IN )
333: from FA_ASSET_HISTORY AH,
334: FA_TRANSACTION_HEADERS TH1,
335: FA_TRANSACTION_HEADERS TH2
336: where AH.ASSET_ID = p_asset_id
337: and AH.TRANSACTION_HEADER_ID_IN =TH1.TRANSACTION_HEADER_ID
338: and AH.TRANSACTION_HEADER_ID_OUT=TH2.TRANSACTION_HEADER_ID(+)
339: and TH1.TRANSACTION_DATE_ENTERED <= p_target_date

Line 346: FA_TRANSACTION_HEADERS TH1,

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
350: and BK.transaction_header_id_in = TH1.transaction_header_id

Line 347: FA_TRANSACTION_HEADERS TH2

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
350: and BK.transaction_header_id_in = TH1.transaction_header_id
351: and bk.transaction_header_id_out= TH2.transaction_header_id (+)

Line 382: FA_TRANSACTION_HEADERS TH1,

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
386: and BK.transaction_header_id_in = TH1.transaction_header_id

Line 383: FA_TRANSACTION_HEADERS TH2

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
386: and BK.transaction_header_id_in = TH1.transaction_header_id
387: and bk.transaction_header_id_out= TH2.transaction_header_id (+)

Line 395: FA_TRANSACTION_HEADERS TH1,

391: cursor c_ah_max_date_effective(p_asset_id number,
392: p_prior_date date) is
393: SELECT MAX(ah1.date_effective)
394: from FA_ASSET_HISTORY ah1 ,
395: FA_TRANSACTION_HEADERS TH1,
396: FA_TRANSACTION_HEADERS TH2
397: where ah1.asset_id= p_asset_id
398: and ah1.transaction_header_id_in = TH1.transaction_header_id
399: and ah1.transaction_header_id_out= TH2.transaction_header_id (+)

Line 396: FA_TRANSACTION_HEADERS TH2

392: p_prior_date date) is
393: SELECT MAX(ah1.date_effective)
394: from FA_ASSET_HISTORY ah1 ,
395: FA_TRANSACTION_HEADERS TH1,
396: FA_TRANSACTION_HEADERS TH2
397: where ah1.asset_id= p_asset_id
398: and ah1.transaction_header_id_in = TH1.transaction_header_id
399: and ah1.transaction_header_id_out= TH2.transaction_header_id (+)
400: and th1.transaction_date_entered <= p_prior_date

Line 641: | |-|FA_TRANSACTION_HEADERS (THD1)|

637: | +----------------------------+
638: | |FA_DISTRIBUTION_HISTORY(DH) |----|
639: | +----------------------------+ |
640: | | +-----------------------------+
641: | |-|FA_TRANSACTION_HEADERS (THD1)|
642: | | +-----------------------------+
643: | |
644: | | +-----------------------------+
645: | |-|FA_TRANSACTION_HEADERS (THD2)|

Line 645: | |-|FA_TRANSACTION_HEADERS (THD2)|

641: | |-|FA_TRANSACTION_HEADERS (THD1)|
642: | | +-----------------------------+
643: | |
644: | | +-----------------------------+
645: | |-|FA_TRANSACTION_HEADERS (THD2)|
646: | +-----------------------------+
647: |
648: | +-----------------+ +----------------------+
649: |--------------|FA_ADDITIONS (AD)|----|FA_ASSET_HISTORY (AH) |

Line 658: | | |-|FA_TRANSACTION_HEADERS (THA1)|

654: +--------------+ | | +--------------------+
655: | | |
656: | | |
657: | | | +-----------------------------+
658: | | |-|FA_TRANSACTION_HEADERS (THA1)|
659: | | | +-----------------------------+
660: | | |
661: | | | +-----------------------------+
662: | | |-|FA_TRANSACTION_HEADERS (THA2)|

Line 662: | | |-|FA_TRANSACTION_HEADERS (THA2)|

658: | | |-|FA_TRANSACTION_HEADERS (THA1)|
659: | | | +-----------------------------+
660: | | |
661: | | | +-----------------------------+
662: | | |-|FA_TRANSACTION_HEADERS (THA2)|
663: | | +-----------------------------+
664: | +-------------+ +-----------------------------+
665: |--------------|FA_BOOKS(BK) |------------|FA_METHODS (MTH) |
666: +-------------+ | +-----------------------------+

Line 668: |------|FA_TRANSACTION_HEADERS (THB1)|

664: | +-------------+ +-----------------------------+
665: |--------------|FA_BOOKS(BK) |------------|FA_METHODS (MTH) |
666: +-------------+ | +-----------------------------+
667: | +-----------------------------+
668: |------|FA_TRANSACTION_HEADERS (THB1)|
669: | +-----------------------------+
670: |
671: | +-----------------------------+
672: |------|FA_TRANSACTION_HEADERS (THB2)|

Line 672: |------|FA_TRANSACTION_HEADERS (THB2)|

668: |------|FA_TRANSACTION_HEADERS (THB1)|
669: | +-----------------------------+
670: |
671: | +-----------------------------+
672: |------|FA_TRANSACTION_HEADERS (THB2)|
673: +-----------------------------+
674:
675: TMEP VIEW(SM) is not database view.
676: And this is BK.COST and DH.UNITS_ASSIGNED

Line 854: FA_TRANSACTION_HEADERS THA1,

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,
856: FA_TRANSACTION_HEADERS THB1,
857: FA_TRANSACTION_HEADERS THB2,
858: FA_TRANSACTION_HEADERS THD1,

Line 855: FA_TRANSACTION_HEADERS THA2,

851: FA_BOOKS BK,
852: FA_DISTRIBUTION_HISTORY DH,
853: FA_ASSET_HISTORY AH,
854: FA_TRANSACTION_HEADERS THA1,
855: FA_TRANSACTION_HEADERS THA2,
856: FA_TRANSACTION_HEADERS THB1,
857: FA_TRANSACTION_HEADERS THB2,
858: FA_TRANSACTION_HEADERS THD1,
859: FA_TRANSACTION_HEADERS THD2,

Line 856: FA_TRANSACTION_HEADERS THB1,

852: FA_DISTRIBUTION_HISTORY DH,
853: FA_ASSET_HISTORY AH,
854: FA_TRANSACTION_HEADERS THA1,
855: FA_TRANSACTION_HEADERS THA2,
856: FA_TRANSACTION_HEADERS THB1,
857: FA_TRANSACTION_HEADERS THB2,
858: FA_TRANSACTION_HEADERS THD1,
859: FA_TRANSACTION_HEADERS THD2,
860: FA_CATEGORIES CAT,

Line 857: FA_TRANSACTION_HEADERS THB2,

853: FA_ASSET_HISTORY AH,
854: FA_TRANSACTION_HEADERS THA1,
855: FA_TRANSACTION_HEADERS THA2,
856: FA_TRANSACTION_HEADERS THB1,
857: FA_TRANSACTION_HEADERS THB2,
858: FA_TRANSACTION_HEADERS THD1,
859: FA_TRANSACTION_HEADERS THD2,
860: FA_CATEGORIES CAT,
861: FA_LOCATIONS LOC,

Line 858: FA_TRANSACTION_HEADERS THD1,

854: FA_TRANSACTION_HEADERS THA1,
855: FA_TRANSACTION_HEADERS THA2,
856: FA_TRANSACTION_HEADERS THB1,
857: FA_TRANSACTION_HEADERS THB2,
858: FA_TRANSACTION_HEADERS THD1,
859: FA_TRANSACTION_HEADERS THD2,
860: FA_CATEGORIES CAT,
861: FA_LOCATIONS LOC,
862: FA_METHODS MTH

Line 859: FA_TRANSACTION_HEADERS THD2,

855: FA_TRANSACTION_HEADERS THA2,
856: FA_TRANSACTION_HEADERS THB1,
857: FA_TRANSACTION_HEADERS THB2,
858: FA_TRANSACTION_HEADERS THD1,
859: FA_TRANSACTION_HEADERS THD2,
860: FA_CATEGORIES CAT,
861: FA_LOCATIONS LOC,
862: FA_METHODS MTH
863: ';

Line 889: FA_TRANSACTION_HEADERS THD3

885: and DH.transaction_header_id_out=THD2.transaction_header_id(+)
886: and AH.ASSET_TYPE <> ''EXPENSED''
887: and NOT EXISTS ( SELECT ''next_trx_ineffective''
888: FROM FA_DISTRIBUTION_HISTORY DH1,
889: FA_TRANSACTION_HEADERS THD3
890: WHERE DH1.BOOK_TYPE_CODE = :p_corp_book
891: and DH1.ASSET_ID = DH.ASSET_ID
892: and DH1.transaction_header_id_in=NVL (DH.transaction_header_id_out ,-111)
893: and NVL (DH1.transaction_header_id_out, -111) = THD3.transaction_header_id

Line 1067: FA_TRANSACTION_HEADERS TH1,

1063: FA_ASSET_HISTORY AH,
1064: FA_LOCATIONS LOC,
1065: FA_CATEGORIES CAT,
1066: FA_METHODS MTH,
1067: FA_TRANSACTION_HEADERS TH1,
1068: FA_TRANSACTION_HEADERS TH2,
1069: FA_TRANSACTION_HEADERS TH_DH1,
1070: FA_TRANSACTION_HEADERS TH_DH2,
1071: FA_TRANSACTION_HEADERS TH_AH1,

Line 1068: FA_TRANSACTION_HEADERS TH2,

1064: FA_LOCATIONS LOC,
1065: FA_CATEGORIES CAT,
1066: FA_METHODS MTH,
1067: FA_TRANSACTION_HEADERS TH1,
1068: FA_TRANSACTION_HEADERS TH2,
1069: FA_TRANSACTION_HEADERS TH_DH1,
1070: FA_TRANSACTION_HEADERS TH_DH2,
1071: FA_TRANSACTION_HEADERS TH_AH1,
1072: FA_TRANSACTION_HEADERS TH_AH2

Line 1069: FA_TRANSACTION_HEADERS TH_DH1,

1065: FA_CATEGORIES CAT,
1066: FA_METHODS MTH,
1067: FA_TRANSACTION_HEADERS TH1,
1068: FA_TRANSACTION_HEADERS TH2,
1069: FA_TRANSACTION_HEADERS TH_DH1,
1070: FA_TRANSACTION_HEADERS TH_DH2,
1071: FA_TRANSACTION_HEADERS TH_AH1,
1072: FA_TRANSACTION_HEADERS TH_AH2
1073: Where AD.ASSET_ID = BK.ASSET_ID

Line 1070: FA_TRANSACTION_HEADERS TH_DH2,

1066: FA_METHODS MTH,
1067: FA_TRANSACTION_HEADERS TH1,
1068: FA_TRANSACTION_HEADERS TH2,
1069: FA_TRANSACTION_HEADERS TH_DH1,
1070: FA_TRANSACTION_HEADERS TH_DH2,
1071: FA_TRANSACTION_HEADERS TH_AH1,
1072: FA_TRANSACTION_HEADERS TH_AH2
1073: Where AD.ASSET_ID = BK.ASSET_ID
1074: and BK.BOOK_TYPE_CODE =:p_book

Line 1071: FA_TRANSACTION_HEADERS TH_AH1,

1067: FA_TRANSACTION_HEADERS TH1,
1068: FA_TRANSACTION_HEADERS TH2,
1069: FA_TRANSACTION_HEADERS TH_DH1,
1070: FA_TRANSACTION_HEADERS TH_DH2,
1071: FA_TRANSACTION_HEADERS TH_AH1,
1072: FA_TRANSACTION_HEADERS TH_AH2
1073: Where AD.ASSET_ID = BK.ASSET_ID
1074: and BK.BOOK_TYPE_CODE =:p_book
1075: and AD.ASSET_TYPE <> ''EXPENSED''

Line 1072: FA_TRANSACTION_HEADERS TH_AH2

1068: FA_TRANSACTION_HEADERS TH2,
1069: FA_TRANSACTION_HEADERS TH_DH1,
1070: FA_TRANSACTION_HEADERS TH_DH2,
1071: FA_TRANSACTION_HEADERS TH_AH1,
1072: FA_TRANSACTION_HEADERS TH_AH2
1073: Where AD.ASSET_ID = BK.ASSET_ID
1074: and BK.BOOK_TYPE_CODE =:p_book
1075: and AD.ASSET_TYPE <> ''EXPENSED''
1076: and AD.ASSET_ID = DH.ASSET_ID

Line 1947: from FA_TRANSACTION_HEADERS

1943: /* Set flag:Transaction ADDTION */
1944: begin
1945: Select distinct 'Y'
1946: into r_addition_flag
1947: from FA_TRANSACTION_HEADERS
1948: where ASSET_ID = h_asset_id
1949: and BOOK_TYPE_CODE =h_book_type_code
1950: and TRANSACTION_DATE_ENTERED >= h_prior_date
1951: and TRANSACTION_DATE_ENTERED <= h_target_date

Line 1955: (Select * from FA_TRANSACTION_HEADERS

1951: and TRANSACTION_DATE_ENTERED <= h_target_date
1952: and (TRANSACTION_TYPE_CODE ='CIP ADDITION'
1953: or (TRANSACTION_TYPE_CODE ='ADDITION'
1954: and not exists
1955: (Select * from FA_TRANSACTION_HEADERS
1956: where ASSET_ID = h_asset_id
1957: and BOOK_TYPE_CODE =h_book_type_code
1958: and TRANSACTION_DATE_ENTERED < h_prior_date
1959: and TRANSACTION_TYPE_CODE ='CIP ADDITION')));

Line 1969: from FA_TRANSACTION_HEADERS

1965: /* Set flag:Transaction Retirement */
1966: begin
1967: Select TRANSACTION_HEADER_ID
1968: into r_ret_id
1969: from FA_TRANSACTION_HEADERS
1970: where ASSET_ID = h_asset_id
1971: and BOOK_TYPE_CODE = h_book_type_code
1972: and TRANSACTION_HEADER_ID =
1973: (select max(TRANSACTION_HEADER_ID)

Line 1974: from FA_TRANSACTION_HEADERS

1970: where ASSET_ID = h_asset_id
1971: and BOOK_TYPE_CODE = h_book_type_code
1972: and TRANSACTION_HEADER_ID =
1973: (select max(TRANSACTION_HEADER_ID)
1974: from FA_TRANSACTION_HEADERS
1975: where ASSET_ID = h_asset_id
1976: and BOOK_TYPE_CODE= h_book_type_code
1977: and TRANSACTION_DATE_ENTERED >= h_prior_date
1978: and TRANSACTION_DATE_ENTERED <= h_target_date

Line 1999: from FA_TRANSACTION_HEADERS

1995: 'NLS_CALENDAR=''Japanese Imperial''')),
1996: TRANSACTION_NAME
1997: into r_transfer_date,
1998: r_trn_transaction_name
1999: from FA_TRANSACTION_HEADERS
2000: where ASSET_ID = h_asset_id
2001: and BOOK_TYPE_CODE = h_corp_book
2002: and TRANSACTION_HEADER_ID =
2003: (select max(TRANSACTION_HEADER_ID)

Line 2004: from FA_TRANSACTION_HEADERS

2000: where ASSET_ID = h_asset_id
2001: and BOOK_TYPE_CODE = h_corp_book
2002: and TRANSACTION_HEADER_ID =
2003: (select max(TRANSACTION_HEADER_ID)
2004: from FA_TRANSACTION_HEADERS
2005: where ASSET_ID = h_asset_id
2006: and BOOK_TYPE_CODE = h_corp_book
2007: and TRANSACTION_DATE_ENTERED >= h_prior_date
2008: and TRANSACTION_DATE_ENTERED <= h_target_date

Line 2019: from FA_TRANSACTION_HEADERS

2015: from FA_DISTRIBUTION_HISTORY FDH,
2016: FA_LOCATIONS LOC
2017: where FDH.ASSET_ID = '||h_asset_id ||'
2018: and FDH.TRANSACTION_HEADER_ID_in in ( select TRANSACTION_HEADER_ID
2019: from FA_TRANSACTION_HEADERS
2020: where ASSET_ID = '|| h_asset_id ||'
2021: and BOOK_TYPE_CODE = '''||h_corp_book ||'''
2022: and TRANSACTION_DATE_ENTERED >= '''|| h_prior_date ||'''
2023: and TRANSACTION_DATE_ENTERED <= '''|| h_target_date ||'''