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

Line 259: 'fa_books BO,

255: --
256: -- Assign From Clause
257: --
258: FA_RX_UTIL_PKG.From_Clause :=
259: 'fa_books BO,
260: fa_additions AD,
261: fa_categories CA,
262: fa_category_books CB,
263: fa_methods ME';

Line 276: ' FROM fa_books' ||

272: ' AND AD.in_use_flag = ''YES''' ||
273: ' AND AD.asset_category_id = CA.category_id' ||
274: ' AND (BO.date_effective,transaction_header_id_in) = (SELECT MAX(date_effective),'||
275: ' max(transaction_header_id_in)' ||
276: ' FROM fa_books' ||
277: ' WHERE date_placed_in_service <= :b_period_to_date' ||
278: -- ' WHERE date_effective < :b_period_to_date' || // Date_effective -> Date_placed_in_service
279: ' AND book_type_code = bo.book_type_code' ||
280: ' AND asset_id = BO.asset_id)' ||

Line 507: fa_books bo';

503: FA_RX_UTIL_PKG.From_Clause :=
504: 'fa_retirements re,
505: fa_additions ad,
506: fa_categories ca,
507: fa_books bo';
508:
509:
510: --
511: -- Assign Where Clause

Line 520: ' FROM fa_books' ||

516: ' AND RE.STATUS = ''PROCESSED'''||
517: ' AND AD.asset_category_id = CA.category_id' ||
518: ' AND AD.asset_id = BO.asset_id' ||
519: ' AND BO.date_effective = (SELECT MAX(date_effective)' ||
520: ' FROM fa_books' ||
521: ' WHERE TO_CHAR(date_effective,''DD-MON-YYYY HH:MI:SS'') < ' ||
522: ' TO_CHAR(:b_period_to_date,''DD-MON-YYYY HH:MI:SS'')' ||
523: ' AND book_type_code = BO.book_type_code' ||
524: ' AND asset_id = BO.asset_id) '||

Line 850: fa_books BO

846: SELECT FY.fiscal_year
847: INTO X_ret
848: FROM fa_fiscal_year FY,
849: fa_convention_types CT,
850: fa_books BO
851: WHERE CT.prorate_convention_code = BO.prorate_convention_code
852: AND FY.fiscal_year_name = CT.fiscal_year_name
853: AND BO.date_ineffective IS NULL
854: AND BO.date_placed_in_service BETWEEN FY.start_date

Line 1161: FROM fa_books BO

1157: FA_RX_UTIL_PKG.debug('Get cost initial value');
1158: -- Get initial value
1159: SELECT count(*)
1160: INTO X_capitalized
1161: FROM fa_books BO
1162: WHERE BO.book_type_code = PARM.p_book_type_code
1163: AND BO.asset_id = JGRX_FAREG.var.asset_id
1164: AND BO.period_counter_capitalized BETWEEN PARM.p_begin_period_counter AND
1165: PARM.p_end_period_counter;

Line 1174: FROM fa_books BO

1170: SELECT cost,
1171: transaction_header_id_in
1172: INTO JGRX_FAREG.var.asset_cost_initial,
1173: X_transaction_id_initial
1174: FROM fa_books BO
1175: WHERE BO.book_type_code = PARM.p_book_type_code
1176: AND BO.asset_id = JGRX_FAREG.var.asset_id
1177: AND (TO_CHAR(BO.date_effective, 'DD-MON-YYYY HH:MI:SS'),transaction_header_id_in) =
1178: (SELECT TO_CHAR(MAX(BO1.date_effective), 'DD-MON-YYYY HH:MI:SS'),

Line 1180: FROM fa_books BO1, fa_transaction_headers TRH

1176: AND BO.asset_id = JGRX_FAREG.var.asset_id
1177: AND (TO_CHAR(BO.date_effective, 'DD-MON-YYYY HH:MI:SS'),transaction_header_id_in) =
1178: (SELECT TO_CHAR(MAX(BO1.date_effective), 'DD-MON-YYYY HH:MI:SS'),
1179: max(transaction_header_id_in)
1180: FROM fa_books BO1, fa_transaction_headers TRH
1181: WHERE BO1.book_type_code = BO.book_type_code
1182: AND BO1.asset_id = BO.asset_id
1183: AND TRH.transaction_header_id= BO1.transaction_header_id_in
1184: AND TRH.transaction_date_entered < PARM.p_begin_period_from_date);

Line 1200: FROM fa_books BO

1196: SELECT cost,
1197: transaction_header_id_in
1198: INTO JGRX_FAREG.var.asset_cost_final,
1199: X_transaction_id_final
1200: FROM fa_books BO
1201: WHERE BO.book_type_code = PARM.p_book_type_code
1202: AND BO.asset_id = JGRX_FAREG.var.asset_id
1203: AND (TO_CHAR(BO.date_effective, 'DD-MON-YYYY HH:MI:SS'),transaction_header_id_in) =
1204: (SELECT TO_CHAR(MAX(BO1.date_effective), 'DD-MON-YYYY HH:MI:SS'),

Line 1206: FROM fa_books BO1,FA_TRANSACTION_HEADERS TRH

1202: AND BO.asset_id = JGRX_FAREG.var.asset_id
1203: AND (TO_CHAR(BO.date_effective, 'DD-MON-YYYY HH:MI:SS'),transaction_header_id_in) =
1204: (SELECT TO_CHAR(MAX(BO1.date_effective), 'DD-MON-YYYY HH:MI:SS'),
1205: max(transaction_header_id_in)
1206: FROM fa_books BO1,FA_TRANSACTION_HEADERS TRH
1207: WHERE BO1.book_type_code = BO.book_type_code
1208: AND BO1.asset_id = BO.asset_id
1209: AND TRH.transaction_header_id= BO1.transaction_header_id_in
1210: AND TRH.transaction_date_entered <= PARM.p_end_period_to_date);

Line 1271: FROM fa_books BO,

1267: fa_rx_util_pkg.debug('PARM.p_end_period_from_date'||to_char(PARM.p_end_period_from_date));
1268:
1269: SELECT SUM(AD.adjustment_amount)
1270: INTO X_partial_addition
1271: FROM fa_books BO,
1272: fa_transaction_headers TH,
1273: fa_adjustments AD
1274: WHERE BO.book_type_code = PARM.p_book_type_code
1275: AND BO.asset_id = JGRX_FAREG.var.asset_id

Line 1392: FROM fa_books BO,

1388: FA_RX_UTIL_PKG.debug('Get credit memos ');
1389:
1390: SELECT SUM(AD.adjustment_amount)
1391: INTO X_credit_memos
1392: FROM fa_books BO,
1393: fa_transaction_headers TH,
1394: fa_adjustments AD
1395: WHERE BO.book_type_code = PARM.p_book_type_code
1396: AND BO.asset_id = JGRX_FAREG.var.asset_id

Line 2157: fa_books BO

2153: TH.transaction_header_id,
2154: BO.date_placed_in_service,
2155: BO.cost
2156: FROM fa_transaction_headers TH,
2157: fa_books BO
2158: WHERE BO.transaction_header_id_in = TH.transaction_header_id
2159: AND BO.book_type_code = TH.book_type_code
2160: AND BO.asset_id = TH.asset_id
2161: AND TH.transaction_type_code = 'ADDITION'