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_AMORT_PVT dependencies on FA_BOOK_CONTROLS

Line 327: from fa_book_controls bc

323: , cp.end_date calendar_period_close_date
324: , cp.period_num period_num
325: , fy.fiscal_year fiscal_year
326: , 'N'
327: from fa_book_controls bc
328: , fa_fiscal_year fy
329: , fa_calendar_types ct
330: , fa_calendar_periods cp
331: where bc.book_type_code = p_asset_hdr_rec.book_type_code

Line 7985: fa_book_controls bc,

7981: th.transaction_type_code transaction_type_code
7982: from
7983: fa_transaction_headers th,
7984: fa_deprn_periods dp,
7985: fa_book_controls bc,
7986: fa_fiscal_year fy
7987: where th.asset_id = p_asset_hdr_rec.asset_id
7988: and th.book_type_code = p_asset_hdr_rec.book_type_code
7989: and bc.book_type_code = p_asset_hdr_rec.book_type_code

Line 8024: fa_book_controls bc,

8020: nvl(sum(ret.eofy_reserve), 0)
8021: from fa_retirements ret,
8022: fa_transaction_headers mth,
8023: fa_transaction_headers gth,
8024: fa_book_controls bc,
8025: fa_fiscal_year fy
8026: where gth.asset_id = p_asset_hdr_rec.asset_id
8027: and gth.book_type_code = p_asset_hdr_rec.book_type_code
8028: and bc.book_type_code = p_asset_hdr_rec.book_type_code

Line 8042: fa_book_controls bc

8038: and ret.transaction_header_id_out is null
8039: and fy.start_date =
8040: (select fy.start_date
8041: from fa_fiscal_year fy,
8042: fa_book_controls bc
8043: where bc.book_type_code = p_asset_hdr_rec.book_type_code
8044: and bc.fiscal_year_name = fy.fiscal_year_name
8045: and fy.start_date <= p_trans_rec.transaction_date_entered
8046: and fy.end_date >= p_trans_rec.transaction_date_entered

Line 8055: fa_book_controls_mrc_v bc,

8051: nvl(sum(ret.eofy_reserve), 0)
8052: from fa_retirements_mrc_v ret,
8053: fa_transaction_headers mth,
8054: fa_transaction_headers gth,
8055: fa_book_controls_mrc_v bc,
8056: fa_fiscal_year fy
8057: where gth.asset_id = p_asset_hdr_rec.asset_id
8058: and gth.book_type_code = p_asset_hdr_rec.book_type_code
8059: and bc.book_type_code = p_asset_hdr_rec.book_type_code

Line 8073: fa_book_controls_mrc_v bc

8069: and ret.transaction_header_id_out is null
8070: and fy.start_date =
8071: (select fy.start_date
8072: from fa_fiscal_year fy,
8073: fa_book_controls_mrc_v bc
8074: where bc.book_type_code = p_asset_hdr_rec.book_type_code
8075: and bc.fiscal_year_name = fy.fiscal_year_name
8076: and fy.start_date <= p_trans_rec.transaction_date_entered
8077: and fy.end_date >= p_trans_rec.transaction_date_entered

Line 8085: fa_book_controls bc,

8081: select nvl(sum(ret.reserve_retired), 0),
8082: nvl(sum(ret.eofy_reserve), 0)
8083: from fa_retirements ret,
8084: fa_transaction_headers th,
8085: fa_book_controls bc,
8086: fa_fiscal_year fy
8087: where th.asset_id = p_asset_hdr_rec.asset_id
8088: and th.book_type_code = p_asset_hdr_rec.book_type_code
8089: and bc.book_type_code = p_asset_hdr_rec.book_type_code

Line 8153: fa_book_controls bc

8149: (select th.member_transaction_header_id
8150: from fa_transaction_headers th,
8151: fa_deprn_periods dp,
8152: fa_fiscal_year fy,
8153: fa_book_controls bc
8154: where th.asset_id = p_asset_hdr_rec.asset_id
8155: and th.book_type_code = p_asset_hdr_rec.book_type_code
8156: and dp.book_type_code = p_asset_hdr_rec.book_type_code
8157: and dp.book_type_code = bc.book_type_code