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 68: FROM fa_adjustments fad,

64:
65: CURSOR ret_adj_cur IS
66: SELECT NVL(SUM(NVL(fad.adjustment_amount,0)),0) adj_amt,
67: fad.adjustment_type adj_type
68: FROM fa_adjustments fad,
69: fa_book_controls bc,
70: fa_fiscal_year fy,
71: fa_transaction_headers thg
72: WHERE fad.asset_id = l_group_rec.asset_id

Line 463: FROM fa_adjustments adj,

459: 'CR', -adj.adjustment_amount, 0),
460: 0)), 0)
461: INTO l_group_adjustment_amount,
462: l_second_half_grp_adjustment
463: FROM fa_adjustments adj,
464: fa_book_controls bc,
465: fa_fiscal_year fy,
466: fa_transaction_headers thg
467: WHERE thg.asset_id = l_group_rec.asset_id

Line 558: FROM fa_adjustments adj,

554: SELECT NVL(SUM(DECODE(adj.adjustment_type || '-' || adj.debit_credit_flag,
555: 'RESERVE-CR', adj.adjustment_amount,
556: 'RESERVE-DR', -adj.adjustment_amount,0)), 0) reserve
557: INTO l_group_reclass_rsv_in_out
558: FROM fa_adjustments adj,
559: fa_transaction_headers thg
560: WHERE adj.asset_id = l_group_rec.asset_id
561: AND adj.book_type_code = p_book_type_code
562: AND thg.transaction_header_id = adj.transaction_header_id

Line 1271: FROM fa_adjustments adj,

1267: ''COST-CR'', -adj.adjustment_amount,
1268: ''CIP COST-DR'', adj.adjustment_amount,
1269: ''CIP COST-CR'', -adj.adjustment_amount, 0)), 0)
1270: adjustment_amount
1271: FROM fa_adjustments adj,
1272: fa_book_controls bc,
1273: fa_fiscal_year fy,
1274: fa_transaction_headers thm,
1275: fa_books bkm

Line 1698: FROM fa_adjustments adj,

1694: BEGIN
1695: if(P_MRCSOBTYPE <> 'R') then -- MRC
1696: SELECT NVL(bkm.cost, 0) - NVL(adj.adjustment_amount, 0)
1697: INTO l_group_reclass_out
1698: FROM fa_adjustments adj,
1699: fa_transaction_headers thg,
1700: fa_books bkm
1701: WHERE adj.asset_id = p_group_rec.asset_id
1702: AND adj.book_type_code = p_info_rec.book_type_code

Line 1757: FROM fa_adjustments adj,

1753: BEGIN
1754: if(P_MRCSOBTYPE <> 'R') then -- MRC
1755: SELECT NVL(bkm.cost, 0) - NVL(adj.adjustment_amount, 0)
1756: INTO l_group_reclass_in
1757: FROM fa_adjustments adj,
1758: fa_transaction_headers thg,
1759: fa_books bkm
1760: WHERE adj.asset_id = p_group_rec.asset_id
1761: AND adj.book_type_code = p_info_rec.book_type_code