APPS.CSE_ASSET_CREATION_PKG dependencies on FA_BOOKS

Line 892: 'FROM fa_books fb, fa_additions fad, csi_i_assets cia, csi_item_instances cii '||

888: := 'SELECT fad.asset_id, fad.asset_number, fad.asset_category_id, fad.asset_key_ccid, '||
889: 'fad.tag_number, fad.description, fad.manufacturer_name, fad.serial_number, '||
890: 'fad.model_number, fad.current_units, fb.book_type_code, '||
891: 'fb.date_placed_in_service, fb.cost, cia.instance_asset_id '||
892: 'FROM fa_books fb, fa_additions fad, csi_i_assets cia, csi_item_instances cii '||
893: 'WHERE fb.asset_id = fad.asset_id '||
894: 'AND fb.date_ineffective is null '||
895: 'AND cia.fa_asset_id = fad.asset_id '||
896: 'AND cii.instance_id = cia.instance_id ';

Line 1965: FROM fa_books

1961: l_mass_add_rec.add_to_asset_id := p_asset_id;
1962:
1963: SELECT date_placed_in_service
1964: INTO l_mass_add_rec.date_placed_in_service
1965: FROM fa_books
1966: WHERE asset_id = p_asset_id
1967: AND book_type_code = p_instance_rec.book_type_code
1968: AND date_ineffective is null;
1969:

Line 2884: fa_books fb,

2880: fb.date_placed_in_service,
2881: fb.cost
2882: FROM csi_item_instances cii,
2883: csi_i_assets cia,
2884: fa_books fb,
2885: fa_additions fab
2886: WHERE cii.inventory_item_id = NVL(p_asset_query_rec.inventory_item_id, cii.inventory_item_id)
2887: AND cii.instance_id = cia.instance_id
2888: AND cia.fa_asset_id = fab.asset_id

Line 2922: ,fa_books fb

2918: ,fb.date_placed_in_service
2919: ,fb.cost
2920: FROM csi_item_instances cii
2921: ,csi_i_assets cia
2922: ,fa_books fb
2923: ,fa_additions fab
2924: WHERE cii.inventory_item_id = NVL(p_asset_query_rec.inventory_item_id,
2925: cii.inventory_item_id)
2926: AND cii.instance_id = cia.instance_id

Line 3209: FROM fa_books

3205: WHERE fad.asset_id = c_asset_id ;
3206:
3207: CURSOR dpi_for_ipv (c_asset_id IN NUMBER, c_book_type_code IN VARCHAR2) IS
3208: SELECT date_placed_in_service
3209: FROM fa_books
3210: WHERE asset_id = c_asset_id
3211: AND book_type_code = c_book_type_code ;
3212:
3213: CURSOR get_group_asset_id_cur (c_asset_category_id IN NUMBER, c_book_type_code IN VARCHAR2) IS

Line 3222: ,fa_books fb

3218:
3219: CURSOR prorate_convention_cur (c_book_type_code IN VARCHAR2, c_asset_id IN NUMBER) IS
3220: SELECT fcgd.retirement_prorate_convention
3221: FROM fa_category_book_defaults fcgd
3222: ,fa_books fb
3223: ,fa_additions_b fab
3224: WHERE fb.date_placed_in_service BETWEEN fcgd.start_dpis AND
3225: NVL(fcgd.end_dpis, fb.date_placed_in_service)
3226: AND fb.date_ineffective IS NULL