DBA Data[Home] [Help]

APPS.INV_UI_ITEM_LOVS dependencies on MTL_ITEM_UOMS_VIEW

Line 747: FROM mtl_item_uoms_view

743: p_Inventory_Item_Id)) uom_code_comp
744: , unit_of_measure
745: , description
746: , uom_class
747: FROM mtl_item_uoms_view
748: WHERE organization_id = p_organization_id
749: AND inventory_item_id = p_inventory_item_id
750: AND uom_code LIKE (l_code)
751: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(uom_code,

Line 799: FROM mtl_item_uoms_view

795: Inventory_Item_Id)) uom_code_comp
796: , unit_of_measure
797: , description
798: , uom_class
799: FROM mtl_item_uoms_view
800: WHERE organization_id = p_organization_id
801: AND inventory_item_id(+) = p_item_id
802: AND NVL(uom_type, 3) = NVL(p_uom_type, 3)
803: AND uom_code LIKE (l_code)

Line 2550: FROM mtl_item_uoms_view

2546: p_Inventory_Item_Id)) uom_code_comp
2547: , unit_of_measure
2548: , description
2549: , uom_class
2550: FROM mtl_item_uoms_view
2551: WHERE organization_id = p_organization_id
2552: AND inventory_item_id = p_inventory_item_id
2553: AND uom_code LIKE (l_code)
2554: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(uom_code,

Line 3118: FROM mtl_item_uoms_view

3114: p_inventory_item_id)) uom_code_comp
3115: , unit_of_measure
3116: , description
3117: , uom_class
3118: FROM mtl_item_uoms_view
3119: WHERE organization_id = p_organization_id
3120: AND inventory_item_id = p_inventory_item_id
3121: AND uom_code LIKE (l_code)
3122: ORDER BY inv_ui_item_lovs.conversion_order(inv_ui_item_lovs.get_conversion_rate(uom_code,

Line 4181: FROM mtl_item_uoms_view miuv, wms_lpn_contents wlc

4177: p_Inventory_Item_Id)) uom_code_comp
4178: , miuv.unit_of_measure
4179: , miuv.description
4180: , miuv.uom_class
4181: FROM mtl_item_uoms_view miuv, wms_lpn_contents wlc
4182: WHERE wlc.organization_id = p_organization_id
4183: AND wlc.inventory_item_id = p_inventory_item_id
4184: AND NVL(wlc.parent_lpn_id, 0) = NVL(p_lpn_id, NVL(wlc.parent_lpn_id, 0))
4185: AND miuv.organization_id = wlc.organization_id

Line 6210: FROM mtl_item_uoms_view

6206: Nvl( p_fulfillment_base,'P'))) uom_code_comp,
6207: unit_of_measure,
6208: description,
6209: uom_class
6210: FROM mtl_item_uoms_view
6211: WHERE organization_id = p_organization_id
6212: AND inventory_item_id = p_item_id
6213: AND Nvl(uom_type, 3) = Nvl(p_uom_type, 3)
6214: AND uom_code LIKE ( l_code ))