APPS.CSI_PROCESS_TXN_PVT dependencies on CSI_ITEM_INSTANCES

Line 1862: FROM csi_item_instances

1858:
1859: IF nvl(l_location_type_code,fnd_api.g_miss_char) = fnd_api.g_miss_char THEN
1860: SELECT location_type_code
1861: INTO l_location_type_code
1862: FROM csi_item_instances
1863: WHERE instance_id = p_instance_rec.instance_id;
1864: END IF;
1865:
1866: IF p_parties_tbl.COUNT > 0 THEN

Line 2141: FROM csi_item_instances

2137: l_u_instance_rec.call_contracts := p_call_contracts;
2138:
2139: SELECT object_version_number
2140: INTO l_u_instance_rec.object_version_number
2141: FROM csi_item_instances
2142: WHERE instance_id = l_u_instance_rec.instance_id;
2143:
2144: csi_t_gen_utility_pvt.dump_csi_instance_rec(l_u_instance_rec);
2145:

Line 2629: FROM csi_item_instances

2625: SELECT object_version_number,
2626: quantity
2627: INTO l_instance_rec.object_version_number,
2628: l_dest_instance_qty
2629: FROM csi_item_instances
2630: WHERE instance_id = l_dest_instance_id;
2631:
2632: debug('Instance Quantity :'||l_dest_instance_qty);
2633: debug('Transaction Quantity :'||p_instance_rec.quantity);

Line 2764: FROM csi_item_instances

2760: -- Added as part of testing for 3810963. For RMA cancellation we need to
2761: -- check if the instance is expired
2762: SELECT active_end_date
2763: INTO l_active_end_date
2764: FROM csi_item_instances
2765: WHERE instance_id = l_instance_rec.instance_id;
2766:
2767: IF p_in_out_flag <> 'NONE' THEN
2768:

Line 2916: FROM csi_item_instances

2912: END IF;
2913:
2914: SELECT object_version_number
2915: INTO l_instance_rec.object_version_number
2916: FROM csi_item_instances
2917: WHERE instance_id = l_instance_rec.instance_id;
2918:
2919: l_current_procedure := 'update_item_instance';
2920:

Line 2976: FROM csi_item_instances

2972: l_serial_number,
2973: l_mfg_serial_number_flag,
2974: l_active_end_date,
2975: l_owner_party_account_id
2976: FROM csi_item_instances
2977: WHERE instance_id = l_instance_rec.instance_id;
2978:
2979: l_u_instance_rec.instance_id := l_instance_rec.instance_id;
2980: l_u_instance_rec.object_version_number := l_object_version_number;

Line 3242: FROM csi_item_instances

3238: END IF;
3239:
3240: SELECT object_version_number
3241: INTO l_object_version_number
3242: FROM csi_item_instances
3243: WHERE instance_id = l_u_instance_rec.instance_id;
3244:
3245: l_u_instance_rec.object_version_number := l_object_version_number;
3246: l_u_instance_rec.return_by_date := p_instance_rec.return_by_date;

Line 3441: FROM csi_item_instances

3437: SELECT quantity,
3438: object_version_number
3439: INTO l_dest_instance_qty,
3440: l_object_version_number
3441: FROM csi_item_instances
3442: WHERE instance_id = l_dest_instance_id;
3443:
3444: l_u_instance_rec := l_dummy_instance_rec;
3445:

Line 3563: FROM csi_item_instances

3559: active_end_date
3560: INTO l_object_version_number,
3561: l_src_instance_qty,
3562: l_active_end_date
3563: FROM csi_item_instances
3564: WHERE instance_id = l_src_instance_id;
3565:
3566: debug(' src_instance_id : '||l_src_instance_id);
3567: debug(' quantity : '||l_src_instance_qty);

Line 3637: FROM csi_item_instances

3633: l_object_version_number,
3634: l_active_end_date,
3635: l_location_type_code,
3636: l_instance_usage_code
3637: FROM csi_item_instances
3638: WHERE inventory_item_id = l_instance_rec.inventory_item_id
3639: AND serial_number = l_instance_rec.serial_number;
3640:
3641: debug('returned customer product found');

Line 4065: FROM csi_item_instances cii

4061: l_instance_end_date DATE;
4062:
4063: CURSOR exp_inst_cur(p_instance_id in number) IS
4064: SELECT cii.active_end_date
4065: FROM csi_item_instances cii
4066: WHERE cii.instance_id = p_instance_id
4067: AND cii.active_end_date is not null
4068: AND EXISTS (
4069: SELECT 'X' from csi_ii_relationships cir

Line 4113: from CSI_ITEM_INSTANCES

4109: select config_inst_hdr_id,config_inst_item_id,config_inst_rev_num,
4110: instance_usage_code,active_end_date
4111: into l_instance_inst_hdr_id,l_instance_inst_item_id,
4112: l_instance_inst_rev_num,l_instance_usage_code,l_instance_end_date
4113: from CSI_ITEM_INSTANCES
4114: where instance_id = p_instance_id;
4115: --
4116: IF l_locked = TRUE THEN
4117: debug('Instance '||p_instance_id||' is Locked. Updating TLD and Unlocking it..');