eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSE_ASSET_CREATION_PKG dependencies on CSI_ITEM_INSTANCES

Line 330: csi_item_instances_h ciih

326:
327: CURSOR deploy_cur IS
328: SELECT 'Y'
329: FROM csi_transactions ct,
330: csi_item_instances_h ciih
331: WHERE ciih.instance_id = p_instance_id
332: AND ct.transaction_id = ciih.transaction_id
333: AND ct.transaction_date < p_transaction_date
334: AND ct.transaction_type_id in (110, 108, 132, 133);

Line 362: csi_item_instances_h ciih

358: IS
359: CURSOR txn_cur IS
360: SELECT ct.transaction_id
361: FROM csi_transactions ct,
362: csi_item_instances_h ciih
363: WHERE ciih.instance_id = p_instance_id
364: AND ct.transaction_id = ciih.transaction_id
365: AND ct.transaction_id < p_csi_txn_id
366: AND ct.transaction_status_code = 'PENDING';

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 2103: FROM csi_item_instances_h ciih,

2099: cii.instance_usage_code,
2100: cii.quantity,
2101: nvl(ciih.old_quantity,0) old_quantity,
2102: ciih.new_quantity
2103: FROM csi_item_instances_h ciih,
2104: csi_item_instances cii
2105: WHERE ciih.transaction_id = p_csi_txn_id
2106: AND cii.instance_id = ciih.instance_id
2107: AND cii.inventory_item_id = p_inventory_item_id

Line 2104: csi_item_instances cii

2100: cii.quantity,
2101: nvl(ciih.old_quantity,0) old_quantity,
2102: ciih.new_quantity
2103: FROM csi_item_instances_h ciih,
2104: csi_item_instances cii
2105: WHERE ciih.transaction_id = p_csi_txn_id
2106: AND cii.instance_id = ciih.instance_id
2107: AND cii.inventory_item_id = p_inventory_item_id
2108: AND nvl(ciih.new_quantity, 0) - nvl(ciih.old_quantity,0) > 0;

Line 2276: FROM csi_item_instances

2272: LOOP
2273:
2274: SELECT instance_id
2275: INTO l_instance_id
2276: FROM csi_item_instances
2277: WHERE inventory_item_id = l_inventory_item_id
2278: AND serial_number = srl_rec.serial_number;
2279:
2280: get_redeploy_flag(

Line 2882: FROM csi_item_instances cii,

2878: cii.inventory_item_id,
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)

Line 2920: FROM csi_item_instances cii

2916: ,cii.inventory_item_id
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,