DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on FA_BOOK_CONTROLS

Line 1947: FROM fa_book_controls fbc,

1943: fbc.deprn_calendar,
1944: fbc.prorate_calendar,
1945: fbc.last_period_counter,
1946: fdp.period_name
1947: FROM fa_book_controls fbc,
1948: fa_deprn_periods fdp,
1949: fa_calendar_periods fcp
1950: WHERE fcp.period_name = fdp.period_name
1951: AND fdp.period_counter = (fbc.last_period_counter + 1)

Line 7475: FA_BOOK_CONTROLS fab

7471: OKL_TXL_ASSETS_B txl,
7472: OKC_K_LINES_B cle,
7473: OKC_LINE_STYLES_B lse,
7474: -- Bug# 3631094
7475: FA_BOOK_CONTROLS fab
7476: WHERE txl.kle_id = cle.id
7477: AND cle.dnz_chr_id = p_rel_chr_id
7478: AND cle.lse_id = lse.id
7479: --effectivity

Line 7555: FA_BOOK_CONTROLS fab

7551: OKL_TXL_ASSETS_B txl,
7552: OKC_K_LINES_B cle,
7553: OKC_LINE_STYLES_B lse,
7554: -- Bug# 3631094
7555: FA_BOOK_CONTROLS fab
7556: WHERE txd.tal_id = txl.id
7557: AND txl.kle_id = cle.id
7558: AND cle.dnz_chr_id = p_rel_chr_id
7559: AND cle.lse_id = lse.id

Line 7685: fa_book_controls fbc,

7681: --Bug# 6373605 end
7682: from
7683: fa_books fab,
7684: --Bug# 6373605 start
7685: fa_book_controls fbc,
7686: --Bug# 6373605 end
7687: okc_k_items fa_cim,
7688: okl_trx_types_tl ttyp,
7689: okl_trx_assets trx,

Line 9369: fa_book_controls fbc,

9365: fbc.book_class,
9366: fa.asset_number
9367: from fa_additions fa,
9368: fa_books fab,
9369: fa_book_controls fbc,
9370: okc_k_items cim,
9371: okc_k_lines_b cleb,
9372: okc_line_styles_b lseb
9373: where fab.asset_id = fa.asset_id

Line 9436: fa_book_controls fbc,

9432: txl.depreciation_cost,
9433: txl.depreciation_id,
9434: txl.kle_id
9435: from okl_txl_Assets_b txl,
9436: fa_book_controls fbc,
9437: fa_category_book_defaults fcbd
9438: where fcbd.category_id = txl.depreciation_id
9439: and fcbd.book_type_code = txl.corporate_book
9440: and txl.in_service_date between fcbd.start_dpis and nvl(fcbd.end_dpis,txl.in_service_date)

Line 9462: fa_book_controls fbc,

9458: txl.depreciation_cost,
9459: txl.depreciation_id,
9460: txl.kle_id
9461: from okl_txl_Assets_b txl,
9462: fa_book_controls fbc,
9463: fa_category_book_defaults fcbd,
9464: fa_additions fa
9465: where fcbd.category_id = fa.asset_category_id
9466: and fcbd.book_type_code = txl.corporate_book

Line 9485: fa_book_controls fbc,

9481: txd.deprn_rate_tax,
9482: fcbd.prorate_convention_code,
9483: txd.cost
9484: from okl_txd_Assets_b txd,
9485: fa_book_controls fbc,
9486: fa_category_book_defaults fcbd
9487: where fcbd.category_id = p_category_id
9488: and fcbd.book_type_code = txd.tax_book
9489: and p_in_service_date between fcbd.start_dpis and nvl(fcbd.end_dpis,p_in_service_date)

Line 9508: fa_book_controls fbc,

9504: txd.deprn_rate_tax,
9505: fcbd.prorate_convention_code,
9506: txd.cost
9507: from okl_txd_Assets_b txd,
9508: fa_book_controls fbc,
9509: fa_category_book_defaults fcbd
9510: where fcbd.category_id = p_category_id
9511: and fcbd.book_type_code = txd.tax_book
9512: and p_in_service_date between fcbd.start_dpis and nvl(fcbd.end_dpis,p_in_service_date)