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_MC_ADJUSTMENTS

Line 88: FROM fa_mc_adjustments fad,

84: -- MRC
85: CURSOR mc_ret_adj_cur IS
86: SELECT NVL(SUM(NVL(fad.adjustment_amount,0)),0) adj_amt,
87: fad.adjustment_type adj_type
88: FROM fa_mc_adjustments fad,
89: fa_book_controls bc,
90: fa_fiscal_year fy,
91: fa_transaction_headers thg
92: WHERE fad.asset_id = l_group_rec.asset_id

Line 492: FROM fa_mc_adjustments adj,

488: 'CR', -adj.adjustment_amount, 0),
489: 0)), 0)
490: INTO l_group_adjustment_amount,
491: l_second_half_grp_adjustment
492: FROM fa_mc_adjustments adj,
493: fa_book_controls bc,
494: fa_fiscal_year fy,
495: fa_transaction_headers thg
496: WHERE thg.asset_id = l_group_rec.asset_id

Line 603: FROM fa_mc_adjustments adj,

599: SELECT NVL(SUM(DECODE(adj.adjustment_type || '-' || adj.debit_credit_flag,
600: 'RESERVE-CR', adj.adjustment_amount,
601: 'RESERVE-DR', -adj.adjustment_amount,0)), 0) reserve
602: INTO l_group_reclass_rsv_in_out
603: FROM fa_mc_adjustments adj,
604: fa_transaction_headers thg
605: WHERE adj.asset_id = l_group_rec.asset_id
606: AND adj.book_type_code = p_book_type_code
607: AND thg.transaction_header_id = adj.transaction_header_id

Line 1316: FROM fa_mc_adjustments adj,

1312: ''COST-CR'', -adj.adjustment_amount,
1313: ''CIP COST-DR'', adj.adjustment_amount,
1314: ''CIP COST-CR'', -adj.adjustment_amount, 0)), 0)
1315: adjustment_amount
1316: FROM fa_mc_adjustments adj,
1317: fa_mc_book_controls bc,
1318: fa_book_controls bc1,
1319: fa_fiscal_year fy,
1320: fa_transaction_headers thm,

Line 1716: FROM fa_mc_adjustments adj,

1712: -- MRC
1713: else
1714: SELECT NVL(bkm.cost, 0) - NVL(adj.adjustment_amount, 0)
1715: INTO l_group_reclass_out
1716: FROM fa_mc_adjustments adj,
1717: fa_transaction_headers thg,
1718: fa_mc_books bkm
1719: WHERE adj.asset_id = p_group_rec.asset_id
1720: AND adj.book_type_code = p_info_rec.book_type_code

Line 1774: FROM fa_mc_adjustments adj,

1770: -- MRC
1771: else
1772: SELECT NVL(bkm.cost, 0) - NVL(adj.adjustment_amount, 0)
1773: INTO l_group_reclass_in
1774: FROM fa_mc_adjustments adj,
1775: fa_transaction_headers thg,
1776: fa_mc_books bkm
1777: WHERE adj.asset_id = p_group_rec.asset_id
1778: AND adj.book_type_code = p_info_rec.book_type_code