APPS.OE_BLANKET_UTIL dependencies on MTL_SYSTEM_ITEMS_B

Line 2063: FROM mtl_system_items_b

2059: oe_debug_pub.add('Blanket In validate INT');
2060: end if;
2061: SELECT 'valid'
2062: INTO l_dummy
2063: FROM mtl_system_items_b
2064: WHERE inventory_item_id = p_inventory_item_id
2065: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
2066: AND customer_order_enabled_flag = 'Y';
2067:

Line 6756: FROM MTL_SYSTEM_ITEMS_B

6752: p_x_line_rec.item_identifier_type NOT IN ('ALL', 'CAT') THEN
6753: BEGIN
6754: SELECT PRIMARY_UOM_CODE
6755: INTO p_x_line_rec.order_quantity_uom
6756: FROM MTL_SYSTEM_ITEMS_B
6757: WHERE INVENTORY_ITEM_ID = p_x_line_rec.inventory_item_id
6758: AND ORGANIZATION_ID = g_header_rec.org_id;
6759: EXCEPTION
6760: WHEN NO_DATA_FOUND THEN