DBA Data[Home] [Help]

APPS.CSI_ASSET_PVT dependencies on FA_BOOKS

Line 461: ,fa_books e

457: ,p_asset_header_tbl(tab_row).expense_account_number
458: FROM fa_additions_vl b
459: ,fa_distribution_history c
460: ,fa_categories_b_kfv d
461: ,fa_books e
462: ,fa_employees f
463: ,gl_code_combinations_kfv g
464: WHERE b.asset_id = c.asset_id
465: AND b.asset_category_id = d.category_id

Line 504: ,fa_books e

500: ,l_assigned_to
501: FROM fa_additions_vl b
502: ,fa_distribution_history c
503: ,fa_categories_b_kfv d
504: ,fa_books e
505: WHERE b.asset_id = c.asset_id
506: AND b.asset_category_id = d.category_id
507: AND b.asset_id = e.asset_id
508: AND c.book_type_code = e.book_type_code

Line 1243: --check for the exists of asset_id and asset book_type_code combination in the fa_books table

1239: (p_instance_asset_rec.ASSET_QUANTITY)) THEN
1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;
1242:
1243: --check for the exists of asset_id and asset book_type_code combination in the fa_books table
1244: l_valid_flag := 'Y';
1245: l_exists_flag := 'N';
1246: IF ((p_instance_asset_rec.fa_asset_id is not null AND
1247: p_instance_asset_rec.fa_asset_id <> FND_API.G_MISS_NUM) AND

Line 1728: --check for the exists of asset_id and asset book_type_code combination in the fa_books table

1724: END IF;
1725: END IF;
1726: --
1727:
1728: --check for the exists of asset_id and asset book_type_code combination in the fa_books table
1729: l_valid_flag := 'Y';
1730: l_exists_flag := 'N';
1731: IF ((p_instance_asset_rec.fa_asset_id is not null AND
1732: p_instance_asset_rec.fa_asset_id <> FND_API.G_MISS_NUM) AND