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 325: FA_TRANSACTION_HEADERS TH1,

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
329: and AH.TRANSACTION_HEADER_ID_OUT=TH2.TRANSACTION_HEADER_ID(+)

Line 326: FA_TRANSACTION_HEADERS TH2

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
329: and AH.TRANSACTION_HEADER_ID_OUT=TH2.TRANSACTION_HEADER_ID(+)
330: and TH1.TRANSACTION_DATE_ENTERED <= p_target_date

Line 337: FA_TRANSACTION_HEADERS TH1,

333: )
334: and bk.date_effective =
335: (SELECT MAX(bk.date_effective)
336: from FA_BOOKS bk ,
337: FA_TRANSACTION_HEADERS TH1,
338: FA_TRANSACTION_HEADERS TH2
339: where bk.asset_id= p_asset_id
340: and bk.book_type_code= p_book_type_code
341: and BK.transaction_header_id_in = TH1.transaction_header_id

Line 338: FA_TRANSACTION_HEADERS TH2

334: and bk.date_effective =
335: (SELECT MAX(bk.date_effective)
336: from FA_BOOKS bk ,
337: FA_TRANSACTION_HEADERS TH1,
338: FA_TRANSACTION_HEADERS TH2
339: where bk.asset_id= p_asset_id
340: and bk.book_type_code= p_book_type_code
341: and BK.transaction_header_id_in = TH1.transaction_header_id
342: and bk.transaction_header_id_out= TH2.transaction_header_id (+)

Line 373: FA_TRANSACTION_HEADERS TH1,

369: p_book varchar2,
370: p_prior_date date) is
371: SELECT MAX(bk.date_effective)
372: from FA_BOOKS bk ,
373: FA_TRANSACTION_HEADERS TH1,
374: FA_TRANSACTION_HEADERS TH2
375: where bk.asset_id= p_asset_id
376: and bk.book_type_code= p_book
377: and BK.transaction_header_id_in = TH1.transaction_header_id

Line 374: FA_TRANSACTION_HEADERS TH2

370: p_prior_date date) is
371: SELECT MAX(bk.date_effective)
372: from FA_BOOKS bk ,
373: FA_TRANSACTION_HEADERS TH1,
374: FA_TRANSACTION_HEADERS TH2
375: where bk.asset_id= p_asset_id
376: and bk.book_type_code= p_book
377: and BK.transaction_header_id_in = TH1.transaction_header_id
378: and bk.transaction_header_id_out= TH2.transaction_header_id (+)

Line 386: FA_TRANSACTION_HEADERS TH1,

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
390: and ah1.transaction_header_id_out= TH2.transaction_header_id (+)

Line 387: FA_TRANSACTION_HEADERS TH2

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
390: and ah1.transaction_header_id_out= TH2.transaction_header_id (+)
391: and th1.transaction_date_entered <= p_prior_date

