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

Line 40: FROM fa_books

36: max(asset_id),
37: 1,
38: 'UNASSIGNED',
39: p_request_id
40: FROM fa_books
41: WHERE book_type_code = p_book_type_code
42: AND transaction_header_id_out is null;
43:
44: EXCEPTION

Line 55: FROM fa_books bk

51: SELECT MIN(asset_id), MAX(asset_id), 0, 'UNASSIGNED', p_request_id
52: FROM (SELECT /*+ parallel(BK) */
53: asset_id,
54: floor(rank() over(ORDER BY asset_id) / l_batch_size) unit_id
55: FROM fa_books bk
56: WHERE bk.book_type_code = p_book_type_code
57: AND bk.transaction_header_id_out IS NULL)
58: GROUP BY unit_id;
59:

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 595: FROM fa_books bks

591: aj.adjustment_amount) <> 0
592: -- start of cua
593: AND NOT EXISTS
594: (SELECT 'x'
595: FROM fa_books bks
596: WHERE bks.book_type_code = book
597: AND bks.asset_id = aj.asset_id
598: AND bks.group_asset_id IS NOT NULL
599: AND bks.date_ineffective IS NOT NULL)

Line 651: FROM fa_books bks

647: aj.adjustment_amount) <> 0
648: -- start of cua
649: AND NOT EXISTS
650: (SELECT 'x'
651: FROM fa_books bks
652: WHERE bks.book_type_code = book
653: AND bks.asset_id = aj.asset_id
654: AND bks.group_asset_id IS NOT NULL
655: 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 971: fa_books bk,

967: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
968: aj.adjustment_amount),
969: h_request_id
970: FROM fa_adjustments aj,
971: fa_books bk,
972: fa_group_asset_default gad,
973: fa_deprn_periods dp
974: WHERE bk.asset_id = aj.asset_id
975: AND bk.book_type_code = book

Line 982: FROM fa_books

978: AND bk.book_type_code = gad.book_type_code
979: AND bk.date_ineffective IS NULL
980: AND aj.asset_id IN
981: (SELECT asset_id
982: FROM fa_books
983: WHERE group_asset_id IS NOT NULL
984: AND date_ineffective IS NULL)
985: AND aj.asset_id = bk.asset_id
986: AND aj.book_type_code = book

Line 1021: fa_books bk,

1017: SUM(decode(aj.debit_credit_flag, balance_type, 1, -1) *
1018: aj.adjustment_amount),
1019: h_request_id
1020: FROM fa_adjustments aj,
1021: fa_books bk,
1022: fa_group_asset_default gad,
1023: fa_deprn_periods dp
1024:
1025: /* SLA Changes */,

Line 1037: FROM fa_books

1033: AND bk.book_type_code = gad.book_type_code
1034: AND bk.date_ineffective IS NULL
1035: AND aj.asset_id IN
1036: (SELECT asset_id
1037: FROM fa_books
1038: WHERE group_asset_id IS NOT NULL
1039: AND date_ineffective IS NULL)
1040: AND aj.asset_id = bk.asset_id
1041: 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 1286: fa_books bk,

1282: FROM fa_deprn_detail dd,
1283: fa_distribution_history dh,
1284: fa_asset_history ah,
1285: fa_category_books cb,
1286: fa_books bk,
1287: (SELECT asset_id,
1288: distribution_id,
1289: MAX(period_counter) mpc
1290: FROM fa_deprn_detail

Line 1392: fa_books bk

1388: FROM fa_deprn_detail dd,
1389: fa_distribution_history dh,
1390: fa_asset_history ah,
1391: fa_category_books cb,
1392: fa_books bk
1393: WHERE dh.book_type_code = distribution_source_book
1394: AND decode(dd.deprn_source_code, 'D', p_date, a_date) BETWEEN
1395: dh.date_effective AND nvl(dh.date_ineffective, SYSDATE)
1396: AND dd.asset_id BETWEEN start_range AND end_range --Anuj

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 1600: fa_books bk

1596: FROM fa_distribution_history dh,
1597: fa_deprn_detail dd,
1598: fa_asset_history ah,
1599: fa_category_books cb,
1600: fa_books bk
1601: WHERE dh.book_type_code = distribution_source_book
1602: AND decode(dd.deprn_source_code, 'D', p_date, a_date) BETWEEN
1603: dh.date_effective AND nvl(dh.date_ineffective, SYSDATE)
1604: 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 1866: FROM fa_books bk,

1862: dd.deprn_reserve,
1863: 'REVAL RESERVE',
1864: dd.reval_reserve),
1865: h_request_id
1866: FROM fa_books bk,
1867: fa_category_books cb,
1868: fa_asset_history ah,
1869: fa_deprn_detail dd,
1870: fa_distribution_history dh,

Line 1911: FROM fa_books_groups bg, fa_books fab

1907: AND
1908: -- Commented by Prabakar
1909: (bk.transaction_header_id_in =
1910: (SELECT MIN(fab.transaction_header_id_in)
1911: FROM fa_books_groups bg, fa_books fab
1912: WHERE bg.group_asset_id = nvl(bk.group_asset_id, -2)
1913: AND bg.book_type_code = fab.book_type_code
1914: AND fab.transaction_header_id_in <=
1915: 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

Line 2219: FROM fa_books bk,

2215: dd.deprn_reserve,
2216: 'REVAL RESERVE',
2217: dd.reval_reserve),
2218: h_request_id
2219: FROM fa_books bk,
2220: fa_category_books cb,
2221: fa_asset_history ah,
2222: fa_deprn_detail dd,
2223: fa_distribution_history dh,

Line 2263: FROM fa_books_groups bg, fa_books fab

2259: AND
2260: -- Commented by Prabakar
2261: (bk.transaction_header_id_in =
2262: (SELECT MIN(fab.transaction_header_id_in)
2263: FROM fa_books_groups bg, fa_books fab
2264: WHERE bg.group_asset_id = nvl(bk.group_asset_id, -2)
2265: AND bg.book_type_code = fab.book_type_code
2266: AND fab.transaction_header_id_in <=
2267: bg.transaction_header_id_in