DBA Data[Home] [Help]

APPS.CSD_REPAIRS_UTIL dependencies on CSI_ITEM_INSTANCES

Line 1278: Select object_version_number from csi_item_instances

1274: and nvl(active_end_date, sysdate+1);
1275:
1276: -- Cursor to derive the Instance details
1277: Cursor c_instance_details(p_instance_id number) IS
1278: Select object_version_number from csi_item_instances
1279: where instance_id = p_instance_id;
1280:
1281: -- Cursor to derive the Instance Account Id
1282: Cursor c_instance_account(p_instance_party_id number) is

Line 3357: FROM csi_item_instances

3353: -- get the instance id.
3354: BEGIN
3355: SELECT instance_id
3356: INTO l_instance_id
3357: FROM csi_item_instances
3358: WHERE inventory_item_id = l_ship_inv_item_id
3359: AND serial_number = l_serial_number;
3360: EXCEPTION
3361: WHEN NO_DATA_FOUND THEN