APPS.CSM_EMAIL_QUERY_PKG dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 2332: FROM MTL_ONHAND_QUANTITIES_DETAIL

2328:
2329: CURSOR C_GET_SUBINV(p_inv_item_id NUMBER, p_ORG_ID NUMBER)
2330: IS
2331: SELECT SUBINVENTORY_CODE
2332: FROM MTL_ONHAND_QUANTITIES_DETAIL
2333: WHERE INVENTORY_ITEM_ID = p_INV_ITEM_ID
2334: AND ORGANIZATION_ID = p_ORG_ID
2335: GROUP BY INVENTORY_ITEM_ID, ORGANIZATION_ID, SUBINVENTORY_CODE
2336: HAVING SUM (TRANSACTION_QUANTITY) > 0 ;