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_RX_GROUP dependencies on FA_ADJUSTMENTS

Line 333: FROM fa_adjustments adj,

329: 'CR', -adj.adjustment_amount, 0),
330: 0)), 0)
331: INTO l_group_adjustment_amount,
332: l_second_half_grp_adjustment
333: FROM fa_adjustments adj,
334: fa_book_controls bc,
335: fa_fiscal_year fy,
336: fa_transaction_headers thg
337: WHERE thg.asset_id = l_group_rec.asset_id

Line 370: FROM fa_adjustments adj,

366:
367: -- Get group reclass amount
368: SELECT NVL(SUM(bkm.cost), 0) - NVL(SUM(adj.adjustment_amount), 0)
369: INTO l_group_reclass_in
370: FROM fa_adjustments adj,
371: fa_transaction_headers thg,
372: fa_books bkm,
373: (SELECT bk_pre.asset_id,
374: bk_pre.group_asset_id

Line 408: FROM fa_adjustments adj,

404: AND NVL(prev.group_asset_id, -1) <> l_group_rec.asset_id;
405:
406: SELECT NVL(SUM(bkm.cost), 0) - NVL(SUM(adj.adjustment_amount), 0)
407: INTO l_group_reclass_out
408: FROM fa_adjustments adj,
409: fa_transaction_headers thg,
410: fa_books bkm
411: WHERE adj.asset_id = l_group_rec.asset_id
412: AND adj.book_type_code = p_book_type_code

Line 990: FROM fa_adjustments adj,

986: ''COST-CR'', -adj.adjustment_amount,
987: ''CIP COST-DR'', adj.adjustment_amount,
988: ''CIP COST-CR'', -adj.adjustment_amount, 0)), 0)
989: adjustment_amount
990: FROM fa_adjustments adj,
991: fa_book_controls bc,
992: fa_fiscal_year fy,
993: fa_transaction_headers thm,
994: fa_books bkm

Line 1327: FROM fa_adjustments adj,

1323:
1324: BEGIN
1325: SELECT NVL(bkm.cost, 0) - NVL(adj.adjustment_amount, 0)
1326: INTO l_group_reclass_out
1327: FROM fa_adjustments adj,
1328: fa_transaction_headers thg,
1329: fa_books bkm
1330: WHERE adj.asset_id = p_group_rec.asset_id
1331: AND adj.book_type_code = p_info_rec.book_type_code

Line 1363: FROM fa_adjustments adj,

1359:
1360: BEGIN
1361: SELECT NVL(bkm.cost, 0) - NVL(adj.adjustment_amount, 0)
1362: INTO l_group_reclass_in
1363: FROM fa_adjustments adj,
1364: fa_transaction_headers thg,
1365: fa_books bkm
1366: WHERE adj.asset_id = p_group_rec.asset_id
1367: AND adj.book_type_code = p_info_rec.book_type_code