DBA Data[Home] [Help]

APPS.OKS_UTIL_PUB dependencies on CSI_ITEM_INSTANCES

Line 738: csi_item_instances csi

734: -- Covered Products
735: CURSOR prodcur IS
736: SELECT concatenated_segments name
737: FROM mtl_system_items_b_kfv mtl,
738: csi_item_instances csi
739: WHERE mtl.inventory_item_id = csi.inventory_item_id
740: AND mtl.organization_id = csi.inv_master_organization_id
741: AND csi.instance_id = to_number(p_object1_id1);
742:

Line 779: csi_item_instances csi

775: -- Covered Product Counters
776: CURSOR cpctrcur(p_instance_id IN NUMBER) IS
777: SELECT concatenated_segments name
778: FROM mtl_system_items_b_kfv mtl,
779: csi_item_instances csi
780: WHERE mtl.inventory_item_id = csi.inventory_item_id
781: AND mtl.organization_id = csi.inv_master_organization_id
782: AND csi.instance_id = p_instance_id;
783: -- Service Counters