DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 9437: fa_category_book_defaults fcbd

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)
9441: and fbc.book_type_code = txl.corporate_book

Line 9463: fa_category_book_defaults fcbd,

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
9467: and fa.asset_number = txl.asset_number

Line 9486: fa_category_book_defaults fcbd

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)
9490: and fbc.book_type_code = txd.tax_book

Line 9509: fa_category_book_defaults fcbd

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)
9513: and fbc.book_type_code = txd.tax_book

Line 9556: from fa_category_book_defaults

9552: life_in_months,
9553: basic_rate,
9554: adjusted_rate,
9555: prorate_convention_code
9556: from fa_category_book_defaults
9557: where book_type_code = p_book
9558: and category_id = p_category_id
9559: and p_date between start_dpis and nvl(end_dpis,p_date);
9560: