APPS.OKS_UTIL_PUB dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 730: FROM mtl_system_items_b_kfv

726: p_object1_id2 IN VARCHAR2 ) RETURN VARCHAR2 IS
727: -- Covered Items
728: CURSOR itemcur IS
729: SELECT concatenated_segments name
730: FROM mtl_system_items_b_kfv
731: WHERE inventory_item_id = to_number(p_object1_id1)
732: and organization_id = to_number(p_object1_id2);
733:
734: -- Covered Products

Line 737: FROM mtl_system_items_b_kfv mtl,

733:
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);

Line 778: FROM mtl_system_items_b_kfv mtl,

774: WHERE csi.counter_id = to_number(p_object1_id1);
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;

Line 786: FROM mtl_system_items_b_kfv mtl,

782: AND csi.instance_id = p_instance_id;
783: -- Service Counters
784: CURSOR svcctrcur(p_line_id IN NUMBER) IS
785: SELECT concatenated_segments name
786: FROM mtl_system_items_b_kfv mtl,
787: okc_k_items item
788: WHERE mtl.inventory_item_id = to_number(item.object1_id1)
789: AND mtl.organization_id = to_number(item.object1_id2)
790: AND item.cle_id = p_line_id;