APPS.CSD_ISUP_DEPOT_WF_PVT dependencies on CSI_ITEM_INSTANCES

Line 247: FROM csi_item_instances

243: IF l_current_serial_number IS NOT NULL AND l_customer_product_id IS NULL THEN
244: BEGIN
245: SELECT instance_id
246: INTO l_customer_product_id
247: FROM csi_item_instances
248: WHERE inventory_item_id = l_inventory_item_id
249: AND serial_number = l_current_serial_number
250: AND sysdate BETWEEN trunc(NVL(active_start_date, sysdate -1)) AND
251: trunc(NVL(active_end_date,sysdate+1));