DBA Data[Home] [Help]

APPS.CST_MGD_MSTR_BOOK_RPT dependencies on MTL_ONHAND_QUANTITIES

Line 1245: FROM mtl_onhand_quantities

1241: -- Bug#2576310 to add the sub inventory range the where condition
1242: -- bug#3147073 : exclude non asset subinventories
1243: SELECT NVL(SUM(transaction_quantity),0)
1244: INTO l_item_ohq
1245: FROM mtl_onhand_quantities
1246: WHERE inventory_item_id = l_item_id
1247: AND organization_id = p_org_id
1248: AND subinventory_code BETWEEN nvl(p_subinv_from,subinventory_code)
1249: AND nvl(p_subinv_to,subinventory_code)