DBA Data[Home] [Help]

APPS.AHL_OSP_ORDERS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 5014: FROM mtl_system_items_b

5010: --calculate the onhand quantity correctly.
5011: CURSOR get_onhand_quantity(c_inv_item_id NUMBER, c_inv_org_id NUMBER, c_subinv VARCHAR2, c_lot_number VARCHAR2) IS
5012: --Added by mpothuku on 23rd Aug, 06 to fix the Bug 5252627
5013: SELECT ahl_osp_queries_pvt.get_onhand_quantity(c_inv_org_id, c_subinv, c_inv_item_id, c_lot_number) onhand_quantity, primary_uom_code uom_code
5014: FROM mtl_system_items_b
5015: WHERE inventory_item_id = c_inv_item_id
5016: AND organization_id = c_inv_org_id;
5017: CURSOR check_phy_ser_item_unique(c_osp_order_id NUMBER,
5018: c_service_item_id NUMBER,