APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on MTL_SYSTEM_ITEMS

Line 2128: FROM mtl_system_items

2124: , discrete_item_id IN NUMBER) IS
2125: SELECT tracking_quantity_ind,
2126: secondary_uom_code,
2127: secondary_default_ind
2128: FROM mtl_system_items
2129: WHERE organization_id = discrete_org_id
2130: AND inventory_item_id = discrete_item_id;
2131:
2132:

Line 3641: oe_debug_pub.add( 'INVALID ORDERED_QUANTITY_UOM2... does not match mtl_system_items' ) ;

3637: FND_MESSAGE.SET_NAME('PO','PO_INCORRECT_SECONDARY_UOM'); -- INVCONV
3638: OE_MSG_PUB.Add;
3639: p_return_status := FND_API.G_RET_STS_ERROR;
3640: IF l_debug_level > 0 THEN
3641: oe_debug_pub.add( 'INVALID ORDERED_QUANTITY_UOM2... does not match mtl_system_items' ) ;
3642: END IF;
3643:
3644: END IF; -- IF ( p_x_line_tbl(I).ordered_quantity_uom2 <> NULL
3645: END IF; --IF l_tracking_quantity_ind <> 'PS' then -- INVCONV

Line 4355: FROM mtl_system_items_vl

4351: oe_debug_pub.add( 'IN OEXVIMSB ITEM IDENTIFIER IS INT' ) ;
4352: END IF;
4353: SELECT inventory_item_id
4354: INTO l_inventory_item_id_int
4355: FROM mtl_system_items_vl
4356: WHERE concatenated_segments = p_x_line_val_tbl(I).inventory_item
4357: AND customer_order_enabled_flag = 'Y'
4358: AND bom_item_type in (1,2,4)
4359: AND organization_id =

Line 4408: FROM mtl_system_items_vl

4404: oe_debug_pub.add( 'IN OEXVIMSB ITEM IDENTIFIER IS INT WITH ORDERED_ITEM' ) ;
4405: END IF;
4406: SELECT inventory_item_id
4407: INTO l_inventory_item_id_ord
4408: FROM mtl_system_items_vl
4409: WHERE concatenated_segments = p_x_line_tbl(I).ordered_item
4410: AND customer_order_enabled_flag = 'Y'
4411: AND bom_item_type in (1,2,4)
4412: AND organization_id =