APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 691: FROM mtl_onhand_quantities_detail moq

687: WHERE NVL(organization_id, p_organization_id) = p_organization_id
688: AND cost_group_type = 3
689: AND cost_group LIKE (p_cost_group)
690: AND cost_group_id IN (SELECT cost_group_id
691: FROM mtl_onhand_quantities_detail moq
692: WHERE organization_id = p_organization_id
693: AND NVL(subinventory_code, '@') = NVL(p_subinventory_code, NVL(subinventory_code, '@'))
694: AND NVL(locator_id, -999) = NVL(TO_NUMBER(p_locator_id), NVL(locator_id, -999))
695: AND inventory_item_id = NVL(TO_NUMBER(p_inventory_item_id), inventory_item_id));