APPS.INV_UI_ITEM_LOVS dependencies on MTL_ITEM_UOMS_VIEW

Line 643: FROM mtl_item_uoms_view

639: p_Inventory_Item_Id)) uom_code_comp
640: , unit_of_measure
641: , description
642: , uom_class
643: FROM mtl_item_uoms_view
644: WHERE organization_id = p_organization_id
645: AND inventory_item_id = p_inventory_item_id
646: AND uom_code LIKE (l_code)
647: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(uom_code,

Line 695: FROM mtl_item_uoms_view

691: Inventory_Item_Id)) uom_code_comp
692: , unit_of_measure
693: , description
694: , uom_class
695: FROM mtl_item_uoms_view
696: WHERE organization_id = p_organization_id
697: AND inventory_item_id(+) = p_item_id
698: AND NVL(uom_type, 3) = NVL(p_uom_type, 3)
699: AND uom_code LIKE (l_code)

Line 2409: FROM mtl_item_uoms_view

2405: p_Inventory_Item_Id)) uom_code_comp
2406: , unit_of_measure
2407: , description
2408: , uom_class
2409: FROM mtl_item_uoms_view
2410: WHERE organization_id = p_organization_id
2411: AND inventory_item_id = p_inventory_item_id
2412: AND uom_code LIKE (l_code)
2413: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(uom_code,

Line 2963: FROM mtl_item_uoms_view

2959: p_inventory_item_id)) uom_code_comp
2960: , unit_of_measure
2961: , description
2962: , uom_class
2963: FROM mtl_item_uoms_view
2964: WHERE organization_id = p_organization_id
2965: AND inventory_item_id = p_inventory_item_id
2966: AND uom_code LIKE (l_code)
2967: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(uom_code,

Line 3934: FROM mtl_item_uoms_view miuv, wms_lpn_contents wlc

3930: p_Inventory_Item_Id)) uom_code_comp
3931: , miuv.unit_of_measure
3932: , miuv.description
3933: , miuv.uom_class
3934: FROM mtl_item_uoms_view miuv, wms_lpn_contents wlc
3935: WHERE wlc.organization_id = p_organization_id
3936: AND wlc.inventory_item_id = p_inventory_item_id
3937: AND NVL(wlc.parent_lpn_id, 0) = NVL(p_lpn_id, NVL(wlc.parent_lpn_id, 0))
3938: AND miuv.organization_id = wlc.organization_id