APPS.CSI_RMA_RECEIPT_PUB dependencies on CSI_ITEM_INSTANCES

Line 1327: FROM csi_item_instances

1323: BEGIN
1324:
1325: SELECT quantity
1326: INTO l_instance_quantity
1327: FROM csi_item_instances
1328: WHERE instance_id = l_instances_tbl(l_ind).instance_id;
1329: /* We do not do this anymore.Complete RMA cancellations are always Expire cases. Bug 3746600 .
1330: IF l_line_dtl_tbl(1).reference_source_id is NOT NULL
1331: AND l_line_dtl_tbl(1).reference_source_line_id is NOT NULL THEN

Line 1957: from csi_item_instances

1953: IF p_item_control_rec.serial_control_code = 1 THEN -- non serilized / lot
1954: Begin
1955: Select quantity
1956: into l_inst_qty
1957: from csi_item_instances
1958: where instance_id = l_mtl_txn_rec.instance_id
1959: and sysdate between nvl(active_end_date, sysdate-1) and sysdate+1;
1960: Exception when others then
1961: fnd_message.set_name('CSI','CSI_UNEXP_SQL_ERROR');

Line 2868: FROM csi_item_instances

2864: END IF;
2865: Begin
2866: SELECT object_version_number, active_end_date
2867: INTO l_obj_ver_num, l_end_date
2868: FROM csi_item_instances
2869: WHERE instance_id = l_tld_inst_tbl(i).instance_id;
2870: Exception
2871: when others then
2872: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_INST_REF');

Line 2946: FROM csi_item_instances

2942: END IF;
2943: Begin
2944: SELECT quantity, active_end_date, object_version_number
2945: INTO l_quantity1, l_end_date, l_obj_ver_num
2946: FROM csi_item_instances
2947: WHERE instance_id = l_tld_inst_tbl(m).instance_id;
2948: Exception
2949: when others then
2950: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_INST_REF');

Line 3267: FROM csi_item_instances

3263:
3264: BEGIN
3265: SELECT object_version_number
3266: INTO l_chg_instance_rec.object_version_number
3267: FROM csi_item_instances
3268: WHERE instance_id = l_instances_tbl(i_ind).instance_id;
3269:
3270: EXCEPTION
3271: WHEN no_data_found THEN

Line 3500: FROM csi_item_instances

3496:
3497: BEGIN
3498: SELECT quantity, active_end_date
3499: INTO l_quantity2, l_active_end_date
3500: FROM csi_item_instances
3501: WHERE instance_id = l_instances_tbl(i_ind).instance_id;
3502:
3503: debug('Original Instance Quantity: '||l_quantity2);
3504:

Line 3571: FROM csi_item_instances

3567: THEN -- expire the instance back.
3568:
3569: SELECT object_version_number
3570: INTO l_exp_instance_rec.object_version_number
3571: FROM csi_item_instances
3572: WHERE instance_id = l_instances_tbl(i_ind).instance_id;
3573:
3574: l_exp_instance_rec.instance_id := l_instances_tbl(i_ind).instance_id;
3575: l_exp_instance_rec.call_contracts := fnd_api.g_false;