DBA Data[Home] [Help]

APPS.OE_BLANKET_UTIL dependencies on MTL_SYSTEM_ITEMS_B

Line 2205: FROM mtl_system_items_b

2201: oe_debug_pub.add('Blanket In validate INT');
2202: end if;
2203: SELECT 'valid'
2204: INTO l_dummy
2205: FROM mtl_system_items_b
2206: WHERE inventory_item_id = p_inventory_item_id
2207: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
2208: AND customer_order_enabled_flag = 'Y';
2209:

Line 6950: FROM MTL_SYSTEM_ITEMS_B

6946: p_x_line_rec.item_identifier_type NOT IN ('ALL', 'CAT') THEN
6947: BEGIN
6948: SELECT PRIMARY_UOM_CODE
6949: INTO p_x_line_rec.order_quantity_uom
6950: FROM MTL_SYSTEM_ITEMS_B
6951: WHERE INVENTORY_ITEM_ID = p_x_line_rec.inventory_item_id
6952: AND ORGANIZATION_ID = g_header_rec.org_id;
6953: EXCEPTION
6954: WHEN NO_DATA_FOUND THEN