APPS.CSI_ASSET_PVT dependencies on FA_DISTRIBUTION_HISTORY

Line 138: FROM fa_distribution_history fdh

134: WHERE location_id = l_cii_location_id;
135:
136: CURSOR fa_location_units_cur IS
137: SELECT SUM(fdh.units_assigned)
138: FROM fa_distribution_history fdh
139: WHERE fdh.asset_id = px_instance_asset_rec.fa_asset_id
140: AND fdh.date_ineffective is null
141: AND fdh.location_id = px_instance_asset_rec.fa_location_id ;
142:

Line 459: ,fa_distribution_history c

455: ,p_asset_header_tbl(tab_row).description
456: ,p_asset_header_tbl(tab_row).employee_name
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

Line 502: ,fa_distribution_history c

498: ,p_asset_header_tbl(tab_row).description
499: ,l_code_combination_id
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

Line 3300: FROM fa_distribution_history fadh

3296:
3297: CURSOR c_fa_assets ( p_fa_asset_id NUMBER
3298: ,p_location_id NUMBER )IS
3299: SELECT SUM(units_assigned)
3300: FROM fa_distribution_history fadh
3301: WHERE fadh.asset_id = p_fa_asset_id
3302: AND fadh.location_id = p_location_id
3303: AND units_assigned > 0
3304: AND fadh.date_ineffective IS NULL;