APPS.CSE_ASSET_CREATION_PKG dependencies on CSI_I_ASSETS

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

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 ';

Line 1181: 'FROM fa_mass_additions fma, csi_i_assets cia, csi_item_instances cii ';

1177: 'fma.date_placed_in_service, '||
1178: 'fma.reviewer_comments, '||
1179: 'fma.feeder_system_name, '||
1180: 'cia.instance_asset_id '||
1181: 'FROM fa_mass_additions fma, csi_i_assets cia, csi_item_instances cii ';
1182:
1183: l_where_clause varchar2(240);
1184: l_and_clause varchar2(540);
1185:

Line 1398: FROM csi_i_assets

1394: SELECT asset_quantity + p_inst_rec.quantity,
1395: object_version_number
1396: INTO l_inst_asset_rec.asset_quantity,
1397: l_inst_asset_rec.object_version_number
1398: FROM csi_i_assets
1399: WHERE instance_asset_id = l_inst_asset_rec.instance_asset_id;
1400:
1401: l_inst_asset_rec.fa_book_type_code := p_inst_rec.book_type_code;
1402: l_inst_asset_rec.fa_asset_id := p_asset_id;

Line 1521: FROM csi_i_assets

1517: SELECT asset_quantity + p_inst_rec.quantity,
1518: object_version_number
1519: INTO l_inst_asset_rec.asset_quantity,
1520: l_inst_asset_rec.object_version_number
1521: FROM csi_i_assets
1522: WHERE instance_asset_id = l_inst_asset_rec.instance_asset_id;
1523:
1524: l_inst_asset_rec.fa_book_type_code := p_inst_rec.book_type_code;
1525: l_inst_asset_rec.fa_mass_addition_id := p_mass_addition_id;

Line 2474: csi_i_assets cia

2470: SELECT 'Y'
2471: INTO l_asset_exists
2472: FROM csi_item_instances_h CIIH,
2473: csi_item_instances CII,
2474: csi_i_assets cia
2475: WHERE CIIH.transaction_id = csi_txn_rec.transaction_id
2476: AND CIIH.instance_id = CII.instance_id
2477: AND CII.instance_id = CIA.instance_id
2478: AND CII.inventory_item_id = l_inventory_item_id

Line 2492: csi_i_assets CIA

2488: SELECT 'Y'
2489: INTO l_asset_exists
2490: FROM csi_item_instances_h CIIH,
2491: csi_item_instances CII,
2492: csi_i_assets CIA
2493: WHERE CIIH.transaction_id = csi_txn_rec.transaction_id
2494: AND CII.instance_id = CIIH.instance_id
2495: AND CII.inventory_item_id = l_inventory_item_id
2496: AND nvl(CIIH.new_quantity, 0) - nvl(CIIH.old_quantity,0) < 0

Line 3219: csi_i_assets cia,

3215: fb.book_type_code,
3216: fb.date_placed_in_service,
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

Line 3257: ,csi_i_assets cia

3253: ,fb.book_type_code
3254: ,fb.date_placed_in_service
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)