APPS.CSI_RMA_RECEIPT_PUB dependencies on CSI_ITEM_INSTANCES

Line 1335: FROM csi_item_instances

1331: BEGIN
1332:
1333: SELECT quantity
1334: INTO l_instance_quantity
1335: FROM csi_item_instances
1336: WHERE instance_id = l_instances_tbl(l_ind).instance_id;
1337: /* We do not do this anymore.Complete RMA cancellations are always Expire cases. Bug 3746600 .
1338: IF l_line_dtl_tbl(1).reference_source_id is NOT NULL
1339: AND l_line_dtl_tbl(1).reference_source_line_id is NOT NULL THEN

Line 1969: from csi_item_instances

1965: IF p_item_control_rec.serial_control_code = 1 THEN -- non serilized / lot
1966: Begin
1967: Select quantity
1968: into l_inst_qty
1969: from csi_item_instances
1970: where instance_id = l_mtl_txn_rec.instance_id
1971: and sysdate < nvl(active_end_date, sysdate+1); -- changed for bug#14364807
1972: --and sysdate between nvl(active_end_date, sysdate-1) and sysdate+1; -- commented for bug # 14364807
1973: Exception when others then

Line 2907: FROM csi_item_instances

2903: END IF;
2904: Begin
2905: SELECT object_version_number, active_end_date
2906: INTO l_obj_ver_num, l_end_date
2907: FROM csi_item_instances
2908: WHERE instance_id = l_tld_inst_tbl(i).instance_id;
2909: Exception
2910: when others then
2911: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_INST_REF');

Line 2985: FROM csi_item_instances

2981: END IF;
2982: Begin
2983: SELECT quantity, active_end_date, object_version_number
2984: INTO l_quantity1, l_end_date, l_obj_ver_num
2985: FROM csi_item_instances
2986: WHERE instance_id = l_tld_inst_tbl(m).instance_id;
2987: Exception
2988: when others then
2989: FND_MESSAGE.set_name('CSI','CSI_TXN_INVALID_INST_REF');

Line 3306: FROM csi_item_instances

3302:
3303: BEGIN
3304: SELECT object_version_number
3305: INTO l_chg_instance_rec.object_version_number
3306: FROM csi_item_instances
3307: WHERE instance_id = l_instances_tbl(i_ind).instance_id;
3308:
3309: EXCEPTION
3310: WHEN no_data_found THEN

Line 3539: FROM csi_item_instances

3535:
3536: BEGIN
3537: SELECT quantity, active_end_date
3538: INTO l_quantity2, l_active_end_date
3539: FROM csi_item_instances
3540: WHERE instance_id = l_instances_tbl(i_ind).instance_id;
3541:
3542: debug('Original Instance Quantity: '||l_quantity2);
3543:

Line 3610: FROM csi_item_instances

3606: THEN -- expire the instance back.
3607:
3608: SELECT object_version_number
3609: INTO l_exp_instance_rec.object_version_number
3610: FROM csi_item_instances
3611: WHERE instance_id = l_instances_tbl(i_ind).instance_id;
3612:
3613: l_exp_instance_rec.instance_id := l_instances_tbl(i_ind).instance_id;
3614: l_exp_instance_rec.call_contracts := fnd_api.g_false;