DBA Data[Home] [Help]

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 3638: oe_debug_pub.add( 'INVALID ORDERED_QUANTITY_UOM2... does not match mtl_system_items' ) ;

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

Line 4352: FROM mtl_system_items_vl

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

Line 4405: FROM mtl_system_items_vl

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