DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on FA_BOOK_CONTROLS

Line 1951: FROM fa_book_controls fbc,

1947: fbc.deprn_calendar,
1948: fbc.prorate_calendar,
1949: fbc.last_period_counter,
1950: fdp.period_name
1951: FROM fa_book_controls fbc,
1952: fa_deprn_periods fdp,
1953: fa_calendar_periods fcp
1954: WHERE fcp.period_name = fdp.period_name
1955: AND fdp.period_counter = (fbc.last_period_counter + 1)

Line 7200: FA_BOOK_CONTROLS fab

7196: OKL_TXL_ASSETS_B txl,
7197: OKC_K_LINES_B cle,
7198: OKC_LINE_STYLES_B lse,
7199: -- Bug# 3631094
7200: FA_BOOK_CONTROLS fab
7201: WHERE txl.kle_id = cle.id
7202: AND cle.dnz_chr_id = p_rel_chr_id
7203: AND cle.lse_id = lse.id
7204: --effectivity

Line 7280: FA_BOOK_CONTROLS fab

7276: OKL_TXL_ASSETS_B txl,
7277: OKC_K_LINES_B cle,
7278: OKC_LINE_STYLES_B lse,
7279: -- Bug# 3631094
7280: FA_BOOK_CONTROLS fab
7281: WHERE txd.tal_id = txl.id
7282: AND txl.kle_id = cle.id
7283: AND cle.dnz_chr_id = p_rel_chr_id
7284: AND cle.lse_id = lse.id

Line 7410: fa_book_controls fbc,

7406: --Bug# 6373605 end
7407: from
7408: fa_books fab,
7409: --Bug# 6373605 start
7410: fa_book_controls fbc,
7411: --Bug# 6373605 end
7412: okc_k_items fa_cim,
7413: okl_trx_types_tl ttyp,
7414: okl_trx_assets trx,

Line 9094: fa_book_controls fbc,

9090: fbc.book_class,
9091: fa.asset_number
9092: from fa_additions fa,
9093: fa_books fab,
9094: fa_book_controls fbc,
9095: okc_k_items cim,
9096: okc_k_lines_b cleb,
9097: okc_line_styles_b lseb
9098: where fab.asset_id = fa.asset_id

Line 9161: fa_book_controls fbc,

9157: txl.depreciation_cost,
9158: txl.depreciation_id,
9159: txl.kle_id
9160: from okl_txl_Assets_b txl,
9161: fa_book_controls fbc,
9162: fa_category_book_defaults fcbd
9163: where fcbd.category_id = txl.depreciation_id
9164: and fcbd.book_type_code = txl.corporate_book
9165: and txl.in_service_date between fcbd.start_dpis and nvl(fcbd.end_dpis,txl.in_service_date)

Line 9187: fa_book_controls fbc,

9183: txl.depreciation_cost,
9184: txl.depreciation_id,
9185: txl.kle_id
9186: from okl_txl_Assets_b txl,
9187: fa_book_controls fbc,
9188: fa_category_book_defaults fcbd,
9189: fa_additions fa
9190: where fcbd.category_id = fa.asset_category_id
9191: and fcbd.book_type_code = txl.corporate_book

Line 9210: fa_book_controls fbc,

9206: txd.deprn_rate_tax,
9207: fcbd.prorate_convention_code,
9208: txd.cost
9209: from okl_txd_Assets_b txd,
9210: fa_book_controls fbc,
9211: fa_category_book_defaults fcbd
9212: where fcbd.category_id = p_category_id
9213: and fcbd.book_type_code = txd.tax_book
9214: and p_in_service_date between fcbd.start_dpis and nvl(fcbd.end_dpis,p_in_service_date)

Line 9233: fa_book_controls fbc,

9229: txd.deprn_rate_tax,
9230: fcbd.prorate_convention_code,
9231: txd.cost
9232: from okl_txd_Assets_b txd,
9233: fa_book_controls fbc,
9234: fa_category_book_defaults fcbd
9235: where fcbd.category_id = p_category_id
9236: and fcbd.book_type_code = txd.tax_book
9237: and p_in_service_date between fcbd.start_dpis and nvl(fcbd.end_dpis,p_in_service_date)