DBA Data[Home] [Help]

APPS.CST_MGD_MSTR_BOOK_RPT dependencies on MTL_ONHAND_QUANTITIES

Line 2916: FROM mtl_onhand_quantities

2912: -- Bug#2576310 to add the sub inventory range the where condition
2913: -- bug#3147073 : exclude non asset subinventories
2914: SELECT NVL (SUM (transaction_quantity), 0)
2915: INTO l_item_ohq
2916: FROM mtl_onhand_quantities
2917: WHERE inventory_item_id = l_item_id
2918: AND organization_id = p_org_id
2919: AND subinventory_code BETWEEN NVL (p_subinv_from, subinventory_code)
2920: AND NVL (p_subinv_to, subinventory_code)