APPS.CSE_ASSET_CREATION_PKG dependencies on CSI_I_ASSETS

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 1140: 'FROM fa_mass_additions fma, csi_i_assets cia, csi_item_instances cii ';

1136: 'fma.date_placed_in_service, '||
1137: 'fma.reviewer_comments, '||
1138: 'fma.feeder_system_name, '||
1139: 'cia.instance_asset_id '||
1140: 'FROM fa_mass_additions fma, csi_i_assets cia, csi_item_instances cii ';
1141:
1142: l_where_clause varchar2(240);
1143: l_and_clause varchar2(540);
1144:

Line 1357: FROM csi_i_assets

1353: SELECT asset_quantity + p_inst_rec.quantity,
1354: object_version_number
1355: INTO l_inst_asset_rec.asset_quantity,
1356: l_inst_asset_rec.object_version_number
1357: FROM csi_i_assets
1358: WHERE instance_asset_id = l_inst_asset_rec.instance_asset_id;
1359:
1360: l_inst_asset_rec.fa_book_type_code := p_inst_rec.book_type_code;
1361: l_inst_asset_rec.fa_asset_id := p_asset_id;

Line 1480: FROM csi_i_assets

1476: SELECT asset_quantity + p_inst_rec.quantity,
1477: object_version_number
1478: INTO l_inst_asset_rec.asset_quantity,
1479: l_inst_asset_rec.object_version_number
1480: FROM csi_i_assets
1481: WHERE instance_asset_id = l_inst_asset_rec.instance_asset_id;
1482:
1483: l_inst_asset_rec.fa_book_type_code := p_inst_rec.book_type_code;
1484: l_inst_asset_rec.fa_mass_addition_id := p_mass_addition_id;

Line 2883: csi_i_assets cia,

2879: fb.book_type_code,
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

Line 2921: ,csi_i_assets cia

2917: ,fb.book_type_code
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)