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.JG_RX_FAREG dependencies on FA_BOOKS

Line 281: 'fa_books BO,

277: --
278: -- Assign From Clause
279: --
280: FA_RX_UTIL_PKG.From_Clause :=
281: 'fa_books BO,
282: fa_additions AD,
283: fa_categories CA,
284: fa_category_books CB,
285: fa_methods METH';

Line 298: ' FROM fa_books' ||

294: ' AND AD.in_use_flag = ''YES''' ||
295: ' AND AD.asset_category_id = CA.category_id' ||
296: ' AND (BO.date_effective,transaction_header_id_in) = (SELECT MAX(date_effective),'||
297: ' max(transaction_header_id_in)' ||
298: ' FROM fa_books' ||
299: ' WHERE date_placed_in_service <= :b_period_to_date' ||
300: -- ' WHERE date_effective < :b_period_to_date' || // Date_effective -> Date_placed_in_service
301: ' AND book_type_code = bo.book_type_code' ||
302: ' AND asset_id = BO.asset_id)' ||

Line 592: fa_books bo,

588: FA_RX_UTIL_PKG.From_Clause :=
589: 'fa_retirements re,
590: fa_additions ad,
591: fa_categories ca,
592: fa_books bo,
593: fa_methods METH';
594:
595:
596: --

Line 609: ' FROM fa_books' ||

605: ' AND BO.deprn_method_code = METH.method_code' ||
606: ' AND NVL(BO.life_in_months,-99) = NVL(METH.life_in_months,-99)'||
607: ' AND AD.asset_id = BO.asset_id' ||
608: ' AND BO.date_effective = (SELECT MAX(date_effective)' ||
609: ' FROM fa_books' ||
610: ' WHERE TO_CHAR(date_effective,''DD-MON-YYYY HH:MI:SS'') < ' ||
611: ' TO_CHAR(:b_period_to_date,''DD-MON-YYYY HH:MI:SS'')' ||
612: ' AND book_type_code = BO.book_type_code' ||
613: ' AND asset_id = BO.asset_id) '||

Line 1001: fa_books BO

997: SELECT FY.fiscal_year
998: INTO X_ret
999: FROM fa_fiscal_year FY,
1000: fa_convention_types CT,
1001: fa_books BO
1002: WHERE CT.prorate_convention_code = BO.prorate_convention_code
1003: AND FY.fiscal_year_name = CT.fiscal_year_name
1004: AND BO.date_ineffective IS NULL
1005: AND BO.date_placed_in_service BETWEEN FY.start_date

Line 1407: FROM fa_books BO

1403: FA_RX_UTIL_PKG.debug('Get cost initial value');
1404: -- Get initial value
1405: SELECT count(*)
1406: INTO X_capitalized
1407: FROM fa_books BO
1408: WHERE BO.book_type_code = PARM.p_book_type_code
1409: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1410: AND BO.period_counter_capitalized BETWEEN PARM.p_begin_period_counter AND
1411: PARM.p_end_period_counter;

Line 1420: FROM fa_books BO

1416: SELECT cost,
1417: transaction_header_id_in
1418: INTO JG_RX_FAREG.var.asset_cost_initial,
1419: X_transaction_id_initial
1420: FROM fa_books BO
1421: WHERE BO.book_type_code = PARM.p_book_type_code
1422: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1423: AND (TO_CHAR(BO.date_effective, 'DD-MON-YYYY HH:MI:SS'),transaction_header_id_in) =
1424: (SELECT TO_CHAR(MAX(BO1.date_effective), 'DD-MON-YYYY HH:MI:SS'),

Line 1426: FROM fa_books BO1, fa_transaction_headers TRH

1422: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1423: AND (TO_CHAR(BO.date_effective, 'DD-MON-YYYY HH:MI:SS'),transaction_header_id_in) =
1424: (SELECT TO_CHAR(MAX(BO1.date_effective), 'DD-MON-YYYY HH:MI:SS'),
1425: max(transaction_header_id_in)
1426: FROM fa_books BO1, fa_transaction_headers TRH
1427: WHERE BO1.book_type_code = BO.book_type_code
1428: AND BO1.asset_id = BO.asset_id
1429: AND TRH.transaction_header_id= BO1.transaction_header_id_in
1430: AND TRH.transaction_date_entered < PARM.p_begin_period_from_date);

Line 1446: FROM fa_books BO

1442: SELECT cost,
1443: transaction_header_id_in
1444: INTO JG_RX_FAREG.var.asset_cost_final,
1445: X_transaction_id_final
1446: FROM fa_books BO
1447: WHERE BO.book_type_code = PARM.p_book_type_code
1448: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1449: AND (TO_CHAR(BO.date_effective, 'DD-MON-YYYY HH:MI:SS'),transaction_header_id_in) =
1450: (SELECT TO_CHAR(MAX(BO1.date_effective), 'DD-MON-YYYY HH:MI:SS'),

Line 1452: FROM fa_books BO1,FA_TRANSACTION_HEADERS TRH

1448: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1449: AND (TO_CHAR(BO.date_effective, 'DD-MON-YYYY HH:MI:SS'),transaction_header_id_in) =
1450: (SELECT TO_CHAR(MAX(BO1.date_effective), 'DD-MON-YYYY HH:MI:SS'),
1451: max(transaction_header_id_in)
1452: FROM fa_books BO1,FA_TRANSACTION_HEADERS TRH
1453: WHERE BO1.book_type_code = BO.book_type_code
1454: AND BO1.asset_id = BO.asset_id
1455: AND TRH.transaction_header_id= BO1.transaction_header_id_in
1456: AND TRH.transaction_date_entered <= PARM.p_end_period_to_date);

Line 1518: FROM fa_books BO,

1514: fa_rx_util_pkg.debug('PARM.p_end_period_from_date'||to_char(PARM.p_end_period_from_date));
1515:
1516: SELECT SUM(AD.adjustment_amount)
1517: INTO X_partial_addition
1518: FROM fa_books BO,
1519: fa_transaction_headers TH,
1520: fa_adjustments AD
1521: WHERE BO.book_type_code = PARM.p_book_type_code
1522: AND BO.asset_id = JG_RX_FAREG.var.asset_id

Line 1639: FROM fa_books BO,

1635: FA_RX_UTIL_PKG.debug('Get credit memos ');
1636:
1637: SELECT SUM(AD.adjustment_amount)
1638: INTO X_credit_memos
1639: FROM fa_books BO,
1640: fa_transaction_headers TH,
1641: fa_adjustments AD
1642: WHERE BO.book_type_code = PARM.p_book_type_code
1643: AND BO.asset_id = JG_RX_FAREG.var.asset_id

Line 2458: fa_books BO

2454: TH.transaction_header_id,
2455: BO.date_placed_in_service,
2456: BO.cost
2457: FROM fa_transaction_headers TH,
2458: fa_books BO
2459: WHERE BO.transaction_header_id_in = TH.transaction_header_id
2460: AND BO.book_type_code = TH.book_type_code
2461: AND BO.asset_id = TH.asset_id
2462: AND TH.transaction_type_code = 'ADDITION'