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 994: fa_books BO

990: SELECT FY.fiscal_year
991: INTO X_ret
992: FROM fa_fiscal_year FY,
993: fa_convention_types CT,
994: fa_books BO
995: WHERE CT.prorate_convention_code = BO.prorate_convention_code
996: AND FY.fiscal_year_name = CT.fiscal_year_name
997: AND BO.date_ineffective IS NULL
998: AND BO.date_placed_in_service BETWEEN FY.start_date

Line 1391: FROM fa_books BO

1387: FA_RX_UTIL_PKG.debug('Get cost initial value');
1388: -- Get initial value
1389: SELECT count(*)
1390: INTO X_capitalized
1391: FROM fa_books BO
1392: WHERE BO.book_type_code = PARM.p_book_type_code
1393: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1394: AND BO.period_counter_capitalized BETWEEN PARM.p_begin_period_counter AND
1395: PARM.p_end_period_counter;

Line 1404: FROM fa_books BO

1400: SELECT cost,
1401: transaction_header_id_in
1402: INTO JG_RX_FAREG.var.asset_cost_initial,
1403: X_transaction_id_initial
1404: FROM fa_books BO
1405: WHERE BO.book_type_code = PARM.p_book_type_code
1406: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1407: AND (TO_CHAR(BO.date_effective, 'DD-MON-YYYY HH:MI:SS'),transaction_header_id_in) =
1408: (SELECT TO_CHAR(MAX(BO1.date_effective), 'DD-MON-YYYY HH:MI:SS'),

Line 1410: FROM fa_books BO1, fa_transaction_headers TRH

1406: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1407: AND (TO_CHAR(BO.date_effective, 'DD-MON-YYYY HH:MI:SS'),transaction_header_id_in) =
1408: (SELECT TO_CHAR(MAX(BO1.date_effective), 'DD-MON-YYYY HH:MI:SS'),
1409: max(transaction_header_id_in)
1410: FROM fa_books BO1, fa_transaction_headers TRH
1411: WHERE BO1.book_type_code = BO.book_type_code
1412: AND BO1.asset_id = BO.asset_id
1413: AND TRH.transaction_header_id= BO1.transaction_header_id_in
1414: AND TRH.transaction_date_entered < PARM.p_begin_period_from_date);

Line 1430: FROM fa_books BO

1426: SELECT cost,
1427: transaction_header_id_in
1428: INTO JG_RX_FAREG.var.asset_cost_final,
1429: X_transaction_id_final
1430: FROM fa_books BO
1431: WHERE BO.book_type_code = PARM.p_book_type_code
1432: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1433: AND (TO_CHAR(BO.date_effective, 'DD-MON-YYYY HH:MI:SS'),transaction_header_id_in) =
1434: (SELECT TO_CHAR(MAX(BO1.date_effective), 'DD-MON-YYYY HH:MI:SS'),

Line 1436: FROM fa_books BO1,FA_TRANSACTION_HEADERS TRH

1432: AND BO.asset_id = JG_RX_FAREG.var.asset_id
1433: AND (TO_CHAR(BO.date_effective, 'DD-MON-YYYY HH:MI:SS'),transaction_header_id_in) =
1434: (SELECT TO_CHAR(MAX(BO1.date_effective), 'DD-MON-YYYY HH:MI:SS'),
1435: max(transaction_header_id_in)
1436: FROM fa_books BO1,FA_TRANSACTION_HEADERS TRH
1437: WHERE BO1.book_type_code = BO.book_type_code
1438: AND BO1.asset_id = BO.asset_id
1439: AND TRH.transaction_header_id= BO1.transaction_header_id_in
1440: AND TRH.transaction_date_entered <= PARM.p_end_period_to_date);

Line 1502: FROM fa_books BO,

1498: fa_rx_util_pkg.debug('PARM.p_end_period_from_date'||to_char(PARM.p_end_period_from_date));
1499:
1500: SELECT SUM(AD.adjustment_amount)
1501: INTO X_partial_addition
1502: FROM fa_books BO,
1503: fa_transaction_headers TH,
1504: fa_adjustments AD
1505: WHERE BO.book_type_code = PARM.p_book_type_code
1506: AND BO.asset_id = JG_RX_FAREG.var.asset_id

Line 1623: FROM fa_books BO,

1619: FA_RX_UTIL_PKG.debug('Get credit memos ');
1620:
1621: SELECT SUM(AD.adjustment_amount)
1622: INTO X_credit_memos
1623: FROM fa_books BO,
1624: fa_transaction_headers TH,
1625: fa_adjustments AD
1626: WHERE BO.book_type_code = PARM.p_book_type_code
1627: AND BO.asset_id = JG_RX_FAREG.var.asset_id

Line 2442: fa_books BO

2438: TH.transaction_header_id,
2439: BO.date_placed_in_service,
2440: BO.cost
2441: FROM fa_transaction_headers TH,
2442: fa_books BO
2443: WHERE BO.transaction_header_id_in = TH.transaction_header_id
2444: AND BO.book_type_code = TH.book_type_code
2445: AND BO.asset_id = TH.asset_id
2446: AND TH.transaction_type_code = 'ADDITION'