APPS.CSI_INV_DISCREPANCY_PKG dependencies on CSI_ITEM_INSTANCES

Line 371: From csi_item_instances

367: , v_inv_org_id
368: , v_inv_subinv_name
369: , v_inv_locator_id
370: , v_inst_usage
371: From csi_item_instances
372: Where inventory_item_id = inventory_item_id_mig(i)
373: And last_vld_organization_id = organization_id_mig(i)
374: And location_type_code = 'INVENTORY'
375: And instance_usage_code = 'IN_INVENTORY'

Line 521: FROM csi_item_instances

517: l_location_type_code,
518: l_instance_usage_code,
519: l_location_id,
520: l_lot_number
521: FROM csi_item_instances
522: WHERE instance_id = p_instance_rec.instance_id;
523:
524: IF (nvl(p_instance_rec.vld_organization_id, fnd_api.g_miss_num) =
525: nvl(l_vld_organization_id, fnd_api.g_miss_num))

Line 759: FROM CSI_ITEM_INSTANCES

755:
756: BEGIN
757: SELECT count(1)
758: INTO l_inst_count
759: FROM CSI_ITEM_INSTANCES
760: WHERE inventory_item_id = srl_rec.inventory_item_id
761: AND ((active_end_date IS NULL) OR (active_end_date > 'SYSDATE'))
762: AND ROWNUM < 2;
763: EXCEPTION

Line 790: FROM CSI_ITEM_INSTANCES

786: SELECT instance_id ,
787: object_version_number
788: INTO l_instance_rec.instance_id,
789: l_instance_rec.object_version_number
790: FROM CSI_ITEM_INSTANCES
791: WHERE inventory_item_id = srl_rec.inventory_item_id
792: AND serial_number = srl_rec.serial_number;
793:
794: l_instance := to_char(l_instance_rec.instance_id);

Line 874: FROM CSI_ITEM_INSTANCES

870: l_location_id,
871: l_lot_number,
872: l_serial_number,
873: l_quantity
874: FROM CSI_ITEM_INSTANCES
875: WHERE instance_id = l_instance_rec.instance_id;
876: END IF;
877:
878: -- Check for any inv material transactions in csi_txn_errors with status of ('E','R')