APPS.GMF_CMCOMMON dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 682: FROM mtl_onhand_quantities_detail moqd, mtl_secondary_inventories msi

678: -- ?? What about negative on hands in both the cursors ??
679:
680: CURSOR cur_moqd (v_inventory_item_id NUMBER, v_organization_id NUMBER) IS
681: SELECT nvl(sum(moqd.primary_transaction_quantity), 0) qty, lot_number
682: FROM mtl_onhand_quantities_detail moqd, mtl_secondary_inventories msi
683: WHERE moqd.organization_id = v_organization_id
684: AND moqd.inventory_item_id = v_inventory_item_id
685: AND moqd.is_consigned = 2
686: AND msi.secondary_inventory_name = moqd.subinventory_code

Line 939: -- get the lots and lot qty from mtl_onhand_quantities_detail;

935: END IF;
936:
937: ELSIF (p_from_where = 'MOQD') THEN -- add item lot costed check as well??
938:
939: -- get the lots and lot qty from mtl_onhand_quantities_detail;
940:
941: FOR cur_moqd_rec IN cur_moqd (p_inventory_item_id, p_organization_id)
942: LOOP
943: l_cum_qty := l_cum_qty + cur_moqd_rec.qty;