DBA Data[Home] [Help]

APPS.INV_CONVERT dependencies on INV_UI_ITEM_LOVS

Line 1046: SELECT pick_uom_code, inv_ui_item_lovs.get_conversion_rate(pick_uom_code, p_org_Id, p_item_Id)

1042: END IF;
1043:
1044: if (p_loc_id IS NOT NULL) THEN
1045: begin
1046: SELECT pick_uom_code, inv_ui_item_lovs.get_conversion_rate(pick_uom_code, p_org_Id, p_item_Id)
1047: INTO l_loc_uom, l_uom_string
1048: FROM mtl_item_locations
1049: WHERE organization_id = p_org_id
1050: AND subinventory_code = p_sub_code

Line 1069: SELECT pick_uom_code, inv_ui_item_lovs.get_conversion_rate(pick_uom_code,

1065: end if;
1066:
1067: if (l_loc_uom IS NULL) THEN
1068: begin
1069: SELECT pick_uom_code, inv_ui_item_lovs.get_conversion_rate(pick_uom_code,
1070: p_org_Id,
1071: p_item_Id)
1072: INTO l_loc_uom, l_uom_string
1073: FROM MTL_SECONDARY_INVENTORIES