DBA Data[Home] [Help]

APPS.OZF_SD_REQUEST_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 425: FROM mtl_system_items_b MTLITM1,

421: SELECT MTLUOM2.uom_code
422: FROM mtl_units_of_measure_vl MTLUOM2
423: WHERE EXISTS
424: (SELECT /*+no_unnest*/ 1
425: FROM mtl_system_items_b MTLITM1,
426: mtl_uom_conversions MTLUCV
427: WHERE MTLUOM2.uom_code = MTLUCV.uom_code
428: AND MTLITM1.organization_id = p_org_id
429: AND MTLITM1.inventory_item_id IN