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_BALREP_PKG dependencies on FA_BOOKS_MRC_V

Line 464: FROM fa_books_mrc_v bks

460: aj.adjustment_amount) <> 0
461: -- start of cua
462: AND NOT EXISTS
463: (SELECT 'x'
464: FROM fa_books_mrc_v bks
465: WHERE bks.book_type_code = book
466: AND bks.asset_id = aj.asset_id
467: AND bks.group_asset_id IS NOT NULL
468: AND bks.date_ineffective IS NOT NULL)

Line 520: FROM fa_books_mrc_v bks

516: aj.adjustment_amount) <> 0
517: -- start of cua
518: AND NOT EXISTS
519: (SELECT 'x'
520: FROM fa_books_mrc_v bks
521: WHERE bks.book_type_code = book
522: AND bks.asset_id = aj.asset_id
523: AND bks.group_asset_id IS NOT NULL
524: AND bks.date_ineffective IS NOT NULL)

Line 846: fa_books_mrc_v bk,

842: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
843: aj.adjustment_amount),
844: h_request_id
845: FROM fa_adjustments_mrc_v aj,
846: fa_books_mrc_v bk,
847: fa_group_asset_default gad,
848: fa_deprn_periods dp
849: WHERE bk.asset_id = aj.asset_id
850: AND bk.book_type_code = book

Line 856: FROM fa_books_mrc_v

852: AND bk.book_type_code = gad.book_type_code
853: AND bk.date_ineffective IS NULL
854: AND aj.asset_id IN
855: (SELECT asset_id
856: FROM fa_books_mrc_v
857: WHERE group_asset_id IS NOT NULL
858: AND date_ineffective IS NULL)
859: AND aj.asset_id = bk.asset_id
860: AND aj.asset_id BETWEEN start_range AND end_range --anuj

Line 896: fa_books_mrc_v bk,

892: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
893: aj.adjustment_amount),
894: h_request_id
895: FROM fa_adjustments_mrc_v aj,
896: fa_books_mrc_v bk,
897: fa_group_asset_default gad,
898: fa_deprn_periods dp
899: /* SLA Changes */,
900: xla_ae_headers headers,

Line 911: FROM fa_books_mrc_v

907: AND bk.date_ineffective IS NULL
908: AND aj.asset_id BETWEEN start_range AND end_range --anuj
909: AND aj.asset_id IN
910: (SELECT asset_id
911: FROM fa_books_mrc_v
912: WHERE group_asset_id IS NOT NULL
913: AND date_ineffective IS NULL)
914: AND aj.asset_id = bk.asset_id
915: AND aj.book_type_code = book

Line 1178: fa_books_mrc_v bk

1174: FROM fa_distribution_history dh,
1175: fa_deprn_detail_mrc_v dd,
1176: fa_asset_history ah,
1177: fa_category_books cb,
1178: fa_books_mrc_v bk
1179: WHERE dh.book_type_code = distribution_source_book
1180: AND decode(dd.deprn_source_code, 'D', p_date, a_date) BETWEEN
1181: dh.date_effective AND nvl(dh.date_ineffective, SYSDATE)
1182: AND dd.asset_id = dh.asset_id

Line 1493: fa_books_mrc_v bk

1489: FROM fa_distribution_history dh,
1490: fa_deprn_detail_mrc_v dd,
1491: fa_asset_history ah,
1492: fa_category_books cb,
1493: fa_books_mrc_v bk
1494: WHERE dh.book_type_code = distribution_source_book
1495: AND decode(dd.deprn_source_code, 'D', p_date, a_date) BETWEEN
1496: dh.date_effective AND nvl(dh.date_ineffective, SYSDATE)
1497: AND dd.asset_id BETWEEN start_range AND end_range --Anuj

Line 1754: FROM fa_books_mrc_v bk,

1750: dd.deprn_reserve,
1751: 'REVAL RESERVE',
1752: dd.reval_reserve),
1753: h_request_id
1754: FROM fa_books_mrc_v bk,
1755: fa_category_books cb,
1756: fa_asset_history ah,
1757: fa_deprn_detail_mrc_v dd,
1758: fa_distribution_history dh,

Line 1799: FROM fa_books_groups_mrc_v bg, fa_books_mrc_v fab

1795: AND
1796: -- Commented by Prabakar
1797: (bk.transaction_header_id_in =
1798: (SELECT MIN(fab.transaction_header_id_in)
1799: FROM fa_books_groups_mrc_v bg, fa_books_mrc_v fab
1800: WHERE bg.group_asset_id = nvl(bk.group_asset_id, -2)
1801: AND bg.book_type_code = fab.book_type_code
1802: AND fab.transaction_header_id_in <=
1803: bg.transaction_header_id_in

Line 2110: FROM fa_books_mrc_v bk,

2106: dd.deprn_reserve,
2107: 'REVAL RESERVE',
2108: dd.reval_reserve),
2109: h_request_id
2110: FROM fa_books_mrc_v bk,
2111: fa_category_books cb,
2112: fa_asset_history ah,
2113: fa_deprn_detail_mrc_v dd,
2114: fa_distribution_history dh,

Line 2154: FROM fa_books_groups_mrc_v bg, fa_books_mrc_v fab

2150: AND
2151: -- Commented by Prabakar
2152: (bk.transaction_header_id_in =
2153: (SELECT MIN(fab.transaction_header_id_in)
2154: FROM fa_books_groups_mrc_v bg, fa_books_mrc_v fab
2155: WHERE bg.group_asset_id = nvl(bk.group_asset_id, -2)
2156: AND bg.book_type_code = fab.book_type_code
2157: AND fab.transaction_header_id_in <=
2158: bg.transaction_header_id_in