[Home] [Help]
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 ';
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
2889: AND cia.fa_book_type_code = fb.book_type_code
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
2927: AND cia.fa_asset_id = fab.asset_id
3200: l_total_fa_units NUMBER ;
3201:
3202: CURSOR fa_asset_units (c_asset_id IN NUMBER) IS
3203: SELECT fad.current_units
3204: FROM fa_additions fad
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
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
3227: AND fb.book_type_code = fcgd.book_type_code