APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 749: FROM mtl_onhand_quantities_detail moq

745: WHERE NVL(organization_id, p_organization_id) = p_organization_id
746: AND cost_group_type = 3
747: AND cost_group LIKE (p_cost_group)
748: AND cost_group_id IN (SELECT cost_group_id
749: FROM mtl_onhand_quantities_detail moq
750: WHERE organization_id = p_organization_id
751: AND NVL(subinventory_code, '@') = NVL(p_subinventory_code, NVL(subinventory_code, '@'))
752: AND NVL(locator_id, -999) = NVL(TO_NUMBER(p_locator_id), NVL(locator_id, -999))
753: AND inventory_item_id = NVL(TO_NUMBER(p_inventory_item_id), inventory_item_id));