[Home] [Help]
929: := 'SELECT fad.asset_id, fad.asset_number, fad.asset_category_id, fad.asset_key_ccid, '||
930: 'fad.tag_number, fad.description, fad.manufacturer_name, fad.serial_number, '||
931: 'fad.model_number, fad.current_units, fb.book_type_code, '||
932: 'fb.date_placed_in_service, fb.cost, cia.instance_asset_id '||
933: 'FROM fa_books fb, fa_additions fad, csi_i_assets cia, csi_item_instances cii '||
934: 'WHERE fb.asset_id = fad.asset_id '||
935: 'AND fb.date_ineffective is null '||
936: 'AND cia.fa_asset_id = fad.asset_id '||
937: 'AND cii.instance_id = cia.instance_id ';
3217: fb.cost
3218: FROM csi_item_instances cii,
3219: csi_i_assets cia,
3220: fa_books fb,
3221: fa_additions fab
3222: WHERE cii.inventory_item_id = NVL(p_asset_query_rec.inventory_item_id, cii.inventory_item_id)
3223: AND cii.instance_id = cia.instance_id
3224: AND cia.fa_asset_id = fab.asset_id
3225: AND cia.fa_book_type_code = fb.book_type_code
3255: ,fb.cost
3256: FROM csi_item_instances cii
3257: ,csi_i_assets cia
3258: ,fa_books fb
3259: ,fa_additions fab
3260: WHERE cii.inventory_item_id = NVL(p_asset_query_rec.inventory_item_id,
3261: cii.inventory_item_id)
3262: AND cii.instance_id = cia.instance_id
3263: AND cia.fa_asset_id = fab.asset_id
3536: l_total_fa_units NUMBER ;
3537:
3538: CURSOR fa_asset_units (c_asset_id IN NUMBER) IS
3539: SELECT fad.current_units
3540: FROM fa_additions fad
3541: WHERE fad.asset_id = c_asset_id ;
3542:
3543: CURSOR dpi_for_ipv (c_asset_id IN NUMBER, c_book_type_code IN VARCHAR2) IS
3544: SELECT date_placed_in_service
3555: CURSOR prorate_convention_cur (c_book_type_code IN VARCHAR2, c_asset_id IN NUMBER) IS
3556: SELECT fcgd.retirement_prorate_convention
3557: FROM fa_category_book_defaults fcgd
3558: ,fa_books fb
3559: ,fa_additions_b fab
3560: WHERE fb.date_placed_in_service BETWEEN fcgd.start_dpis AND
3561: NVL(fcgd.end_dpis, fb.date_placed_in_service)
3562: AND fb.date_ineffective IS NULL
3563: AND fb.book_type_code = fcgd.book_type_code