Line 577: | |-|FA_TRANSACTION_HEADERS (THD1

573: | +----------------------------+
574: | |FA_DISTRIBUTION_HISTORY(DH) |----|
575: | +----------------------------+ |
576: | | +-----------------------------+
577: | |-|FA_TRANSACTION_HEADERS (THD1
578: ,p_log_level_rec => p_log_level_rec)|
579: | | +-----------------------------+
580: | |
581: | | +-----------------------------+

Line 582: | |-|FA_TRANSACTION_HEADERS (THD2

578: ,p_log_level_rec => p_log_level_rec)|
579: | | +-----------------------------+
580: | |
581: | | +-----------------------------+
582: | |-|FA_TRANSACTION_HEADERS (THD2
583: ,p_log_level_rec => p_log_level_rec)|
584: | +-----------------------------+
585: |
586: | +-----------------+ +----------------------+

Line 597: | | |-|FA_TRANSACTION_HEADERS (THA1

593: +--------------+ | | +--------------------+
594: | | |
595: | | |
596: | | | +-----------------------------+
597: | | |-|FA_TRANSACTION_HEADERS (THA1
598: ,p_log_level_rec => p_log_level_rec)|
599: | | | +-----------------------------+
600: | | |
601: | | | +-----------------------------+

Line 602: | | |-|FA_TRANSACTION_HEADERS (THA2

598: ,p_log_level_rec => p_log_level_rec)|
599: | | | +-----------------------------+
600: | | |
601: | | | +-----------------------------+
602: | | |-|FA_TRANSACTION_HEADERS (THA2
603: ,p_log_level_rec => p_log_level_rec)|
604: | | +-----------------------------+
605: | +-------------+ +-----------------------------+
606: |--------------|FA_BOOKS(BK) |------------|FA_METHODS (MTH) |

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

605: | +-------------+ +-----------------------------+
606: |--------------|FA_BOOKS(BK) |------------|FA_METHODS (MTH) |
607: +-------------+ | +-----------------------------+
608: | +-----------------------------+
609: |------|FA_TRANSACTION_HEADERS (THB1)|
610: | +-----------------------------+
611: |
612: | +-----------------------------+
613: |------|FA_TRANSACTION_HEADERS (THB2)|

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

609: |------|FA_TRANSACTION_HEADERS (THB1)|
610: | +-----------------------------+
611: |
612: | +-----------------------------+
613: |------|FA_TRANSACTION_HEADERS (THB2)|
614: +-----------------------------+
615:
616: TMEP VIEW(SM) is not database view.
617: And this is BK.COST and DH.UNITS_ASSIGNED

Line 793: FA_TRANSACTION_HEADERS THA1,

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,
797: FA_TRANSACTION_HEADERS THD1,

Line 794: FA_TRANSACTION_HEADERS THA2,

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,
797: FA_TRANSACTION_HEADERS THD1,
798: FA_TRANSACTION_HEADERS THD2,

Line 795: FA_TRANSACTION_HEADERS THB1,

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,
797: FA_TRANSACTION_HEADERS THD1,
798: FA_TRANSACTION_HEADERS THD2,
799: FA_CATEGORIES CAT,

Line 796: FA_TRANSACTION_HEADERS THB2,

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,
797: FA_TRANSACTION_HEADERS THD1,
798: FA_TRANSACTION_HEADERS THD2,
799: FA_CATEGORIES CAT,
800: FA_LOCATIONS LOC,

Line 797: FA_TRANSACTION_HEADERS THD1,

793: FA_TRANSACTION_HEADERS THA1,
794: FA_TRANSACTION_HEADERS THA2,
795: FA_TRANSACTION_HEADERS THB1,
796: FA_TRANSACTION_HEADERS THB2,
797: FA_TRANSACTION_HEADERS THD1,
798: FA_TRANSACTION_HEADERS THD2,
799: FA_CATEGORIES CAT,
800: FA_LOCATIONS LOC,
801: FA_METHODS MTH

Line 798: FA_TRANSACTION_HEADERS THD2,

794: FA_TRANSACTION_HEADERS THA2,
795: FA_TRANSACTION_HEADERS THB1,
796: FA_TRANSACTION_HEADERS THB2,
797: FA_TRANSACTION_HEADERS THD1,
798: FA_TRANSACTION_HEADERS THD2,
799: FA_CATEGORIES CAT,
800: FA_LOCATIONS LOC,
801: FA_METHODS MTH
802: ';

Line 992: FA_TRANSACTION_HEADERS TH1,

988: FA_ASSET_HISTORY AH,
989: FA_LOCATIONS LOC,
990: FA_CATEGORIES CAT,
991: FA_METHODS MTH,
992: FA_TRANSACTION_HEADERS TH1,
993: FA_TRANSACTION_HEADERS TH2,
994: FA_TRANSACTION_HEADERS TH_DH1,
995: FA_TRANSACTION_HEADERS TH_DH2,
996: FA_TRANSACTION_HEADERS TH_AH1,

Line 993: FA_TRANSACTION_HEADERS TH2,

989: FA_LOCATIONS LOC,
990: FA_CATEGORIES CAT,
991: FA_METHODS MTH,
992: FA_TRANSACTION_HEADERS TH1,
993: FA_TRANSACTION_HEADERS TH2,
994: FA_TRANSACTION_HEADERS TH_DH1,
995: FA_TRANSACTION_HEADERS TH_DH2,
996: FA_TRANSACTION_HEADERS TH_AH1,
997: FA_TRANSACTION_HEADERS TH_AH2

Line 994: FA_TRANSACTION_HEADERS TH_DH1,

990: FA_CATEGORIES CAT,
991: FA_METHODS MTH,
992: FA_TRANSACTION_HEADERS TH1,
993: FA_TRANSACTION_HEADERS TH2,
994: FA_TRANSACTION_HEADERS TH_DH1,
995: FA_TRANSACTION_HEADERS TH_DH2,
996: FA_TRANSACTION_HEADERS TH_AH1,
997: FA_TRANSACTION_HEADERS TH_AH2
998: Where AD.ASSET_ID = BK.ASSET_ID

Line 995: FA_TRANSACTION_HEADERS TH_DH2,

991: FA_METHODS MTH,
992: FA_TRANSACTION_HEADERS TH1,
993: FA_TRANSACTION_HEADERS TH2,
994: FA_TRANSACTION_HEADERS TH_DH1,
995: FA_TRANSACTION_HEADERS TH_DH2,
996: FA_TRANSACTION_HEADERS TH_AH1,
997: FA_TRANSACTION_HEADERS TH_AH2
998: Where AD.ASSET_ID = BK.ASSET_ID
999: and BK.BOOK_TYPE_CODE =:p_book

Line 996: FA_TRANSACTION_HEADERS TH_AH1,

992: FA_TRANSACTION_HEADERS TH1,
993: FA_TRANSACTION_HEADERS TH2,
994: FA_TRANSACTION_HEADERS TH_DH1,
995: FA_TRANSACTION_HEADERS TH_DH2,
996: FA_TRANSACTION_HEADERS TH_AH1,
997: FA_TRANSACTION_HEADERS TH_AH2
998: Where AD.ASSET_ID = BK.ASSET_ID
999: and BK.BOOK_TYPE_CODE =:p_book
1000: and AD.ASSET_TYPE <> ''EXPENSED''

Line 997: FA_TRANSACTION_HEADERS TH_AH2

993: FA_TRANSACTION_HEADERS TH2,
994: FA_TRANSACTION_HEADERS TH_DH1,
995: FA_TRANSACTION_HEADERS TH_DH2,
996: FA_TRANSACTION_HEADERS TH_AH1,
997: FA_TRANSACTION_HEADERS TH_AH2
998: Where AD.ASSET_ID = BK.ASSET_ID
999: and BK.BOOK_TYPE_CODE =:p_book
1000: and AD.ASSET_TYPE <> ''EXPENSED''
1001: and AD.ASSET_ID = DH.ASSET_ID

Line 1830: from FA_TRANSACTION_HEADERS

1826: /* Set flag:Transaction ADDTION */
1827: begin
1828: Select distinct 'Y'
1829: into r_addition_flag
1830: from FA_TRANSACTION_HEADERS
1831: where ASSET_ID = h_asset_id
1832: and BOOK_TYPE_CODE =h_book_type_code
1833: and TRANSACTION_DATE_ENTERED >= h_prior_date
1834: and TRANSACTION_DATE_ENTERED <= h_target_date

Line 1838: (Select * from FA_TRANSACTION_HEADERS

1834: and TRANSACTION_DATE_ENTERED <= h_target_date
1835: and (TRANSACTION_TYPE_CODE ='CIP ADDITION'
1836: or (TRANSACTION_TYPE_CODE ='ADDITION'
1837: and not exists
1838: (Select * from FA_TRANSACTION_HEADERS
1839: where ASSET_ID = h_asset_id
1840: and BOOK_TYPE_CODE =h_book_type_code
1841: and TRANSACTION_DATE_ENTERED < h_prior_date
1842: and TRANSACTION_TYPE_CODE ='CIP ADDITION')));

Line 1852: from FA_TRANSACTION_HEADERS

1848: /* Set flag:Transaction Retirement */
1849: begin
1850: Select TRANSACTION_HEADER_ID
1851: into r_ret_id
1852: from FA_TRANSACTION_HEADERS
1853: where ASSET_ID = h_asset_id
1854: and BOOK_TYPE_CODE = h_book_type_code
1855: and TRANSACTION_HEADER_ID =
1856: (select max(TRANSACTION_HEADER_ID)

Line 1857: from FA_TRANSACTION_HEADERS

1853: where ASSET_ID = h_asset_id
1854: and BOOK_TYPE_CODE = h_book_type_code
1855: and TRANSACTION_HEADER_ID =
1856: (select max(TRANSACTION_HEADER_ID)
1857: from FA_TRANSACTION_HEADERS
1858: where ASSET_ID = h_asset_id
1859: and BOOK_TYPE_CODE= h_book_type_code
1860: and TRANSACTION_DATE_ENTERED >= h_prior_date
1861: and TRANSACTION_DATE_ENTERED <= h_target_date

Line 1882: from FA_TRANSACTION_HEADERS

1878: 'NLS_CALENDAR=''Japanese Imperial''')),
1879: TRANSACTION_NAME
1880: into r_transfer_date,
1881: r_trn_transaction_name
1882: from FA_TRANSACTION_HEADERS
1883: where ASSET_ID = h_asset_id
1884: and BOOK_TYPE_CODE = h_corp_book
1885: and TRANSACTION_HEADER_ID =
1886: (select max(TRANSACTION_HEADER_ID)

Line 1887: from FA_TRANSACTION_HEADERS

1883: where ASSET_ID = h_asset_id
1884: and BOOK_TYPE_CODE = h_corp_book
1885: and TRANSACTION_HEADER_ID =
1886: (select max(TRANSACTION_HEADER_ID)
1887: from FA_TRANSACTION_HEADERS
1888: where ASSET_ID = h_asset_id
1889: and BOOK_TYPE_CODE = h_corp_book
1890: and TRANSACTION_DATE_ENTERED >= h_prior_date
1891: and TRANSACTION_DATE_ENTERED <= h_target_date

Line 1901: from FA_TRANSACTION_HEADERS

1897: from FA_DISTRIBUTION_HISTORY FDH,
1898: FA_LOCATIONS LOC
1899: where FDH.ASSET_ID = '||h_asset_id ||'
1900: and FDH.TRANSACTION_HEADER_ID_out in ( select TRANSACTION_HEADER_ID
1901: from FA_TRANSACTION_HEADERS
1902: where ASSET_ID = '|| h_asset_id ||'
1903: and BOOK_TYPE_CODE = '''||h_corp_book ||'''
1904: and TRANSACTION_DATE_ENTERED >= '''|| h_prior_date ||'''
1905: and TRANSACTION_DATE_ENTERED <= '''|| h_target_date ||'''