APPS.OE_BLANKET_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 2175: , mtl_system_items_vl sitems

2171: SELECT DECODE(items.org_independent_flag, 'Y', 1,
2172: DECODE(items.organization_id, item_val_org, 1, 2))
2173: FROM mtl_cross_reference_types types
2174: , mtl_cross_references items
2175: , mtl_system_items_vl sitems
2176: WHERE types.cross_reference_type = items.cross_reference_type
2177: AND items.inventory_item_id = sitems.inventory_item_id
2178: AND sitems.organization_id = item_val_org
2179: AND sitems.inventory_item_id = p_inventory_item_id

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 2218: ,mtl_system_items_vl sitems

2214: SELECT 'valid'
2215: INTO l_dummy
2216: FROM mtl_customer_items citems
2217: ,mtl_customer_item_xrefs cxref
2218: ,mtl_system_items_vl sitems
2219: WHERE citems.customer_item_id = cxref.customer_item_id
2220: AND cxref.inventory_item_id = sitems.inventory_item_id
2221: AND sitems.inventory_item_id = p_inventory_item_id
2222: AND sitems.organization_id =

Line 2315: from MTL_SYSTEM_ITEMS

2311: ELSE
2312: IF p_inventory_item_id IS NOT NULL THEN
2313: select service_item_flag,bom_item_type
2314: into l_service_item_flag, l_bom_item_type
2315: from MTL_SYSTEM_ITEMS
2316: where inventory_item_id = p_inventory_item_id
2317: AND organization_id = l_item_org;
2318: END IF;
2319:

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